Configuring Sun Master Indexes

ProcedureTo Create a Blocking Query (Configuration Editor)

  1. In the Projects window, right-click the Configuration node in the project you want to modify, and then click Edit.

    The Configuration Editor appears.

  2. Click the Query tab.

    The Query page appears.

  3. In the Blocking Queries section, click Add.

    The Blocking Query Builder dialog box appears.

  4. In the Query Builder section, enter the fields described in Master Index Query Builder Dialog Box Fields and XML Elements.

  5. Do the following for each query block you want to include in the query:

    1. In the Block Definitions section, click Add.

      The Block Definition dialog box appears.

    2. In the Block Name field, enter a unique name for the query block.

    3. (Optional) In the Hint field, define MySQL, Oracle or SQL Server hints for the query block.

      For SQL Server, you can only use OPTION hints.

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

    5. Enter values for the fields on the dialog box as described in Master Index Query Block Fields and XML Elements, and then click OK.

    6. For each field to include in the query block, repeat the previous two steps.

    7. When you are done specifying fields for the rule, click OK on the Block Definition dialog box.

  6. For each query block you want to create for this query, repeat the previous step.

  7. When you are done defining the query blocks, click OK.

  8. On the Configuration Editor toolbar, click Save.

  9. To define values to exclude as criteria during the query process, see Filtering Default Values From Master Index Processes.