Modifying Master Index Queries

By default, two basic queries and one blocking query are predefined in query.xml and you can create additional queries. Once a query is defined, you can modify it as needed. If you make changes to a query defined for a search in the MIDM, you might need to modify the search definition in midm.xml. For example, if you deselect the Use Wildcard option for a query and the wildcard feature is enabled for that query in the MIDM, you need to disable that feature in midm.xml.

You can customize the queries used in your implementation by performing any of the following actions.

Modifying a Master Index Query
Adding a Query Block to a Master Index Query
Modifying a Query Block for a Master Index Query
Deleting a Query Block From a Master Index Query

You can also define exclusion lists to filter out unwanted values from a blocking query. For more information, see Filtering Default Values From Master Index Processes.

Modifying a Master Index Query

Once you define a basic query, you can modify the attributes and parameters for that query. If you defined a custom query, you might need to modify certain elements of the query directly in the XML file instead of through the Configuration Editor.

To Modify a Basic Query (Configuration Editor)

In the Projects window, right-click the Configuration node in the project you want to modify, and then click Edit.
The Configuration Editor appears.
Click the Query tab.
The Query page appears.
Do one of the following:
- To modify a blocking query, select the query to modify in the Blocking Queries section, and then click Edit.
  The Blocking Query Builder dialog box appears.
- To modify a basic query, select the query to modify in the Basic Queries section, and then click Edit.
  The Basic Query Builder dialog box appears.
Modify any of the fields and configuration options described in Master Index Query Builder Dialog Box Fields and XML Elements.
For blocking queries, you can modify query blocks by performing any of the following procedures:
When you are done editing the query, click OK.
On the Configuration Editor toolbar, click Save.
To modify or define values to be excluded as criteria (for blocking queries only), go to Filtering Default Values From Master Index Processes.

To Modify a Query (XML Editor)

In the Projects window, expand the Configuration node in the project you want to modify, and then double-click query.xml.
The file opens in the NetBeans XML editor.
Scroll to the query-builder element that contains the query you want to modify.

Modify any of the attributes listed in Master Index Query Builder Dialog Box Fields and XML Elements.

For example:

<query-builder name="ALPHA-SEARCH" class=
  "com.sun.mdm.index.querybuilder.MyQueryBuilder" 
  parser-class=
  "com.sun.mdm.index.configurator.impl.querybuilder.KeyValueConfiguration"
   standardize="true" phoneticize="false">
</query-builder>

To add a new query parameter (for custom query builders only):
1. Add a new config element between the query-builder tags.
2. In the new config element, create an option element and then define key and value attributes for the new element.
  For example:
```
<config>
 <option key="SearchAlias" value="true"/>
</config>
```
  See Master Index Query Builder Dialog Box Fields and XML Elements for information about the key and value pairs available to the default basic queries.
To modify a parameter, scroll to the option element that defines the parameter and then change the value of the value attribute.
To delete a parameter, scroll to the config element of that query, and then delete the option element containing the parameter to remove.
For example, to remove the SearchAlias parameter in the following sample, delete the boldface text.
```
<config>
   <option key="SearchAlias" value="true"/>
 <option key="UseWildCard" value="false"/>
</config>
```
For blocking queries, you can modify query blocks by performing any of the following procedures:
Save and close the file.
To modify or define values to be excluded as criteria (for blocking queries only), go to Filtering Default Values From Master Index Processes.

Adding a Query Block to a Master Index Query

Some query blocks might be predefined for you based on information you specified in the wizard. You can create additional query blocks for a blocking query.

To Add a Query Block (Configuration Editor)

In the Projects window, right-click the Configuration node in the project you want to modify, and then click Edit.
The Configuration Editor appears.
Click the Query tab.
The Query page appears.
In the Blocking Queries section, select the query you want to modify and then click Edit.
The Blocking Query Builder dialog box appears.
In the Block Definitions section, click Add.
The Block Definition dialog box appears.
In the Block Name field, enter a unique name for the query block.
(Optional) In the Hint field, define a database hint for the query block. For SQL Server, you can only use OPTION hints.
In the Block By section, click Add.
The Block Rule dialog box appears, where you can specify a field to include in the query block.
Enter values for the fields on the dialog box as described in Master Index Query Block Fields and XML Elements, and then click OK.
Repeat the previous two steps for each field to add to the query block.
When you are done, click OK on the Block Definition dialog box.
On the Blocking Query Builder dialog box, click OK.
On the Configuration Editor toolbar, click Save.

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 query.xml.
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.

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.

