Add additional table data to database view for Group Weekly resource aggregate from Resource Plan

maneesh3
Tera Contributor

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.,

 

maneesh3_0-1747048818863.png

 

How to get this working, It shows empty records now.

 

Thanks,

 

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@maneesh3 

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

AnkurBawiskar_0-1747052785672.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

7 REPLIES 7

shantanu_patel8
Mega Guru

@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

 

Ankur Bawiskar
Tera Patron
Tera Patron

@maneesh3 

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

AnkurBawiskar_0-1747052785672.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@maneesh3 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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:

maneesh3_0-1747064942604.png