topic Re: How to "Define parameters in a query layer"? in Python Questions

How to "Define parameters in a query layer"?

nadja — Thu, 11 Jul 2024 12:46:45 GMT

I'd like to incorporate this manual workflow into my dockpane, but I don't find any useful documentation or samples. Does anyone know if it is possible and if yes, how it can be done?

my manual workflow:

I open an enterprise geodatabase feature class in a map in ArcGIS Pro. Then I open layer properties and go to source. there is the field "Query" (not definition query!) containing something like this "select attribute 1, attribute 2, ..., attribute n FROM layername".

I then click on the pen on the right hand side and modify the query to "select * from layername".

I found this documentation: https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/define-parameters-in-a-query-...

how can i add the layer such that its query says "select * from layername"? any help is greatly appreciated.

Re: How to "Define parameters in a query layer"?

AlfredBaldenweck — Thu, 11 Jul 2024 13:00:28 GMT

It sounds like you're asking how to make a Query Layer from Scratch?

If that's the case:

Make sure an enterprise geodatabase connection is in your project's databases folder
On the Map tab, hit the "Add Data" drop down and select "Query Layer"
Choose your database connection
Name your layer
Write your Query
Press Validate
Hit Next
Choose the unique ID
Hit Finish

Query layers—ArcGIS Pro | Documentation

Create a query layer for data in a relational database—ArcGIS Pro | Documentation

Re: How to "Define parameters in a query layer"?

nadja — Thu, 11 Jul 2024 13:28:16 GMT

thanks for your reply, but I'd like to do it using a arcpy-script. is that possible?

Re: How to "Define parameters in a query layer"?

AlfredBaldenweck — Thu, 11 Jul 2024 13:30:56 GMT

Ohh.

Give this a shot.

Make Query Layer (Data Management)—ArcGIS Pro | Documentation