~Zach FezgerotherettuApr 11, 2016, 3:33 PM122 PostsRe: File name in FT IndexHello Anders! To use the "FIELD $FILE CONTAINS filename" firstly you should create the index enabling the option "Index attached files" under "Indexing options". By the way, the Full Text search feature is not designed to search for an attachment's file name. The attachment file name is part of the attachment icon in the rich text field, and the icon is not searched. Full Text search supports searching the content of attachments only, not their icons. As a workaround, add a computed Text field to the relative forms and give it the following formula: @AttachmentNames The field should also be designed to be a multi-value field by enabling the Field property, "Allow multiple values." The field can optionally be hidden. If you do not have Designer access to the database, then you could add the file names to documents using a Formula agent designed to act on selected documents with the following formula: Field attachmentfilenames := @AttachmentNames I hope it helps! Best Regards! Rodrigo San Vicente IBM
~Dan BubluskiobuApr 12, 2016, 8:30 AM6 PostsFile name in FT IndexHi Thanks for the explanation. "FIELD $FILE CONTAINS filename" doesn't work even if "Index attached files" is selected, but the suggested code works fine. Thanks