- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 01:30 PM
I'm trying to create a report of Requests that were Opened by users that are in a specific group. I tried to use the sc_req_item table but I wasn't able to link it to the table sys_user_grmember. Is there a way to link these both tables in a report?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 03:12 PM
Hi @Jesus Herrera ,
There is no dot-walk relation between sys_user_grmember and sc_req_item. If you need to have this, you either need to mentioned the user one by one. The down side here is that the report is not dynamic.
you can also create a database view for the same which will work and be dynamic.
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 01:35 PM
Hi @Jesus Herrera
May you try
Table Relationships:
sc_req_item ➝ requested_for or opened_by ➝ sys_user
sys_user ➝ sys_id ➝ sys_user_grmember.user
sys_user_grmember.group ➝ the group you want to filter by
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 02:13 PM
When I try using the dot walk is not showing the relationship with the sys_user_grmember. Is this relationship using the dot walk in the reports?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 02:16 PM
@Jesus Herrera
table is not available via dot-walk in reports because it's a many-to-many relationship table between sys_user and sys_user_group.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 03:12 PM
Hi @Jesus Herrera ,
There is no dot-walk relation between sys_user_grmember and sc_req_item. If you need to have this, you either need to mentioned the user one by one. The down side here is that the report is not dynamic.
you can also create a database view for the same which will work and be dynamic.
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/