searching relation in p6.1 for baseline identification

D
Dieter Wambach 👤 Member for 19 years 5 months

Grüezi Georges-Louis



your’re welcome.

But you found it by yourself.



Regards

Dieter

G
Georges-Louis Tappy 👤 Member for 17 years 3 months

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

D
Dieter Wambach 👤 Member for 19 years 5 months

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 we’ll continue this discussion on Friday - or someone else has a solution.



Good luck

Dieter

G
Georges-Louis Tappy 👤 Member for 17 years 3 months

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 I’m still wondering where this "flag" or relation is done.....

If you have any idea ;-)

D
Dieter Wambach 👤 Member for 19 years 5 months

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

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