AnsweredAssumed Answered

Dynamic Text Custom Query and Map Series Rows

Question asked by deleted-user-1_r2dgYuILKY on Jan 10, 2019
Latest reply on Jan 11, 2019 by tbole-esristaff

I have a map series of 225 site floor plans. I want to be able to display total square footage summed by room type with dynamic text. I'm able to accomplish this with a custom SQL query. The problem is, I need the site name specified in the query, and I need that to change for whatever page of the map series that I'm on. As it stands, I can choose either "custom query" or "map series rows" in the insert table statistic query dropdown. Is there any way to pass the page name (site name in this case) into the custom query? Could this kind of functionality be added to a future update of Pro?