Skip to content

How to find Relationship ID

Ian MackrellMember for 18 years 3 months
Created
3
2
0
I am currently comparing programmes using Claim Digger and i am upto the relationship lags, however it only states the relationship ID number not the Activity ID. How do i find this id in the programme?

Cheers

Ian

3 replies

Oldest first
  1. 0
    Ian Mackrell ·
    In P5!!!!!
  2. 0
    Barrie Callender ·
    I don’t believe you can see the "Relationship ID" from Claim Digger displayed in P5.

    You need to go to the database and run a SQL query to get to it. It is the task_pred_id column in the taskpred table. It is unique in the database.
  3. 0
    Ian Mackrell ·
    Thanks Barrie,

    However, i cannot find the activity ID. I have run with the task_pred_id with the proj_id (shrt_name (filtered to the relevant project)), but for life of me cannot link it with the act_id (shrt_name) as it returns to null.

    I would be grateful if you knew how to get this.

    Cheers mate

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?