View all attachments for a user

[shane_davis]

We are designing our HR application and they have requested something of which I cannot find a solution.   Their desire is to be able to see all the attachments for a user across multiple tickets.   I've searched thoroughly with no luck.  

GOAL - Have a report where I put in a user and it lists all the tickets and corresponding attachments for those tickets.

Any help is appreciated!

[harikrish_v]

Hi Shane,

Not sure if this is the best way to do it, but you can implement this using a UI page. What I was thinking is that you can have a module on your application (you can make that module -URL from arguments and give the UI page name.do in the arguments), it should redirect the user to a page where he can enter the user name and click on Run Report button. Once that is done, you can query the sys_attachment table with this username and populate all the details along with links to download attachments on the page. User Name will remain on the top itself so that if user wants to run the report for another user, he can just change the name and click on Run Report again.

Thanks & Regards,

Hari

[shane_davis]

Thank you, Hari.   I'll give that a try.

[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