Audit Trail for User-Specified Time Period

Ignition
1

Hello All,

I have a table where Data is bound (DB Browse) to AUDIT_EVENTS table. I added a Date Range component so that the user can see audited actions within a specific period.

The question is how to bind the Date Range component to the DB query?

Thanks,

2

PostgreSQL Example:

WHERE "EVENT_TIMESTAMP" >= '{Root Container.Date Range.startDate}' AND "EVENT_TIMESTAMP" <= '{Root Container.Date Range.endDate}'
3

Thanks a lot

that worked fine.