Page Query in Definition Query

Question

You can use Page Query to turn layers on and off if an attribute in the layer matches the map series page name.  This is great but very limited and has no flexibility.

What I would like to know is there a way to limit visibility of a layer using Definition Query where a layer is visible depending  on the Map Series page in use?

RobertBorchert · Answer

I may try something that.  This is for company wall maps and we will generate new PDF's of them 2 times a year, or after major restructuring. then if any of our employees or clients need a wall map they can plot it out.

jcarlson · Answer

I run it once to get the entire series to export. It's for our annual tax map book, so the per-page query format doesn't change, just the attributes. The gist of it:

for feat in features:
    some_map.listLayers()[1].definitionQuery = f"some_attribute = {feat.attribute1} or some_attribute = {feat.attribute2}"
    # other layout things
    # export to PDF

RobertBorchert · Answer

I would be fine writing it out in SQL in the definition query.  But a drop down menu of selectable page names would be nice.

So is your script something that has to be executed each time or does it remain intact?