Search for attachments in Incidents

[FredrikG]

We consider storing "major incident reports" as attachment to the incident.

Is there an easy way to search attachement by filename? (Jakarta)

If so we can use a name "Major Incident CustomerX YYDDMM", the customer responsible could search this information.

Search "Major Incident CustomerX*"

Other suggestions welcomed!

[rahulpandey]

Hi,

You can add attachments as related list to incident and there you can search easily. Right click on form, click configure -> Related List add attachment from left to right and save it.

[FredrikG]

Thanks, The system is configured with Related list with Attachement already.

I try to clarify: A KAM wants to search his customers 100 incidents for last month, and list all that have an Attachment with name "Major Incident X DDMMYY". Becouse he like to read them/prepare for his monthly Quality review meeting)

Where/how do you search for attachments. 

[rahulpandey · Accepted solution]

Hi,

You can search in sys_attachment table and you can filter by table name and filename

[rahulpandey]

You need to type sys_attachment.list in left navigator search and then , it opens the list of all attachment exist in system. Just put a filter on filename and table column(i.e. for which table you want to search.).

Please mark my answer correct if, it helped you.