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

[maneesh3]

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,

[shantanu_patel8]

@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 · Accepted solution]

@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

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

[Ankur Bawiskar]

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

[maneesh3]

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: