taylor65

Page Definition SQL Syntax - Filter Table Based On Page Name

Discussion created by taylor65 on Mar 7, 2012
Latest reply on Mar 7, 2012 by taylor65
I'm sorry if this is more straight forward than I'm making it out to be. I want filter Data Sources in Graphic Table Elements based on page name, much like the way a Page Definition using Data Driven Pages selects data from a feature class based on page name. On the Page Definition Query help the following is mentioned:

A Page Definition Queries is a dynamic SQL Where clause based on the values of the designated page name field for Data Driven Pages. Therefore, layers being defined must contain an attribute and appropriate values that can be matched to the designated page name field of the Data Driven Pages index layer. Page Definition Queries react to any change in attribute values in either the index layer field driving the Data Driven Page name or the field specified in the Page Definition Query dialog box. You may need to refresh Data Driven Pages to see any changes for the page currently being viewed.


So, I'm assuming that there is an SQL Query that I can set in an Attribute Filter in a Graphic Table that does the same thing. In a desperate attempt I tried to set my page attribute to equal the dynamic text code for page name but that didn't work, as expected.

Again, I apologize in advance if this is in the help somewhere. I can't seem to find it though.

Thanks!

Outcomes