https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-python-toolbox-arcpy-arcsdesqlexecute/m-p/1563482#M90671 <P>Hello,<BR />I created a Python toolbox (.pyt) and when configuring the parameters, I discovered (on my own since I couldn't find it in the official documentation) that it is possible to list the values ​​through a database query.</P><P><BR />Example:</P><LI-CODE lang="python">def getParameterInfo(self): """Define parameter definitions""" param = arcpy.Parameter( displayName="Select one option", name="id", datatype="GPString", parameterType="Required", direction="Input", ) sql = """ SELECT t.FIELD FROM TABLE T ORDER BY t.FIELD; """ conn = arcpy.ArcSDESQLExecute(SDE_FILE) values = [row[0] for row in conn.execute(sql)] param.filter.list = values return [param]</LI-CODE><P>However, some users reported that it is not loading all the data from the table. I was able to verify this and to solve it, I created a new project, added the toolbox and voila, the query brought all the values.</P><P>Any solution or is this another bug?</P> Fri, 29 Nov 2024 19:50:22 GMT byander 2024-11-29T19:50:22Z https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-python-toolbox-arcpy-arcsdesqlexecute/m-p/1563482#M90671 <P>Hello,<BR />I created a Python toolbox (.pyt) and when configuring the parameters, I discovered (on my own since I couldn't find it in the official documentation) that it is possible to list the values ​​through a database query.</P><P><BR />Example:</P><LI-CODE lang="python">def getParameterInfo(self): """Define parameter definitions""" param = arcpy.Parameter( displayName="Select one option", name="id", datatype="GPString", parameterType="Required", direction="Input", ) sql = """ SELECT t.FIELD FROM TABLE T ORDER BY t.FIELD; """ conn = arcpy.ArcSDESQLExecute(SDE_FILE) values = [row[0] for row in conn.execute(sql)] param.filter.list = values return [param]</LI-CODE><P>However, some users reported that it is not loading all the data from the table. I was able to verify this and to solve it, I created a new project, added the toolbox and voila, the query brought all the values.</P><P>Any solution or is this another bug?</P> Fri, 29 Nov 2024 19:50:22 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-python-toolbox-arcpy-arcsdesqlexecute/m-p/1563482#M90671 byander 2024-11-29T19:50:22Z