How to filter Faulted processes list from orchestrator for the last day using get jobs activity and send the list in mail daily?
Hi @Manish_kumar4,
Welcome to the UiPath Community!
You can utilize the Filter property of the Get Jobs activity by adding “State eq ‘[Your desired status here]’” (i.e. “Status eq ‘Successful’”).
Kind regards,
Kenneth
Hi @kennbalobalo , I used “(State eq ‘Faulted’) and (Interval eq ‘Last day’)” but it doesn’t worked in my case. Please suggest the right query.
Hi @Manish_kumar4,
Try this url below, which return 1 day older Faulted job
"CreationTime ge “+now.AddDays(-Convert.ToInt16(1)).ToString(“yyyy-MM-dd”) + “T00%3A00.00Z”+ " and State eq ‘Faulted’”
Hi @shaik_Azam , I used this “CreationTime ge”+now.AddDays(-Convert.ToInt16(1)).ToString(“2022-10-31”) + “T00%3A00.00Z”+” And State eq ‘Faulted’” query. But it also didn’t worked out. Please help me