topic custom dates in exporting queue using automateC in Product Forum

custom dates in exporting queue using automateC

sarathnair — Wed, 26 Feb 2025 09:17:51 GMT

Hi,

I am currently developing a monthly reporting process utilizing the AutomateC functionality. I am seeking advice on whether it is possible to specify custom date ranges for the reports. At present, I am using the "Last 31 Days" filter, which requires the process to be executed on the first day of each month to be effective. I would appreciate any guidance on how to incorporate custom dates into the process.

Additionally, I am interested in knowing if there is a way to export the report to a pre-existing template stored in a specific folder and subsequently rename the file as needed.

Here is the syntax I am currently using:

" /exportqueue " & """" &[Exports] & [Queue.Queue Name] & "_Export.csv" & """" &" /queuename " & """" & [Queue.Queue Name] & """" & " /sso " & " /queuefilter " & """" & [Filter] & """"

If anyone is aware of alternative methods or functionalities beyond AutomateC for exporting reports, I would be grateful for your insights.

Thank you in advance for your assistance.

Regards,

Sarath

Re: custom dates in exporting queue using automateC

SayeedBinAbdullah — Thu, 27 Feb 2025 18:14:27 GMT

Hi @sarathnair

Have you tried "Get Report Data" option under Work Queues VBO?

Best Regards,

Sayeed Bin Abdullah

Re: custom dates in exporting queue using automateC

sarathnair — Fri, 28 Feb 2025 09:45:25 GMT

Hi @SayeedBinAbdullah,

Thanks for the response.

I am currently using "Get Report dat" Option, but the number of queue report to be exported is high and this is taking more time. So i am trying to find alternative that is quicker. Using automate c Functionality the queue report can be exported within 1 or 2 seconds. So i am looking for a solution if any, to add custom dates to that code.

Regards,

Sarath