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,

[Ankur Bawiskar]

@maneesh3

I believe I answered your original question on how to add additional table and what that where clause should be.

Please mark my response as correct so that it helps other members.

The discussion can continue on same thread.

[Ankur Bawiskar]

@maneesh3 

it's upto your customer what they wish to see in reporting via this database view.

You can add additional tables as well in that database view if required.

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

[maneesh3]

@Ankur Bawiskar 

Got the table added, Sure that I will do. But question is need to map resource plan number against that allocation divided in each week. but now with these it is showing wrong reference. 

Thanks