https://community.esri.com/t5/arcgis-pro-questions/use-arcpy-to-run-a-definition-query-on-a/m-p/1382990#M78871 <P>I am wanting to create a definition query on a standalone table using arcpy. I have a way set up to do it on a layer file but because a table isn't a layer file this code obviously doesn't work.</P><P>The line of code that is bold is where things go wrong, because its not a layer. Is there a function similar to map_obj.listLayers for tables that I am missing?</P><PRE># Access the map and the layer<BR />map_obj = aprx.listMaps(map_name)[0]<BR /><STRONG>layer_obj = map_obj.listLayers(layer_name)[0]</STRONG><BR /># Set a simple definition query<BR />definition_query = f"{field_name} = '{query_value}'"<BR />layer_obj.definitionQuery = definition_query</PRE><P>&nbsp;</P> Thu, 15 Feb 2024 18:29:31 GMT edward33 2024-02-15T18:29:31Z https://community.esri.com/t5/arcgis-pro-questions/use-arcpy-to-run-a-definition-query-on-a/m-p/1382990#M78871 <P>I am wanting to create a definition query on a standalone table using arcpy. I have a way set up to do it on a layer file but because a table isn't a layer file this code obviously doesn't work.</P><P>The line of code that is bold is where things go wrong, because its not a layer. Is there a function similar to map_obj.listLayers for tables that I am missing?</P><PRE># Access the map and the layer<BR />map_obj = aprx.listMaps(map_name)[0]<BR /><STRONG>layer_obj = map_obj.listLayers(layer_name)[0]</STRONG><BR /># Set a simple definition query<BR />definition_query = f"{field_name} = '{query_value}'"<BR />layer_obj.definitionQuery = definition_query</PRE><P>&nbsp;</P> Thu, 15 Feb 2024 18:29:31 GMT https://community.esri.com/t5/arcgis-pro-questions/use-arcpy-to-run-a-definition-query-on-a/m-p/1382990#M78871 edward33 2024-02-15T18:29:31Z https://community.esri.com/t5/arcgis-pro-questions/use-arcpy-to-run-a-definition-query-on-a/m-p/1383101#M78891 <P>the Table class in the mapping module shows...</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/arcpy/mapping/table-class.htm" target="_blank">Table—ArcGIS Pro | Documentation</A></P><P>There are two ways tables can be referenced in a script for use in a project. To reference tables already in a project, use the listTables method on the Map class. To reference tables directly from a workspace, use the Table function.</P><P>definitionQuery<BR />(Read and Write)<BR />Provides the ability to get or set a tables's definition query.&nbsp; &nbsp; &nbsp;String</P> Thu, 15 Feb 2024 20:38:33 GMT https://community.esri.com/t5/arcgis-pro-questions/use-arcpy-to-run-a-definition-query-on-a/m-p/1383101#M78891 DanPatterson 2024-02-15T20:38:33Z