/*fetch the data group by colour and for each colour how many vechicles are there in that record type*/ a!queryRecordType( recordtype:recordType!AA Vehicle, fields:a!aggregationFields( groupings: { a!grouping( field:recordType!AA Vehicle.fields.color, alias:"color" ) }, measures: { a!measure( field:'recordType!AA Vehicle.fields.vehicleId', function:"COUNT", alias:"countofvehicles" ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100, sort: a!sortInfo( field:"countofvehicles" ) ) )
Discussion posts and replies are publicly visible
In SQL code you would use a HAVING statement to do that. Appian does not support this.
Check out this documentation about what can be done with queries: https://docs.appian.com/suite/help/23.4/Query_Recipes.html