topic Re: arcPy on query layer in Geoprocessing Questions

arcPy on query layer

SteveLi — Fri, 07 Oct 2011 11:54:04 GMT

I need to make many MXDs which include query layers (NOT through layer definition). The difference of these MXDs is only the query of the layer. Is there way to automate this?

Thanks.

Re: arcPy on query layer

RussellBrennan — Mon, 10 Oct 2011 15:33:32 GMT

Hi Steve,

There is currently no option to create or alter query layers through Python at 9.x or 10.

If you have access to the Beta program you can take a look at the "Make Query Layer" tool in 10.1 Beta.

Re: arcPy on query layer

MichaelVolz — Thu, 13 Mar 2014 15:36:07 GMT

I see the Make Query Layer in the Data Management->Layers and Table Views Toolbox which is great.

I would also like to know if there is the ability to edit a Query Layer, that is already created, through python. In my scenario, I see many Query Layers created with an Oracle 11g Client connection. If the back end database gets updated to Oracle 12c (which my organization will probably do within the next 2 years), I would want to update the Query Layer to use the Oracle 12c Client connection instead of the Oracle 11g Client connection. Is this scenario currently possible through python?

Re: arcPy on query layer

RonnieRichards — Mon, 06 Jun 2016 16:40:42 GMT

Is it even possible to detect a if a layer is a query layer using ArcPy?

Re: arcPy on query layer

BillDaigle — Mon, 06 Jun 2016 17:39:00 GMT

Only way I know is to do a describe on the layer and look for the string "%" in the datasetName property.