# Audit Trail for User-Specified Time Period

**URL:** <https://forum.inductiveautomation.com/t/audit-trail-for-user-specified-time-period/32435>\
**Category:** Ignition\
**Created:** [February 19, 2020, 7:42pm UTC](https://forum.inductiveautomation.com/t/audit-trail-for-user-specified-time-period/32435 "2020-02-19T19:42:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![melwadeya](https://avatars.discourse-cdn.com/v4/letter/m/ed8c4c/32.png) [@melwadeya](https://forum.inductiveautomation.com/u/melwadeya)\
**Post date:** [February 19, 2020, 7:42pm UTC](https://forum.inductiveautomation.com/t/audit-trail-for-user-specified-time-period/32435/1 "2020-02-19T19:42:01Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 21, 2020, 12:53pm UTC](https://forum.inductiveautomation.com/t/audit-trail-for-user-specified-time-period/32435/2 "2020-02-21T12:53:37Z")

</div>

PostgreSQL Example:

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

```

---

<div class="post-metadata">

**Author:** ![melwadeya](https://avatars.discourse-cdn.com/v4/letter/m/ed8c4c/32.png) [@melwadeya](https://forum.inductiveautomation.com/u/melwadeya)\
**Post date:** [February 21, 2020, 4:27pm UTC](https://forum.inductiveautomation.com/t/audit-trail-for-user-specified-time-period/32435/3 "2020-02-21T16:27:03Z")

</div>

Thanks a lot

that worked fine.