Related List not displaying records in Platform View
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 02:22 AM
I've created Related list to show expired "Special Handling Notes" on my case type table intented to show the expired special handling notes created from the following tables "Consumer" / "Contact" / "Account". It is working as expected for the admin users in both platform and workspace view.
When I impersonate non-admins like customer service agent / consumer service agent. the related list in the workspace is showing the filtered special handling notes record in the custom related list, but in the platform view of the case type, the custom related list is displayed empty with "No Records" message. Feeling it difficult to find reason for this behaviour. Kindly help me to resolve this issue.
Here is the simple query I've written for the relationship record.
(function refineQuery(current, parent) {current.addEncodedQuery("table_name=customer_contact^ORtable_name=customer_account^ORtable_name=csm_consumer^status=3");
})(current, parent);
@Chuck Tomasi @Pradeep Sharma @Ankur Bawiskar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 06:03 AM
you said for admins it works but not for non-admins.
it means some access issue only
Can you share screenshot of your relationship?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 06:15 AM - edited ‎08-05-2024 06:17 AM
@Ankur Bawiskar
For admins, the related list is showing records on both workspace and platform view. For Agents, it is displaying related list values in workspace, but shows "no record message" in platform view. The impersonated agent is having read access to all related tables mentioned in the query and queries from table.
Here is the relationship image for your reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 06:17 AM
Did you try adding logs to verify if the script is running in platform view?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 06:33 AM - edited ‎08-05-2024 06:39 AM
@Ankur Bawiskar
Just now checked with the gs.info() in the relationship script. Opened one record in workspace and another record in platform, both the records generated log message with the case number. Really confused why it is not displaying the records for non-admins. If it is security rule, then it should not show when I directly navigate to special handling notes table list view. But, the impersonated agent is able to see all the records in list view of the query from table in relationship. And the agent is also able to view the queried related list record in workspace view.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 07:00 AM
strange.
Please raise a HI ticket
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader