I need to get the count for each Enumeration value and display in a text box. Below are the details: Entity name: NonConformance Enumeration: NC_Impact Enumeration values: None,Minor,Major,Critical I have tried putting the below Xpath constraint in a ListView but get this error : [Edit] I have created the microflow as suggested by Robin but where do i trigger this microflow? I tried calling the microflow from its attribute but got an error "Calculated value cannot be used for its own calculation” I also get an error when trying to make a many to one association NonConformance-NCRCount I have put a text widget in a dataview (NCRCount as datasource) with attribute parameter 'Minor Count’ and get above error.
If you want the best performing way, you should use an OQL-statement. Something like
SELECT count(*) as NumOfMinorOccurences, NC_IMPACT
GROUP BY NC_Impact