Filter Condition in get Job activity

[Akhil_Raveendran (Akhil)]

Hello team, How to write the condition for getting the last 24 hrs executed Jobs details using get job activity.

[Usha_Jyothi]

TRY THIS

CreationTime ge (DateTime.UtcNow.AddHours(-24))

[Palaniyappan (Forum Leader)]

@Akhil_Raveendran

Hello team, How to write the condition for getting the last 24 hrs executed Jobs details using get job activity

Try to mention like this

StartDate gt (datetime'{{currentDateTime}}' - 24:00:00)

This expression will filter the results to only include jobs that were started in the last 24 hours.

Cheers @Akhil_Raveendran

[Praveen_Mudhiraj]

Hi @Akhil_Raveendran

DateTime.Now.AddHours(-24).ToString

You can try this way

[Kartheek_Battu]

Hello @Akhil_Raveendran

DateTime.Now.AddHours(-24)

Hope it Helps…
Thanks & Cheers!!!

[Akhil_Raveendran (Akhil)]

@Praveen_Mudhiraj

DateTime.Now.AddHours(-24).ToString

[Akhil_Raveendran (Akhil)]

[Anil_G (Anil Gorthi)]

@Akhil_Raveendran

Please try this

StartTime gt Now.ToString("yyyy-MM-ddTHH:mm:ss")

cheers

[Akhil_Raveendran (Akhil)]

@Anil_G

StartTime gt Now.ToString(“yyyy-MM-ddTHH:mm:ss”)

same

[Praveen_Mudhiraj]

HI @Akhil_Raveendran

you can check this

Get Jobs - Time Filter Problems

I am building a process to pull all jobs that completed within the last 24 hours. However, I am getting some jobs back with an End Time more than 24 hours ago. Not sure what I’m doing wrong. First I assign this - ReportTimeFrameDays is an argument, and is currently set to 1: TimeFrame = Now.AddDays(-ReportTimeFrameDays) Then, in the Get Jobs activity I filter like this: "EndTime gt "+TimeFrame.ToString("yyyy-MM-dd")+"T"+TimeFrame.ToString("hh:mm:ss")+"Z" I then ConvertFromUTC to Eastern Sta…

[Palaniyappan (Forum Leader)]

I think query is fine
It’s about the access I believe
Let’s check in that direction as well

Make sure that the user has permission to access the jobs.
Make sure that the Orchestrator server is up and running.

Cheers @Akhil_Raveendran

[Kartheek_Battu]

@Akhil_Raveendran

1. Add the “Get Jobs” activity to your workflow.
2. Configure it with the Orchestrator folder and desired job state.
3. Set the “Start Date” to Now.AddDays(-1) (24 hours ago) and the “End Date” to Now.
4. Use the output of the “Get Jobs” activity to access job details executed within the last 24 hours.

[Akhil_Raveendran (Akhil)]

Without using the filter i am able to get the all the jobs details

[efelantti]

Does this work?
"StartTime gt " + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss.ffZ")

[Akhil_Raveendran (Akhil)]

@efelantti

"StartTime gt " + DateTime.Now.ToString(“yyyy-MM-ddTHH:mm:ss.ffZ”)

Same error

[Anil_G (Anil Gorthi)]

@Akhil_Raveendran

Try this it should work as expected

"StartTime gt " + Now.adddays(-1).ToString("yyyy-MM-ddTHH:mm:ss.fffZ")

just now tested…Hope this solves

cheers

[Akhil_Raveendran (Akhil)]

getting same error ,not sure what is the root cause.

[Anil_G (Anil Gorthi)]

@Akhil_Raveendran

Can you please recheck…or delete the activity and rea dd

just used same and no issue

cheers

[Akhil_Raveendran (Akhil)]

@Anil_G

"StartTime gt " + Now.adddays(-1).ToString(“yyyy-MM-ddTHH:mm:ss.fffZ”)

Thank you all for your help .

After updating the UiPath.system.activites package to latest version i am able to update the filter conditions in GUI itself .

Thank you very much