Enabling attachment table global search

[anantharamann]

Hi All,

How to enable global search for attachment table.

I have referred to wiki and enabled text indexes, Indexing is done. Have added the table to global search configuration.

There are no results returned for any searches though it shows No Matches for.

Any suggestion? OR any configuration more to check ?

[DrewW]

There are ACL's on the sys_attachment table so that you have to have permission to the record that the attachment is for to see it, if my memory is worth anything today.

Also I do not think that a text index on the sys_attachment table will do any good because all of the attachments are stored as binary blobs I think and I do not thing the system will index that directly.   I thought thou that I read somewhere that the system would index attachments and include that info with the index of the table and record the attachment was for.

[anantharamann]

Okay, SO in that case if we add "attachment Index" to a table, will that get the specific attachment related to that table ?

We are now in Eureka Patch 10. I have added the "attachment Index" attribute to Incident table, should the table be re-indexed ?

Also, is there anyway to enable text index to attachment table ? I get it that it stores as some relation etc in the attachment table as mentioned by you. Is there any way how this can be overcome ?

Thanks in advance.

[Brad Tilton]

I think by enabling indexing you can search attachments attached to your global search tables, is that not working? What's the business case for being able to search all tables independent of the record the attachment is related to?

[anantharamann]

I have enabled indexing for the sys attachment table, still no results.