https://community.esri.com/t5/arcgis-pro-ideas/show-a-layer-s-ultimate-sql-query-filter-in-the/idi-p/1361786 <P>There are a few mechanisms in ArcGIS Pro that can limit/filter the data in layers and standalone tables:</P><UL><LI>Definition query</LI><LI>Range</LI><LI>Time</LI><LI>Extents</LI><LI>Join - Matching-only</LI><LI>More? (Related:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/definition-query-icon-in-table-of-contents/idi-p/964082/page/4#comments" target="_self">Definition Query Icon in Table of Contents</A><SPAN>)</SPAN></LI></UL><P>It would be very useful to see the ultimate filter/WHERE clause that is used when Pro queries the database for a given layer. That info is available in the Diagnostic Monitor, but it takes time to find and parse that info in the Logs tab, especially for complex maps. It would be more efficient to see that information right in the feature layer properties in the Contents Pane.</P><P>And to be honest, it's not always clear what the full query is when looking at the Diagnostic Monitor. In some cases, it seems like some of the "querying" is done on the application side, not in the query that's sent to the database, which means we can't see the full query in the Diagnostic Monitor.<BR />Example:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/perform-join-at-the-database-level-not-the/idi-p/1293487" target="_self">Perform join at the database level, not the application level, when the datasets are in the same workspace</A></P><P>Related:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/display-selection-criteria-sql-in-the-layer/idi-p/1358045" target="_self">Display selection criteria (SQL) in the Layer Properties window</A></P> Sun, 17 Dec 2023 23:45:51 GMT Bud 2023-12-17T23:45:51Z https://community.esri.com/t5/arcgis-pro-ideas/show-a-layer-s-ultimate-sql-query-filter-in-the/idi-p/1361786 <P>There are a few mechanisms in ArcGIS Pro that can limit/filter the data in layers and standalone tables:</P><UL><LI>Definition query</LI><LI>Range</LI><LI>Time</LI><LI>Extents</LI><LI>Join - Matching-only</LI><LI>More? (Related:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/definition-query-icon-in-table-of-contents/idi-p/964082/page/4#comments" target="_self">Definition Query Icon in Table of Contents</A><SPAN>)</SPAN></LI></UL><P>It would be very useful to see the ultimate filter/WHERE clause that is used when Pro queries the database for a given layer. That info is available in the Diagnostic Monitor, but it takes time to find and parse that info in the Logs tab, especially for complex maps. It would be more efficient to see that information right in the feature layer properties in the Contents Pane.</P><P>And to be honest, it's not always clear what the full query is when looking at the Diagnostic Monitor. In some cases, it seems like some of the "querying" is done on the application side, not in the query that's sent to the database, which means we can't see the full query in the Diagnostic Monitor.<BR />Example:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/perform-join-at-the-database-level-not-the/idi-p/1293487" target="_self">Perform join at the database level, not the application level, when the datasets are in the same workspace</A></P><P>Related:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/display-selection-criteria-sql-in-the-layer/idi-p/1358045" target="_self">Display selection criteria (SQL) in the Layer Properties window</A></P> Sun, 17 Dec 2023 23:45:51 GMT https://community.esri.com/t5/arcgis-pro-ideas/show-a-layer-s-ultimate-sql-query-filter-in-the/idi-p/1361786 Bud 2023-12-17T23:45:51Z https://community.esri.com/t5/arcgis-pro-ideas/show-a-layer-s-ultimate-sql-query-filter-in-the/idc-p/1382410#M28525 <P>Related: <A href="https://community.esri.com/t5/arcgis-pro-ideas/save-a-selection-set/idi-p/952557/highlight/true" target="_self">Save a Selection Set</A></P> Wed, 14 Feb 2024 19:00:12 GMT https://community.esri.com/t5/arcgis-pro-ideas/show-a-layer-s-ultimate-sql-query-filter-in-the/idc-p/1382410#M28525 Bud 2024-02-14T19:00:12Z