Modifying extraction queries by appending an OR statement

Instead of overriding the extraction query, you can choose to append an alternate condition to the original WHERE clause. To append an alternate condition, you would use an OR operator.

If you want to add the map compilation scale as an alternate condition for data extraction, you can add

OR M_CSCL = '40000'

to the extraction query that has been created at the product class level. This tells the populator that the features extracted must meet the conditions specified at the product class level, and they can also be extracted if they have a map compilation scale of 40000.

  1. Start ArcMap.
  2. If necessary, open the Product Library window by clicking Customize > Production > Product Library on the main menu.

    A tree view of the product library appears.

    Product library tree
  3. Navigate to the series, product, instance, or area of interest for which you want to append an OR operator to the extraction query.
  4. Right-click the product, instance, or area of interest and click Properties.

    Extraction queries can be applied at the instance level (common for nautical charts) or at the series level if all the products associated with that series will have the same compilation scale.

    The properties dialog box appears for the series, product, instance, or AOI.

  5. Click the Extraction pane on the left of the dialog box.

    The extraction properties appear. The Settings area is blank.

  6. Right-click in the Settings table and click Add Record.
    Adding a record in the Extraction pane

    A new row appears in the Settings table.

  7. Click the drop-down arrow in the Tables cell and choose the name of the table or feature class for which you want to modify the extraction query.
  8. Repeat steps 6 and 7 for each table that has a query you want to modify.
  9. Click the cell to the left of the Tables cell to select an entire row.

    You can press and hold CTRL or SHIFT while clicking several rows at once to select more than one row.

  10. Right-click the rows and choose Product Class Where Clause OR.

    OR appears in the Options cell for the row.

  11. Click the ellipsis (...) in the SQL Statement cell.

    The Query Builder dialog box appears.

    An expression that has been appended with both an AND and OR statement
  12. Check the Edit query text check box.

    The query in the WHERE text box becomes editable.

  13. Place your pointer at the end of the query text and click the OR operator.
  14. Paste or type the condition you want to add to the extraction query.

    You can append more than one OR operator and type more conditions.

  15. Click OK.

    The properties dialog box appears for the series, product, instance, or AOI.

  16. Repeat steps 11–15 for each extraction query to which you want to append an OR operator.
  17. Click OK.