It looks like we can’t group an aggregate model on a multiselect field. Any thoughts on the best way around this?
Question
Aggregate Model group on multiselect field?
+18
+17- Nintex Employee
Yup. Thats a core SOQL limitation that I don’t think we can get around.
The soution is pretty ugly. Change the multipicklist to a lookup relationship (many to many) and do your aggregation on the junction object. Data model surgery. Ouch…
The advantage of this is that you will be able to see how many times each unique value is associated with a record, rather than seeing all the different combinations of values that are put together in the multi-picklist field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.