Modifying a Query Block for a Master Index Query

Once block definitions are created for a blocking query, you can modify those definitions if needed. You can add, modify, and remove block fields. When adding or removing fields from a query block, verify that the query will still include all the needed fields.

To Modify a Query Block (Configuration Editor)

In the Projects window, right-click the Configuration node in the project you want to modify, and then click Edit.
The Configuration Editor appears.
Click the Query tab.
The Query page appears.
In the Blocking Queries section, select the query you want to modify and then click Edit.
The Blocking Query Builder dialog box appears.
In the Block Definitions section, select the block to modify and then click Edit.
The Block Definition dialog box appears.
Do any of the following:
- To add a new field, click Add, enter the fields described in Master Index Query Block Fields and XML Elements, and then click OK.
- To edit an existing field, select the field you want to modify, click Edit, modify any of the fields described in Master Index Query Block Fields and XML Elements, and then click OK.
- To delete an existing field, select the field you want to delete, click Remove, and then click Yes on the dialog box that appears.
When you are done modifying the query block, click OK.
On the Blocking Query Builder dialog box, click OK.
On the Configuration Editor toolbar, click Save.

To Modify a Query Block (XML Editor)

In the Projects window, expand the Configuration node in the project you want to modify, and then double-click query.xml.
The file opens in the NetBeans XML editor.
Scroll to the block-rule element containing the query block you want to modify.
To add a new blocking field, add and populate the elements described in Master Index Query Block Fields and XML Elements.
For example:
```
<block-rule>
  <equals>
   <field>Enterprise.SystemSBR.Person.DOB</field>
   <source>Person.DOB</source>
  </equals>
  ...
```
To edit an existing field, modify any of the elements described in Master Index Query Block Fields and XML Elements.
To delete an existing field, delete all text between and including the search type elements that define the field (such as equals, range, not-equals, and so on).
For example, to delete the DOB field defined above, you would delete the text between and including the equals elements.
Save and close the file.

Deleting a Query Block From a Master Index Query

Once you create a block definition, you can delete it if needed. When deleting a query block, verify that the query will still include all the needed fields.

To Delete a Query Block (Configuration Editor)

In the Projects window, right-click the Configuration node in the project you want to modify, and then click Edit.
The Configuration Editor appears.
Click the Query tab.
The Query page appears.
In the Blocking Queries section, select the query you want to modify and then click Edit.
The Blocking Query Builder dialog box appears.
In the Block Definitions section, select the definition you want to delete.
Click Remove.
On the confirmation dialog box, click Yes.
On the Configuration Editor toolbar, click Save.

To Delete a Query Block (XML Editor)

In the Projects window, expand the Configuration node in the project you want to modify, and then double-click query.xml.
The file opens in the NetBeans XML editor.
Scroll to the query-builder element that contains the blocking query to modify.

In that query-builder element, delete all text between and including the block-definition element defining the data block to remove.

For example, in the sample below, to delete the SSN block you would delete the boldface text.

<config>
   <block-definition number="ID000007">
      <block-rule>
         <equals>
            <field>Enterprise.SystemSBR.Person.SSN</field>
            <source>Person.SSN</source>
         </equals>
      </block-rule>
   </block-definition>
 <block-definition number="ID000008">
 <block-rule>
          <equals>
             <field>Enterprise.SystemSBR.Person.DOB</field>
             <source>Person.DOB</source>
          </equals>
 </block-rule>
 </block-definition>

Note - Each blocking query must contain one config element, and the config element must contain at least one block definition.

Save and close the file.

Skip Navigation Links
Exit Print View
	Oracle Java CAPS Master Index Configuration Guide Java CAPS Documentation