Use page queries to specify which features of a layer draw in a spatial map series based on an SQL query. Though similar to definition queries, page queries apply only when a map series is enabled and work with existing queries. With a page query, features are filtered based on the current page of a map series. As you iterate through the pages, the query changes and a new set of features draw appropriate to the new page.
For example, if you have a map series where each page is a U.S. state showing demographic data per county, you can use a page query to show only the counties within the state on each page. You can also use page queries to filter data out of the index feature in a map series. For example, you can highlight the index feature on a page by obscuring the other features with a transparent overlay. You can use a page query on the overlay layer so that it doesn't draw on the index feature.
Page queries are queries between a field in the layer and the map series page name. If the data in the field matches the data in the field for the map series page name for a particular page, the query is applied. Though the field names do not have to match, the data type for the layer field and the map series name field must be the same.
If there is no spatial map series, or the map series is disabled, the page query gets ignored.
Create a page query
To create a page query, complete the following steps:
- Right-click the layer in the Contents pane and click Properties.
- On the Layer Properties window, 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.
- Refresh your map series to see the query applied.