DB.FTSearch/DB.Search: Flag to Identify that the search text actually found in the attachment or in the document fields

DB.Search doesn't search in attachments. The idea can only relate to the DB.FTSearch.

Hi Thomas,

I am looking for a way to determine whether the result found in one of the fields in a document or on attachment.

If on Attachment, it would be nice to get the name.

I know I can do it on a client side, then the attachment is marked in coloured, but would be nice to have it on a script level.

Can you please explain more on what you would do with a flag that would identify those documents where the search term was found in an attachment?

>>>Answer>>>

Customer would like to know any way to get the results (via code) from FT search and determine whether the text was found in the document field or in an attachments.

If search string found in attachment then it should print - "Found in :Name of attachment (abc.pdf, xyz.xlsx etc.)".

If search String found in document field (Body) then it should print - "Found in Name of field: Body ".

We have tried below way but its not identifying the search string found in attachment or in document fields.

1. method db.FTSearch( query$, 0,FT_SCORES, FT_FILESYSTEM)

2. While creating the Full-Text index of the database will check the option as

- Index attached files

- Using conversion filters on supported files

Please let us know the concern if any.

Regards,

Pravin

The search is executed on view level and its providing a result set.
Can you please explain more on what you would do with a flag that would identify those documents where the search term was found in an attachment?

What would the difference be to a user?

Please note that if you want to exclude certain field names you can already fine tune the FTsearch to only query defined fields.