Adobe Campaign Classic V7 Reporting

Hi @pradeep_07 ,

If you are trying to extract data in a workflow, then you can create query condition as below,

For extracting Delivery Logs (broadLog records), you can select broadLogRcp schema as targeting and filtering dimension, and select date range using @eventDate

Above method, We are Hardcoding the date range as from 1st April to 26th April (static date range)

For extracting Tracking Logs, you can select trackingLogRcp schema as targeting and filtering dimension, and select date range using @logDate

Example, @logDate on or after DaysAgo(5)

The above method of using DaysAgo() function will provide last 5 days to previous day record whenever the workflow runs.

And after each query, you can use data extraction activity and can generate a file.