2 of 2 people found this helpful
Use Assignee as filter and go to Format option. Under Entry style select value list selection and write the query as shown below -
Test the query and it will list down all the Assignee from the system.
In the output, it will prompt for the Assignee, and based on value selection, available data will be displayed.
e.g. in my system, "Allen" user doesn't have any Incidents assigned, however it will listed in prompt for selection, see below -
Note that the custom query written in filter format will be hidden and it doesn't come in the report SQL.
Hope this helps,
It works. Thank you so much for the help!!!
Welcome, please mark this thread as complete or answered.