https://community.esri.com/t5/python-ideas/add-aggregate-function-support-to-arcpy-da/idi-p/1195709 <P>The python search cursor allows for using a postfix clause (i.e. group by), but it doesn't allow for using aggregate functions within the select clause.&nbsp; For example, there isn't any way to produce a result set that's equivalent to the following sql using an arcpy searchcursor</P><P>select some_type_field, sum(some_numeric_field) as my_sum</P><P>from xyz_table</P><P>group by some_type_field</P><P>&nbsp;</P><P>You CAN use the group by functionality if you don't include the aggregate function in the select clause, but half the reason for grouping data is often to perform aggregation on the results, without that grouping isn't very useful.&nbsp; This can be worked around in very custom code situations (i.e. iterating over the result set and performing the aggregation manually), but that is super messy and not very reusable.&nbsp; This functionality is especially needed for accessing a file geodatabase as the alternative workaround of using a query layer (which works fine against an enterprise geodatabase) isn't an option for use against a file geodatabase.&nbsp; I suppose an alternative to adding the aggregation functionality to the search cursor would be to allow for query layer functionality against a file geodatabase, but I suspect that may be a bigger request to tackle <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 05 Apr 2024 19:56:40 GMT AJR 2024-04-05T19:56:40Z https://community.esri.com/t5/python-ideas/add-aggregate-function-support-to-arcpy-da/idi-p/1195709 <P>The python search cursor allows for using a postfix clause (i.e. group by), but it doesn't allow for using aggregate functions within the select clause.&nbsp; For example, there isn't any way to produce a result set that's equivalent to the following sql using an arcpy searchcursor</P><P>select some_type_field, sum(some_numeric_field) as my_sum</P><P>from xyz_table</P><P>group by some_type_field</P><P>&nbsp;</P><P>You CAN use the group by functionality if you don't include the aggregate function in the select clause, but half the reason for grouping data is often to perform aggregation on the results, without that grouping isn't very useful.&nbsp; This can be worked around in very custom code situations (i.e. iterating over the result set and performing the aggregation manually), but that is super messy and not very reusable.&nbsp; This functionality is especially needed for accessing a file geodatabase as the alternative workaround of using a query layer (which works fine against an enterprise geodatabase) isn't an option for use against a file geodatabase.&nbsp; I suppose an alternative to adding the aggregation functionality to the search cursor would be to allow for query layer functionality against a file geodatabase, but I suspect that may be a bigger request to tackle <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 05 Apr 2024 19:56:40 GMT https://community.esri.com/t5/python-ideas/add-aggregate-function-support-to-arcpy-da/idi-p/1195709 AJR 2024-04-05T19:56:40Z https://community.esri.com/t5/python-ideas/add-aggregate-function-support-to-arcpy-da/idc-p/1514689#M348 <P><A href="https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-file-gdb/sql-reporting-and-anlysis-file-geodatabases.htm" target="_blank">https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-file-gdb/sql-reporting-and-anlysis-file-geodatabases.htm</A></P><P>lists all the supported functions, but they are only available via. ArcObjects, not exposed via. an arcpy.da.SearchCursor.</P> Sun, 04 Aug 2024 10:30:31 GMT https://community.esri.com/t5/python-ideas/add-aggregate-function-support-to-arcpy-da/idc-p/1514689#M348 AJR 2024-08-04T10:30:31Z https://community.esri.com/t5/python-ideas/add-aggregate-function-support-to-arcpy-da/idc-p/1514693#M349 <P>This would be useful and is very much needed.</P> Sun, 04 Aug 2024 12:06:38 GMT https://community.esri.com/t5/python-ideas/add-aggregate-function-support-to-arcpy-da/idc-p/1514693#M349 Bud 2024-08-04T12:06:38Z