EnhancedLightningGrid icon indicating copy to clipboard operation
EnhancedLightningGrid copied to clipboard

Sortable Data Grid not showing for Community Users

Open AndyHaas opened this issue 2 years ago • 5 comments

I have assigned the permission set to the user, and I have reviewed the profile and validated APEX access. I validated Sharing Rules were set correctly, but the component is not visible to community users. Any other suggestions?

AndyHaas avatar Nov 28 '22 21:11 AndyHaas

14:53:43.56 (2382633083)|SOQL_EXECUTE_BEGIN|[74]|Aggregations:0|SELECT id FROM sdg_preferences__c WHERE (user__c = :tmpVar1 AND sdgKey__c = :tmpVar2) 14:53:43.56 (2387781902)|SOQL_EXECUTE_EXPLAIN|[74]|Index on sortablegrid__sdg_Preferences__c : [sortablegrid__User__c], cardinality: 4, sobjectCardinality: 1307, relativeCost 0.031 14:53:43.56 (2387803991)|SOQL_EXECUTE_END|[74]|Rows:1 14:53:43.56 (2388147276)|DML_BEGIN|[77]|Op:Delete|Type:sortablegrid__sdg_Preferences__c|Rows:1 14:53:43.56 (2456149287)|DML_END|[77] 14:53:43.56 (2456517248)|DML_BEGIN|[81]|Op:Insert|Type:sortablegrid__sdg_Preferences__c|Rows:1 14:53:43.56 (2484914387)|DML_END|[81] 14:53:43.56 (2484998690)|ENTERING_MANAGED_PKG|sortablegrid 14:53:43.56 (2487071856)|ENTERING_MANAGED_PKG|sortablegrid 14:53:43.56 (2487368047)|ENTERING_MANAGED_PKG|sortablegrid 14:53:43.56 (2487403418)|ENTERING_MANAGED_PKG|sortablegrid 14:53:43.56 (2488056883)|ENTERING_MANAGED_PKG|sortablegrid 14:53:43.56 (2488145373)|ENTERING_MANAGED_PKG|sortablegrid 14:53:43.56 (2488166352)|ENTERING_MANAGED_PKG|sortablegrid 14:53:43.56 (2488480713)|VARIABLE_ASSIGNMENT|[EXTERNAL]|this|"common.apex.runtime.impl.ExecutionException"|0x68514ce1 14:53:43.56 (2488505061)|VARIABLE_ASSIGNMENT|[EXTERNAL]|message|"Script-thrown except (3 more) ..." 14:53:43.56 (2488571235)|VARIABLE_ASSIGNMENT|[EXTERNAL]|cause|"common.apex.runtime.impl.ExecutionException: Argument cannot be null."|0xe9c1968

AndyHaas avatar Nov 28 '22 21:11 AndyHaas

so after a deep deep dive into figuring out how this component works the issue goes down to the callMethod within the sdgBaseHelper.js class and the action.setCallback(this, function (actionResult) { function

We are getting a state == 'Success' which then gets us a response of 5 17:26:55:701 c.GetSDGInitialLoad response: {"SDGObject":null,"Results":null,"isError":true,"ErrorMessage":"Script-thrown exception"}

So I am not sure what permissions the community user would be missing that a normal user has

The setCallback calls the function GetSDGInitialLoad in the sdgController.cls

AndyHaas avatar Nov 28 '22 23:11 AndyHaas

@AndyHaas I had the same issue. The permission set is assigned to my community users via perm set group. When I added the object perms read and view all and set all fields to read on all of the sortable data grid objects via the profile assigned to all of my community members, the grid showed up fine. Give it a try and see it that renders the grid.

justinawhite1980 avatar Dec 03 '22 20:12 justinawhite1980

I have validated at a profile level that they have read access to all objects that start with "Sortable". Are there any other objects that I am missing?

@justinawhite1980

AndyHaas avatar Dec 05 '22 12:12 AndyHaas

Link to Trailhead Discussion https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000LIElXSAX

AndyHaas avatar Dec 07 '22 14:12 AndyHaas