Hi!
I need help!!!
I want to use a!aggregationFields and filter together how can i get it
Discussion posts and replies are publicly visible
That should not be an issue, you can try the below code and update your values and check.
a!queryRecordType( recordType: "RecordType", fields: a!aggregationFields( groupings: a!grouping( field: "recordFieldToAggregateHere", alias: "xyz" ) ), filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "fieldToFilter", operator: "=", value: true, ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100), fetchTotalCount: true, ), cast( recordType, null )
Konduru Chaitanya
Thank you for your help.
I have another question。I want to display other fields after aggregationFields. Is it possible?
oredersid"O1000"(Text)customerid"0123456"(Text)caseid"02"(Text)caseID"02"(Text) ← aggregationFields
No. You can either use a!aggregationFields() or recordFields in the fields parameter. Both do not work parallelly.
I got it .Thank you so much
Great! Please do verify any answer that was helpful to you.