Get Job Created after date and specific time

[qwerty1]

Hello,

I’m having trouble using the filter within the Get Jobs Activity. I would like to filter for a specific process name and only get the job data which started after a date and time variable.

How can i do this?

I have tried this to get started, but no data is returned: Which filter options do I have with Get Jobs activity? - #3 by Dan_Wulff_Andersen

Thank you

[efelantti]

If you have the option to use System.Activities = 23.4.5, you get these nice filters in the activity itself.

[qwerty1]

Thanks but no ability to use the new filter feature with our version

[efelantti]

The activity package is compatible with Studio versions from 22.10.5, so if your using a Studio newer than that it should work. Of course upgrading it would affect other activities as well.

If that’s not an alternative, can you share what you have tried so far? The solution in the post that you shared should work.

[qwerty1]

I have tried this as a minimum to check the filter function which doesn’t throw an error, but doesn’t give any data either:

“(contains(Release/Name,%27”+strProcessName+“%27))&$orderby=CreationTime%20desc”

Without any filter i recieve all job information, so it is the filter that is at fault.

I know the name of the job & I know the data and time to pass. I just don’t know the syntax to filter.

[efelantti]

I tested this filter on my end and it works. Can you verify your process name in Orchestrator?

[qwerty1]

I noticed small error and have fixed so now able to get all the data with the base filter above.

To filter better, how can i get the top result where the name is equal to the process name and the start time is after a set date and time?

[efelantti]

This should work:

String.Format("(Release/Name) eq %27{0}%27 and CreationTime gt {1}&$orderby=CreationTime%20desc", strProcessName, filterDateTime)