0

I am trying to get the value of PermissionsWorkplaceCommandCenter field per Profile in PermissionSets via Salesforce Workbench.

At first, I have this query:

enter image description here

But this results to following error:

enter image description here

I modified the query based on the error, so my second query turned out like this:

enter image description here

But another error occurs, which is kind of confusing.

enter image description here

I don't know what else is wrong, I just followed what the first query error suggested, but it just resulted to another error.

Hoping someone could help me correct this.

Thanks in advance!

1

Certain field are not groupable (already answered here by @DavidReed). You may check this via Describe objects & field in apex. Or, you can check this from Workbench > Info > Standard & Custom Objects > Expand Fields & then the specific field > Check the groupable attribute. Sample screenshot given below for another field.

enter image description here

| improve this answer | |
  • I see. But is there a way wherein I can group it via Profile's Name field only and just display the PermissionsWorkplaceCommandCenter for each? I think SOQL does not accept grouping unless I group it also by this field, which is kind of absurd because it is not groupable in the first place. – Ertyq Nov 9 at 4:22
  • You may try a non-elegant solution proposed by @PeterKnolle here i.e., create another groupable field and copy this field value using workflow rule. – arut Nov 9 at 4:26
  • 1
    I checked this one also. This surely does it but seems a bit overkill for a requirement that should be done through query in the first place. Looks like Salesforce needs to consider this. But thanks for your suggestions :) – Ertyq Nov 9 at 4:48
  • 1
    Agreed. It's a overkill for trivial business requirements, but then sorting the data and applying code logic over it would be too. Salesforce marks fields as not groupable for very specific reasons, so I'm not sure if they would consider marking this as groupable. If you are paid customer, check with the SF support if they can enable grouping for your org. – arut Nov 9 at 4:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.