Modifying extraction queries by appending an AND statement (Aeronautical Solution)

Instead of overriding the extraction query, you can choose to append a required condition to the original WHERE clause. To append additional required conditions, you would use an AND operator.

For example, if you want to add the map compilation scale as a required condition of the extraction query, you can add

AND 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 as well as have a map compilation scale value of 40000.

Steps:
  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 view
  3. If necessary, expand Product Library and Products.
  4. Navigate to the series, product, instance, or area of interest for which you want to append an AND operator to the extraction query.
  5. Right-click the product, instance, or area of interest and click Properties.
    TipTip:

    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.

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

    The extraction properties appear. The Settings area is blank.

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

  8. 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.
  9. Repeat steps 7–8 for each table that has a query you want to modify.
  10. Click the cell to the left of the Tables cell to select an entire row.
    TipTip:

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

  11. Right-click the rows and choose Product Class Where Clause AND.
    Product Class Where Clause AND

    AND appears in the Option cell for the row or rows you have chosen.

  12. 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
  13. Check the Edit query text check box.

    The query in the WHERE text box becomes editable.

  14. Place your pointer at the end of the query text and click the AND operator.
  15. Paste or type the condition you want to add to the extraction query.
    TipTip:

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

  16. Click OK.

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

  17. Repeat steps 12–16 for each extraction query to which you want to append an AND operator.
  18. Click OK.
12/22/2014