File contents full text search and SES combined?
I have several custom business objects (BORs) built around DMS documents. A 'document' in my case consists of a DMS document (with ms office files attached as 'originals') and some corresponding custom attributes maintained in z-tables.
Files are kept on a Content server, and indexed with TREX.
Search should be possible both on file contents (full-text search) and attributes.
As of now, my search report works as follows: on the selection screen user can supply both attribute values and words to be searched for in file contents. The report first runs a full-text search (FMs from SDOK function group used for that), then it runs an attribute search (regular abap selects ), and then results of both runs are combined and presented to user.
Currently I am investigating the possibility of switching my search implementation to SES. What is not clear to me is how do I arrange searching on files and attributes then. The question is - is it possible (through SES query interface or any other way) to query both file contents and attributes in one query (something like ' category=xx and priority=yy and files contains 'oil'')?
Thank you in advance!