topic Re: Access the "SQL Expression" parameters and add custom filter lists in Python Questions

Access the "SQL Expression" parameters and add custom filter lists

xavro — Thu, 21 Sep 2023 16:35:39 GMT

Hello, being a beginner on arcpy and in the design of my first script tool in arcgis pro

I want to know if it is possible to access the "SQL Expression" parameters with python and add lists of personalized filters in order to create personal SQL queries.

Thank you very much for your help.

Re: Access the "SQL Expression" parameters and add custom filter lists

Shauna-RaeBrown — Thu, 21 Sep 2023 16:40:41 GMT

#xavro, here's a link that will get you started. https://pro.arcgis.com/en/pro-app/latest/arcpy/get-started/specifying-a-query.htm

Re: Access the "SQL Expression" parameters and add custom filter lists

JeffreyMitzelfelt — Thu, 21 Sep 2023 16:50:52 GMT

A technique I used early on when I was learning about using Python with ArcGIS was to run the tool and, from the Geoprocessing History panel, drag the process to the Python window. This showed me all the parameters that had been used on that run and how they were formatted.

The ultimate source for seeing how the code should be used is the arcpy Python documentation. SearchCursor—ArcGIS Pro | Documentation

Re: Access the "SQL Expression" parameters and add custom filter lists

xavro — Thu, 21 Sep 2023 17:08:53 GMT

Thank you for your answers, but I think we misunderstood or maybe it's me...but the goal is to modify the list of filters available in the "SQL expression" tool. see my screenshot.

Re: Access the "SQL Expression" parameters and add custom filter lists

Shauna-RaeBrown — Thu, 21 Sep 2023 17:37:46 GMT

Here's an earlier post "Programmatically select layer definition query" found here https://community.esri.com/t5/arcgis-parcel-fabric-questions/programmatically-select-layer-definition-query/td-p/1114999

See also - "Delete vs deactivate layer definition query"- https://community.esri.com/t5/python-questions/delete-vs-deactivate-layer-definition-query/m-p/1313695

Re: Access the "SQL Expression" parameters and add custom filter lists

AlfredBaldenweck — Thu, 21 Sep 2023 17:37:53 GMT

Re: Access the "SQL Expression" parameters and add custom filter lists

xavro — Thu, 21 Sep 2023 18:03:44 GMT

Thank you, but I know and have already seen everything relating to layer definition requests. The purpose of this tool is to have the possibility of carrying out searches on attributes common to several layers and then defining definition queries on the corresponding layers.

I would like to use initializeParameters(self): to populate my filter lists.
A bit like we can do in a “Chaine” data type via self.params[3].filter.list = category

Re: Access the "SQL Expression" parameters and add custom filter lists

AlfredBaldenweck — Thu, 21 Sep 2023 18:17:33 GMT

It may be better if you posted some sort of sample code so we can figure out exactly what you're trying for.

I think, though, that you should investigate updateParameters() to change your filter list.

Re: Access the "SQL Expression" parameters and add custom filter lists

JohannesLindner — Thu, 21 Sep 2023 18:22:48 GMT

You have to set the dependency of the Sql Expression parameter to a layer/feature class parameter:

Then it will grab the possible fields and values from that parameter.

Without a selected layer:

With a selected layer:

Re: Access the "SQL Expression" parameters and add custom filter lists

xavro — Thu, 21 Sep 2023 18:30:29 GMT

Thanks, but is it possible to edit or create these fields/value without feature layer dependencies ?

With updateParameters() or initializeParameters() ?

Re: Access the "SQL Expression" parameters and add custom filter lists

JohannesLindner — Thu, 21 Sep 2023 19:26:15 GMT

No. The SQL Expression parameter requires a dependency.

You don't have to set that dependency in the parameter editor. You can also use the parameter.parameterDependencies property in the validation:

class ToolValidator: def __init__(self): self.params = arcpy.GetParameterInfo() def updateParameters(self): self.params[1].parameterDependencies = ["layer"]

But for the tool to fill out the lists of field names and values, the parameter needs a dependency.

If you don't want to do it that way, you could use a string parameter. Users can then simply input their query (or you can prepare a dropdown).

Re: Access the "SQL Expression" parameters and add custom filter lists

xavro — Wed, 27 Sep 2023 14:22:29 GMT

Thanks, I was able to access all my settings and do my search tasks while running the script. However, for each value change in my searches, I would like to delete my previous query definition, can I do that?