https://community.esri.com/t5/arcgis-pro-sdk-questions/sql-settings-for-whereclause/m-p/1150126#M7875 <P>Good day,<BR />I'm trying to figure out how to write an SQL query for SpatialQueryFilter in WhereClause, so that when browsing individual elements, it excludes the currently read element from the selection.</P><LI-CODE lang="csharp"> private async Task DeletePolygonInPolygon(FeatureLayer polygonLayer) { var spatialQuery = new SpatialQueryFilter() { SpatialRelationship = SpatialRelationship.Contains }; spatialQuery.WhereClause = "";//Somehow write down to keep it current because it would match polygonLayer.Select(spatialQuery); object[] listOfPara = { polygonLayer }; await StartATask("management.DeleteFeatures", listOfPara); }</LI-CODE><P>&nbsp;</P><P>Thank you</P><P>David</P> Thu, 03 Mar 2022 11:58:33 GMT DavidMrázek 2022-03-03T11:58:33Z https://community.esri.com/t5/arcgis-pro-sdk-questions/sql-settings-for-whereclause/m-p/1150126#M7875 <P>Good day,<BR />I'm trying to figure out how to write an SQL query for SpatialQueryFilter in WhereClause, so that when browsing individual elements, it excludes the currently read element from the selection.</P><LI-CODE lang="csharp"> private async Task DeletePolygonInPolygon(FeatureLayer polygonLayer) { var spatialQuery = new SpatialQueryFilter() { SpatialRelationship = SpatialRelationship.Contains }; spatialQuery.WhereClause = "";//Somehow write down to keep it current because it would match polygonLayer.Select(spatialQuery); object[] listOfPara = { polygonLayer }; await StartATask("management.DeleteFeatures", listOfPara); }</LI-CODE><P>&nbsp;</P><P>Thank you</P><P>David</P> Thu, 03 Mar 2022 11:58:33 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/sql-settings-for-whereclause/m-p/1150126#M7875 DavidMrázek 2022-03-03T11:58:33Z https://community.esri.com/t5/arcgis-pro-sdk-questions/sql-settings-for-whereclause/m-p/1150199#M7876 <P>I'm not near a computer to test anything, but from what I can see your going to want to add a for loop to the body of your function. For each feature in the featurelayer you pass into the function return the ObjectID (or other unique id). Then you can use that to exclude the current feature from the WhereClause.&nbsp;</P> Thu, 03 Mar 2022 15:17:02 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/sql-settings-for-whereclause/m-p/1150199#M7876 KimberlyGarbade 2022-03-03T15:17:02Z