XSD - Detail-Attribute Query File

<?xml version="1.0" encoding="windows-1252" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="http://xmlns.oracle.com/ses/sqlconnector/detail-attribute-queries"
targetNamespace="http://xmlns.oracle.com/ses/sqlconnector/detail-attribute-queries"
elementFormDefault="qualified">
<xsd:complexType name="sqlQueriesType">
<xsd:annotation>
<xsd:documentation>
Specify detail and attribute queries for each document fetched by the master query specified
as a source parameter.
</xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="attachmentQueries" maxOccurs="1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>
Specify detail queries to fetch detail records for each document represented by the master record. The master records are fetched by the master query specified as a source parameter. 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 attachment to the parent document. Hence, 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 detail query.
</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="query" maxOccurs="unbounded" minOccurs="1">
<xsd:complexType>
<!--Attribute to specify whether the contents retrieved by the query is inline attachment or link to an attachment. The value of true specifies that the contents is a link to an attachment and false indicates inline attachment. Default value is false.-->
<xsd:attribute name="link" default="false"/>
<!--Content type of the attachment. If no value is specified, SES will auto-detect the content type.-->
<xsd:attribute name="contenttype" default="null"/>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="attributeQueries" maxOccurs="1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>
Specify queries to retrieve values of attributes of the parent document. Use this feature if the attribute can contain multiple values for a document. If the attribute is a single-valued attribute, it can be specified in the master query. 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.
</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="query" maxOccurs="unbounded" minOccurs="1"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
<xsd:element name="sqlQueries" type="sqlQueriesType"/>
</xsd:schema>