searching relation in p6.1 for baseline identification
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Grüezi Georges-Louis
yourre welcome.
But you found it by yourself.
Regards
Dieter
hi Dieter,
I was able to make the join with project.sum_base_proj_id in child relation to itself and then it worked ;-)
Thanks again for your help
Georges-Louis
hi Dieter,
thanks for your help. If you have any idea, do not hesitate ;-)
Cheers
Georges-Louis
Georges-Louis
Sorry, I have to leave for a business trip. But in the main project there must be a pointer to the BL. Maybe well continue this discussion on Friday - or someone else has a solution.
Good luck
Dieter
hi Dieter,
thanks for your help.
The problem is the field base_type_id in the table project is empty. In orig_proj_id is the "actual" project correctly relationed. But as we are copying "actual" project as a baseline for backing up, there are several "baselines". Only one of the baselines is activated through the p6 application as project baseline and as primary user baseline and Im still wondering where this "flag" or relation is done.....
If you have any idea ;-)
Georges-Louis
have a look at your documentation-cd. --> schema docs --> PMDB0601.0011.0001.zip
Look into the table "project", items:
- orig_proj_id
- base_type_id
Hope this helps
Dieter