GetJobs activity Filter Property Query List and Samples

Hi everyone,

About the ‘Get Jobs’ activity’, I’ve been trying to find those words that one can use inside the query. There are good info about the OData Documentation on its website, on MS but none would give a list for those words.

So here’s my list so far if it helps for future reference to anyone:

•Release/Name
•State
•CreationTime
•Substring
•Contains

Samples:

State + Release/Name:
" (State eq ‘Running’ or State eq ‘Pending’) and Release/Name eq yourOrchestratorProcessName "
*you can separate a query using ‘State’ from ‘Release/Name’ of course

Creation Time:
"CreationTime gt " + yesterdayDate

Substring:
substring(Release/Name, 0, 12) eq %27"+ProcessNameInput+"%27&$orderby=CreationTime%20desc

Contains:
(contains(Release/Name,%27_%27))%20and%20(contains(Robot/Name,%27"+RobotPCName+"%27))&$orderby=CreationTime%20desc

Sites searched:

http://docs.oasis-open.org/odata/odata/v4.01/csprd05/part2-url-conventions/odata-v4.01-csprd05-part2-url-conventions.html#_Toc14103726
https://www.odata.org/documentation/odata-version-2-0/uri-conventions/

Be Safe!

1 Like