To Add a Query Block (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, select the query you want to modify and then click Edit.

   The Blocking Query Builder dialog box appears.

4. In the Block Definitions section, click Add.

   The Block Definition dialog box appears.

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

6. (Optional) In the Hint field, define a database hint for the query block. For SQL Server, you can only use OPTION hints.

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

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

9. Repeat the previous two steps for each field to add to the query block.

10. When you are done, click OK on the Block Definition dialog box.

11. On the Blocking Query Builder dialog box, click OK.

12. On the Configuration Editor toolbar, click Save.