- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2025 04:21 AM
Hi Team,
We have Group Weekly resource aggregate table that is a database view stores information resource allocation, capacity and availability etc., it shows project task, user info, and hours etc., but needed to add resource plan details also like plan number. I have tried to resource plan in view table but nothing populating, please help needed in Where clause rule etc.,
How to get this working, It shows empty records now.
Thanks,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2025 05:26 AM
ensure you add this in the where clause for resource plan table and also add user_resource field in the view field under that view table of Resource plan table
The field user_resource on Resource plan holds user information, so use that
grpmember_user=rpl_user_resource
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
05-12-2025 05:18 AM
@maneesh3 You can try "grpmember_user=rpl_user" in the where clause.
This should give you the relevant resource plan for the user.
Please mark the question correct and helpful if it resolves the issue.
-Shantanu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2025 05:26 AM
ensure you add this in the where clause for resource plan table and also add user_resource field in the view field under that view table of Resource plan table
The field user_resource on Resource plan holds user information, so use that
grpmember_user=rpl_user_resource
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
05-12-2025 08:42 AM
Thank you for marking my response as helpful.
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
05-12-2025 08:49 AM
Thanks Ankur. But now resource plan number is populating, now i think its totally against user, with no reference matching against resource plan and Group weekly aggregates, with allocation split , can we map with what resource plan project allocated is split into, so that it is easy for my management to understand this allocation against which plan number.
Like below: