Page queries allow you to specify which features of a layer draw based on an SQL query. Though similar to other definition queries, page queries differ in that they only work with map series and are dynamic. Features are filtered based on the current page. As you iterate through the pages, the query changes, and a new set of features draw appropriate to the new page. For example, suppose you want to create a map series showing crop acreage for each state in the United States. Each state has a separate page in the series displaying the crop acreage by county. To simplify your series of maps, you want to display only crop acreage for the state specific to the page. Page queries allow you to do this quickly.
Keep the following in mind when using page queries.
- Page queries are available at any time. If Map Series is not enabled, you'll still see the Page Query tab of the Layer Properties dialog box.
- A page query cannot be applied to the map series index layer. If you need to display index features with a page query applied, add a copy of the layer to the map frame and apply the page query to the copy. This is a common technique for emphasizing the current index feature and can be used to create a highlight color effect for the index feature.
- Changes made to the map series index layer may cause a layer with a page query not to draw. These include changing the index layer or the index layer field name being used for the page name. If changes are made, you may need to re-create the page query.
- A page query is a dynamic SQL where the clause is based on the values of the designated page name field for the map series. Therefore, layers being defined must contain an attribute and appropriate values that can be matched to the designated page name field of the map series index layer. Page queries react to any change in attribute values in either the index layer field driving the map series name or the field specified in the Page Query dialog box. You may need to refresh Map Series to see any changes for the page currently being viewed.
For best results, remember the following:
- Though the field names do not have to match, the data type for the Page Query field and the Map Series name field should be the same.
- The Page Query field should not contain any null fields.
- Features of the layer you're defining should not overlap pages.
Create a page query
- Right-click the layer in the Contents pane and click Properties.
- On the Layer Properties dialog box, click Page Query.
- Select a field from the drop-down list.
- Choose to show either features that Match or Don't Match the page.
- Click OK.