# Issue with Audit Log dynamic dropdown

**URL:** <https://forum.inductiveautomation.com/t/issue-with-audit-log-dynamic-dropdown/16886>\
**Category:** Ignition\
**Tags:** ignition78, ignition77, ignition79, ignition80\
**Created:** [February 6, 2018, 10:48am UTC](https://forum.inductiveautomation.com/t/issue-with-audit-log-dynamic-dropdown/16886 "2018-02-06T10:48:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![patneshubham123](https://avatars.discourse-cdn.com/v4/letter/p/cab0a1/32.png) [@patneshubham123](https://forum.inductiveautomation.com/u/patneshubham123)\
**Post date:** [February 6, 2018, 10:48am UTC](https://forum.inductiveautomation.com/t/issue-with-audit-log-dynamic-dropdown/16886/1 "2018-02-06T10:48:23Z")

</div>

Hi everyone,  
we have created audit log table where the activities of all the operator is getting logged.we want to create a dynamic dropdown where we can select the operator which we have added in user management.but when i write a sql query "SELECT DISTINCT Operator FROM AuditLog ",it will display the operator but when i truncate it doesnt show operator.so i want to create a dynamic dropdown where it will show the operator name from user management and continue to show the operator name even if we truncate the auditlog table .

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [February 6, 2018, 11:11am UTC](https://forum.inductiveautomation.com/t/issue-with-audit-log-dynamic-dropdown/16886/2 "2018-02-06T11:11:03Z")

</div>

Look in the Cloud Template Browser.  
There is an ‘Audit Log’ template with detail analytics per selected user…