nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

xavro

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.

Encontre mais publicações marcadas com

Accepted answers

All comments

xavro

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?

JohannesLindner

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).

xavro

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

With updateParameters() or initializeParameters() ?

JohannesLindner

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:

abaldenweck@blm.gov_BLM_EGIS

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.

xavro

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

abaldenweck@blm.gov_BLM_EGIS

Shauna-RaeBrown

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

xavro

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.

JeffreyMitzelfelt

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

Shauna-RaeBrown

#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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.