Http request - get queue items with EndProcessing within last 5 minutes

[muehlbauer157]

Hey everyone,

so I’m trying to get all queue items with EndProcessing within last e.g. 5 minutes. How do I write that using OData Notation?

I got the queue id etc. yet I don’t know how to write the filter correctly, see highlighted part (XYZ).

Anyone any ideas?

[Anil_G (Anil Gorthi)]

@muehlbauer157

try this

QueueDefinitionId eq 123 & EndProcessing ge 'Now.AddMinutes(-5).ToString("yyyy-MM-ddTHH:mm:ssZ")'

cheers

[muehlbauer157]

This works now, thanks! Yet somehow if I’m giving an exact date, it doesn’t work. Do you know why?

Info of qItem

OData String

Result

[Anil_G (Anil Gorthi)]

@muehlbauer157

please try using & instead of and

cheers

[muehlbauer157]

& - another system query option (e.g. orderby, etc.)
and - another condition (as e.g. in my filter)

I have to use “and”. With “&” it’s not working at all anymore.

[muehlbauer157]

This also only worked for “and” instead of “&”. Sorry for not mentioning.

[muehlbauer157]

it works if I don’t use ’