Get queue items from date start to current datetime

Help Activities
, , , , ,
1

I want get the Queue items which is added from date start to current datetime

what will be the exact date time i have to provide in get Queue item property.

Thanks in Advance

2

Hi @ManjunathReddy

You can just use DateTime.Now in “To” field and the start date in “From” field.

Or

Just populate “From” field so the activity get the queue items from start date until time of execution

One point: the Get Queue Items activity return the maximum of 100 items by execution. If you need more, you need to do extra step

3

@ManjunathReddy

May I know what is the start date?

Also it has limit of 100 so you might need to use a loop to get all the items

To field is not needed as it is today only

Here is an example of how to create loop to get all items

Cheers

4

Hello @ManjunathReddy

  1. Assign activity:
    startDate = New DateTime(2023, 01, 01)
    Set your start date

  2. Assign activity:
    endDate = DateTime.Now
    Current date and time

  3. Assign activity:
    dateFilter = $“DateCreated >= ‘{startDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’ AND DateCreated <= ‘{endDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’”

  4. Get Queue Items activity:
    SpecificData = dateFilter

Thanks & Cheers!!!

5

Hi @ManjunathReddy

In the Properties of Get Queue Items

From: DateTime.Parse(“2021-01-01”) ’ Or use your specific start date

To: DateTime.Now

If you want to include the entire day in your end date (up to 23:59:59 of the current day), you can do something like this:

To: New DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59)

6

In which field we should use this datefilter?
dateFilter = $“DateCreated >= ‘{startDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’ AND DateCreated <= ‘{endDate.ToString(“yyyy-MM-ddTHH:mm:ss”)}’”