#dominoforever | Product Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

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

Db.FTSearch/DB.Search searches in the entire document irrespective of document fields and attachments.

As of now there is no such flag found which can identify that the search text actually found in the attachment or in the document fields. Please provide if there is any such flag using lotus script or any property?

  • Guest
  • Jul 14 2022
  • Under Consideration
  • Attach files
  • Guest commented
    18 Jul 04:24am

    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.


  • Guest commented
    18 Jul 04:13am

    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

  • Admin
    Thomas Hampel commented
    15 Jul 07:45pm

    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.