https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1182288#M8249 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/114916">@RichRuh</a>&nbsp;</P><P>I would be really helpful if you could share some code snippet for the same.</P><P>&nbsp;</P><P>Thanks</P> Mon, 13 Jun 2022 13:16:30 GMT Anonymous User 2022-06-13T13:16:30Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1181799#M8246 <P>Hi,</P><P>After connecting to the <STRONG>FGDB database in ArcGIS Pro SDK</STRONG>, I attempted to run the <STRONG>QueryFilter</STRONG>. I believe the error is due to the subfields, however I'm not sure if this is the correct method to write <STRONG>QueryFilter.Subfileds</STRONG> <STRONG>in the FGDB database</STRONG>.&nbsp; I've included the code below.</P><P><STRONG>Error message - "A column was provided that does not exist,"&nbsp;&nbsp;</STRONG></P><P>Could someone please help me out with this?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ShabinaBano_0-1654857984967.png" style="width: 830px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/43201i6D3453F9EBF00C8C/image-dimensions/830x191?v=v2" width="830" height="191" role="button" title="ShabinaBano_0-1654857984967.png" alt="ShabinaBano_0-1654857984967.png" /></span></P><P>-----------code---------------------------</P><P>var featureClassAsSubEvtTableName = new Geodatabase(new FileGeodatabaseConnectionPath(new Uri(rootFolder))).OpenDataset&lt;Table&gt;((tableName));<BR /><BR />QueryFilter queryFilterSubEvtSelected = new QueryFilter();<BR />queryFilterSubEvtSelected.SubFields = $"{selectedColumnsForWhereClause}, MIN({fromMeasure}) AS {fromMeasure}";<BR />queryFilterSubEvtSelected.WhereClause = $"LOWER({routeId}) = LOWER('{selectedLineId}')";<BR />queryFilterSubEvtSelected.PostfixClause = $"group by {selectedColumnsForWhereClause}";<BR /><BR />using (RowCursor rowCursorSubEvtMeasure = featureClassAsSubEvtTableName.Search(queryFilterSubEvtSelected, false))<BR />{<BR />//code here<BR />}</P><P>----------------------------------------------------------------------------------</P><P>Thanks in Advance!</P> Fri, 10 Jun 2022 11:01:26 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1181799#M8246 Anonymous User 2022-06-10T11:01:26Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1181951#M8248 <P>Hi Shabina,</P><P>Table.Search doesn't support functions such as "Min()". Check out the Table.CalculateStatistics method instead.</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/sdk/api-reference/#topic19997.html" target="_self">API class reference</A></P><P><A href="https://github.com/esri/arcgis-pro-sdk/wiki/ProConcepts-Geodatabase#calculating-statistics" target="_self">Conceptual doc</A></P><P>I hope this helps,</P><P>--Rich</P> Fri, 10 Jun 2022 16:48:36 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1181951#M8248 RichRuh 2022-06-10T16:48:36Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1182288#M8249 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/114916">@RichRuh</a>&nbsp;</P><P>I would be really helpful if you could share some code snippet for the same.</P><P>&nbsp;</P><P>Thanks</P> Mon, 13 Jun 2022 13:16:30 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1182288#M8249 Anonymous User 2022-06-13T13:16:30Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1182436#M8250 <P><A href="https://github.com/Esri/arcgis-pro-sdk/wiki/ProSnippets-Geodatabase#calculating-statistics-on-a-table" target="_self">This snippet shows how to calculate the Sum and Average of a set of fields.</A></P> Mon, 13 Jun 2022 19:06:42 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-run-queryfilter-subfields-using-min-and-as/m-p/1182436#M8250 RichRuh 2022-06-13T19:06:42Z