I am populating a variable and displaying it on my dashboard.I have two column in my query .
EMP_ID , i.
I want to display only name in my dashboard and required empid in where clause .
currently my filter shows both of fields in select filter. I want to show only names in list and when i select any employee name query parameter should pick crosponding empid .
see query populate both columns i am required one only for display (as display member) and id as its value member