Get Queue Item from Orchestrator-Daily Basis Report Generration

Hi Team,

I am using Orchestrator queue for Processing Transaction.Once successfully Completed the given transactions, report need to be generate for particular day…

In Get Queue Item activity what date and time value to be give in From and To field.

Kindly assist me in this…

Hi @shyamala_shyamu ,

If you need the queue items for the current date, then you can put now.date in the To and From fields.

If you need for a particular date then use, Cdate("DateString")
Eg:- Cdate("12/04/2023")

Regards,

@shyamala_shyamu
Welcome to the forum

We assume that Get Queue Item<-s is meant

  • From - Filters transactions by the minimum creation date. It accepts DateTime values.
  • To - Filters transactions according to the maximum creation date. It accepts DateTime values.

Lets assume the report is to do for yesterday

Now = 04/12/2023 14:27:45
From: Now.AddDays(-1).Date – 04/11/2023 00:00:00
To: Now.Date – 04/12/2023 00:00:00

Feel free to give some variations on seconds like 04/10/2023 23:59:59 And translating it to the UTC Timezone

1 Like

Hi Vishal,

When i try to retrieve data for current date by using now.date in the from and To Fields it gives empty data.

pls assist.

Hi Vishal,

I have tried both method but it did not work.pls help

Yes as it is filtering from:
grafik
to
grafik

As you can see, no timespan is defined by this.

Above we had shown on how to handle this, similar for today:
From:
grafik

To:
grafik

1 Like

Hi @shyamala_shyamu ,

Just put now.date in the from field and leave the to field empty.

Regards,

2 Likes

Hi Vishal,

It Works.thank u so much for yor help…I have one doubt if upcomingg days any data will add in queue means it will retrieve only current date right.

1 Like

Hi Peter,

Now i have understanding this topic.Thank u so much for crystal and clear example.

Yeah right @shyamala_shyamu , suppose you are running it today, then it will take items from the current day 12 am to the current time.

Regards,

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.