View attachments for users on HR Case tickets

[shane_davis]

Our HR department has asked for a report that will show all of the attachments on the HR Case tickets for an "Opened for" person.   They want to do the items below.   Any help is appreciated!

1. Open the report

2. Type a name in condition statement like Opened for IS _______________

3. Click Run Report and it pull a list of all the attachments for the selected user

I have created a Database View as below, but not sure if my Variable prefixes are correct nor what to put in the Where clause...

I have also created the report below.

[shane_davis · Accepted solution]

The final answer was that I modified the "Where clause" on the database view I created "u_hrcase_attachments" which joined the hr_case table and the sys_attachments table.

I changed the "Where clause" to the following:

hrc_sys_id = at_table_sys_id