on 09-15-2010 10:45 PM
Hi all,
Is there anyway we could link dpr_project and dpr_task. I want to address a business objects reporting need which lists all the tasks grouped under individual projects. I would ideally want to report off directly from the tables from a performance standpoint. The system is configured in such a way that some of the projects/task attributes are stored in cgpl_project, however i am not able to figure out any direct relationship between project and task tables. Look forward to your inputs on this.
Thanks
Vinayak
Hi Vinayak,
In terms of database, you can go through CGPL_HIERARCHY table:
- from the task GUID ==> field "project_guid" stands for the phase GUID (I admit this naming is quite strange).
- then from the phase GUID ==> field "project_guid" stands for the project GUID.
BR
Matthias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.