cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the responsible person of a project task from the database table

Former Member
0 Kudos

Hi,

Could you please let me know the table name were we can get the responsible person of task.

Thanks in advance.

Warm Regards,

Arun

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Arun,

Check table DPR_ENTITY_LINK with:

- ENTITY_GUID = the task GUID

- RESPONSIBLE = 'X'

--> in PARTICIPANT_GUID, you get the concrete (resource) or abstract role (project role) that is responsible for the task.

BR

Matthias

Former Member
0 Kudos

Hi Mattihas, Thank you. Now i am trying to do the reverse i.e., trying to fetch the tasks assigned to particular role. I have participant guid from dpr_bupa_link table to corresponding bupa_guid. Please suggest the table name which gives me valid link between participant guid and task.

Regards,

Arun

Former Member
0 Kudos

Hi,

It's the same table DPR_ENTITY_LINK with:

- PARTICIPANT_GUID = role guid (concrete or abstract)

- ENTITY_GUID = task_guid

( - ENTITY_TYPE = 'TTO' )

BR

Matthias