How to add a fixed query to the related list?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-18-2017 11:17 PM
In the users form there is the OOB groups related list. While clicking on the Edit button it opens the slushbucket to select the groups to which users has to be added.
I have written a script include to limit the groups that would be listed and mentioned that as the default filter under "List Control".
What I am looking for that is there a way to hide the default filter, and also I have question about adding the sysparm_fixed_query in the URL, but since the slushbucket is OOB (sys_m2m_template.do) I am not sure whether it is editable.
Is there a way to add this script include as a fixed query without hiding/disabling the filter?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-18-2017 11:21 PM
Hey,
Did you try a before query business rule?
Thanks,
Kannan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-18-2017 11:34 PM
Hi Kannan,
Users should be able to see all the groups and so the query BR cannot be added, just in this slushbucket the condition for group has to be limited.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-28-2021 03:16 AM
Hi, you can create a new relationship record here: /sys_relationship.do
It is described here in the docs: Create defined related lists
This link to another docs page might also help you: Create a default filter for a related list