Master-Detail Queries - with Attachments

SES supports master-detail queries:

• Each record in the document (master) query can be associated with several child(detail) records.
• Each of these child records will have a single column specifying the content that will be indexed as attachments or attributes to the parent document.
• The child query should select a single column and the 'where' clause in this query should have bind variables of the form ##PARENT ATTR## in which value of PARENT ATTR from the parent record will be substituted while executing the query.
  
• If the documents in the result set of the document query have notes to be indexed, the detail query for the notes should be specified as follows:
  SELECT
  NOTES
  FROM
  DOC_NOTES
  WHERE
  DOCID=##DOCID##
  
• For every parent document, the value of attribute DOCID will be substituted in the above query to retrieve the notes for the document.
  
• The user can specify any number of detail queries
• The records fetched by each of these detail queries corresponding to the parent record will be added as attachments to the document represented by the parent record.
• The columns specified by the detail queries can be any of the following data types:
  1. Character Stream - VARCHAR2, CLOB
  2. BLOB
  • Each detail query can have a different datatype.
  • If there are three detail queries, two of them can select attachments of type VARCHAR2 and the other one can select CLOB attachment.