HII'm trying to count the number of records in the data entity HVSDC_PlanesMejoramiento_Entity that meet a specific filter on the field CodigoSIRECISujetodeControl.
HVSDC_PlanesMejoramiento_Entity
CodigoSIRECISujetodeControl
This is the SQL query, which works fine:
SELECT CodigoSIRECISujetodeControl, COUNT(NombreAccion) AS total_accionesFROM HVSC_V_PlanesMejoramientoWHERE CodigoSIRECISujetodeControl = '11745' GROUP BY CodigoSIRECISujetodeControl;
This is the query in Appian:
local!count: a!queryEntity( entity: cons!HVSDC_PlanesMejoramiento_Entity, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "CodigoSIRECISujetodeControl", operator: "=", value: tostring(ri!codigoSireci) ) } ), aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "NombreAccion", aggregationFunction: "COUNT" ) }, groupingColumns: { a!queryGroupingColumn(field: "CodigoSIRECISujetodeControl") } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 500 ) )).data
It throws the following error:
Expression evaluation error at function a!queryEntity: At least one field must be grouped when defining a query with an aggregation.
Discussion posts and replies are publicly visible
The field being grouped is referring to having the "isGrouping" variable in the a!queryAggregationColumn() function set to true for at least one field.
Also, not sure what groupingColumns or the a!queryGroupingColumn() is.
Hi fabianbBO could you check this link and makes changes to your code that might help you to solve the error.
docs.appian.com/.../fnc_scripting_a_aggregationfields.html
I'm unclear why you're using aggregation if you're merely trying to count the number of records in the view that have a Control Code(?) of 11745. Unless I'm misunderstanding the shape of your data (which you haven't really specified), you should be able to just do a regular query on the view, a regular Query Filter on the "11745" value, set "fetch total count" as TRUE, then get the TotalCount value included in the resultant DataSubset.
As Mike suggested, all you need is the total count returned by the data subset, you can even set the batchSize to 1 if all you need is the count and you want it to run faster.