I previously submitted an enhancement request: ENH-000187066 Dynamic parameters for Definition Queries in ArcGIS Pro. But I want to make it clear that I'm requesting a place to enter a single parameter for multiple definition queries. I also want input from community members.
Idea:
A textbox in the ribbon or a dialog where we can enter a single parameter that would be automatically used in multiple definition queries. For example, in the textbox/dialog, enter a year like "2029" (this is a budget year, not a year that can be based on the sysdate). "2029" would be automatically inserted into any definition query that has the text "[YEAR]" in it. So I could have multiple layers (roads, sidewalks, creeks, bridges, & ponds) that have different definition queries (and different geometry types), but all the definition queries have the text "[YEAR]" in them, such as YEAR = [YEAR]. If I could set/modify the year in one place, that'd be more efficient than modifying each definition query.
I can't use the existing EGDB query layer parameter functionality, even though my data is in an Oracle EGDB, because many of my layers are linear referencing event layers. ST_GEOMETRY query Layers can't do linear referencing. And even if I could use the query layer parameter functionality, I don't think the parameter applies to multiple layers.
This functionality would be somewhat similar to how Microsoft Access works. In Access, I can have multiple nested queries and put [YEAR] in each query, but I will only get one [YEAR] parameter dialog that will be applied to all of the nested queries. Similar to this screenshot from the web:
We don't have nested queries in ArcGIS Pro. But we do have multiple layers. I want a single dialog or ribbon textbox to update parameters in the definition queries of multiple layers.
For what it's worth, there is similar parameter functionality in SQL clients like TOAD. But the parameter only applies to a single query.
