Get latest QueueItems with status anything except New & In Progress using Orchestrator API

[ashokkarale]

I’m trying to get the latest ‘N’ number of QueueItems from Queue using Orchestrator API.

What should be the $filter query here?

I’m trying with /odata/QueueItems endpoint. Any other approaches are also welcome!

Thanks,
Ashok

[ppr (Peter Preuss)]

you would filter on the status and order it on a date property (created, last processed… what you will define that fits to your case)

[ashokkarale]

Can you suggest sample filter query/string @ppr?

Thanks,
Ashok

[ppr (Peter Preuss)]

give a try at

And extend it when filtering on a queue is to add as well
QueueDefinitionId eq 123456 And (Status in ('New', 'InProgress') eq false)

QueueDefinitioId you can retrieve also from api when not known

[ppr (Peter Preuss)]

@ppr

QueueDefinitionId eq 123456 And (Status in (‘New’, ‘InProgress’) eq false)

Alternate:
QueueDefinitionId eq 123456 And Not Status in ('New', 'InProgress')

[ashokkarale]

@ppr,

Thanks a lot! It’s giving me non New and In Progress queue items. Any suggestion how can I get latest n only not the oldest?

Also, where is documentation for these filter queries?

Thanks,
Ashok