Skip to content

searching relation in p6.1 for baseline identification

Georges-Louis TappyMember for 17 years 7 months
Created
6
3
0
hi,
I’m trying to figure out, where is in the p6.1-db the "flag" or how is the relation done for the project baseline or the primary user baseline. I looked through the project table and relations and could not find how is the mapping done inside the db. I’m trying to set up a report directly from the db 6.1
Any idea would be appreciated ;-)
Cheers
Georges-Louis

6 replies

Oldest first
  1. 0
    Dieter Wambach ·
    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
  2. 0
    Georges-Louis Tappy ·
    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 ;-)
  3. 0
    Dieter Wambach ·
    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
  4. 0
    Georges-Louis Tappy ·
    hi Dieter,
    thanks for your help. If you have any idea, do not hesitate ;-)
    Cheers
    Georges-Louis
  5. 0
    Georges-Louis Tappy ·
    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
  6. 0
    Dieter Wambach ·
    Grüezi Georges-Louis

    your’re welcome.
    But you found it by yourself.

    Regards
    Dieter

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?