AnsweredAssumed Answered

Changing Query Layer's SQL Expression with Python

Question asked by alexroma on Apr 28, 2016
Latest reply on Aug 18, 2017 by liesbethdegroote

I use query layers in ArcMap 10.4. The maps need to be done/repeated periodically. The easiest way is to copy the map, change the source's SQL expression (e.g. from select * from <tbl> where Period = '2016-March' to select * from <tbl> where Period = '2016-April') and that's it. But the expressions are long and hard to edit. Then I have many similar maps, where I have to make edits manually. Is there a way to do this with Python?

P.S. Using the combination of query layer and definition query is not doable in my case.

Thanks!

Outcomes