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 
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 

Reply via email to