How can I search in the Attachments files

[Serkan Yilmaz]

Hello,

I'm working on a new Search functionality, so the end user can search in de IPC processes, knowledge and CMDB. We don't use the Global search for this solution, because the customer has some specific requirements.

The chosen solution is a UI page that can be opened from a Application module. This UI page is doing a Ajax call to a Script Include where the search logic is place in.

Searching in the IPC, knowledge and CMDB tables is easy (GlideRecord), but I want also search in the Attachment files and show the linked records in my result if an attachment matches the search criteria.

Hopefully has somebody a solution.

Thank you in advance.

Best regards,

Serkan

[Gurpreet07]

Hi Serkan,

What are the issues you are facing while searching for attachments . Search in table sys_attachment and then there are columns table name and table sys_id to get related record.

[Serkan Yilmaz]

Hi Gurpreet,

It's true that the Table and the Table sys_id is in place on the sys_attachment table to get the related record.

But before that the first step is to search in the files (word, exl, txt etc.). I need a way to search in the files.

BR,

Serkan

[tinayang15]

Serkan, did you ever find a solution to this?

[Kalaiarasan Pus]

This is the OOB feature

http://wiki.servicenow.com/index.php?title=Enabling_Attachment_Indexing#gsc.tab=0