When I am putting PDF documents and rows from a table into the same index, I
create "dataSource" field to identify the source and I don't copy database
fields - only index them - apart from the unique key which is stored as
"document". On search, you process the output before passing to user. If
datasource is pdfs etc, then you should have highlighted text to pass on. If
dataSource is the table, then fetch the rows from database and display the
search fields as "highlights". A lot of postprocessing of search results but
easier to create meaningful results if a single row in the table contains what
a user wants. You need a custom indexer and a custom results postprocesser
however.
Notice: This email and any attachments are confidential and may not be used,
published or redistributed without the prior written consent of the Institute
of Geological and Nuclear Sciences Limited (GNS Science). If received in error
please destroy and immediately notify GNS Science. Do not copy or disclose the
contents.
