To Add a Query Block (XML Editor) (Configuring Sun Master Indexes (Repository))

Configuring Sun Master Indexes (Repository)

To Add a Query Block (XML Editor)

In the Projects window, expand the Configuration node in the project you want to modify, and then double-click the Candidate Select file.

The file opens in the NetBeans XML editor.

Scroll to the query-builder element that contains the blocking query to configure.

If a config element does not exist for the query, create one between the query-builder tags.

In the config element, create a new block-definition element with a number attribute and assign a unique ID code to the number attribute.

For example:
<config> <block-definition number="ID1"> </block-definition> </config> </query-builder>

To add a hint, create and define a new hint element in the new block-definition element.

The following example illustrates an Oracle hint.
<config> <block-definition number="ID1"> <hint>FIRST_ROWS_100</hint> </block-definition> <config>

In the new block-definition element, create a block-rule element.

For each field in the data block, define the elements described in Master Index Query Block Fields and XML Elements (Repository).

For example:

<config>
   <block-definition number="ID1">
      <hint>FIRST_ROWS_100</hint>
      <block-rule>
         <equals>
            <field>Enterprise.SystemSBR.Person.FirstNamePh</field>
            <source>Person.FirstNamePh</source>
         </equals>
         <equals>
            <field>Enterprise.SystemSBR.Person.LastNamePh</field>
            <source>Person.LastNamePh</source>
         </equals>
         <range>
            <field>Enterprise.SystemSBR.Person.DateOfBirth</field>
            <source>Person.DateOfBirth</source>
            <default>
               <lower-bound type=”offset”>-5</lower-bound>
               <upper-bound type=”constant”>2006-01-01
               </upper-bound>
            </default>
         </range>
      </block-rule>
   </block-definition>
<config>

Save and close the file.