cProjects: get all tasks assigned to a business partner

[Former Member]

Hi all.

How is possible to get all tasks assigned to a business partner startiing from business partner number or guid?

I tried with table dpr_entity_link but I don't understand the relation between partecipant_guid of this table and bp guid.

Thanks.

[Former Member · Accepted solution]

Check table DPR_PART for more info

[Former Member]

Hi,

In CGPL_HIERARCHY, select the line with DOWN = business partner GUID.

--> You will get all the GUID that represents the concrete roles for this BP.

In DPR_ENTITY_LINKS, select the lines where participant_guid = all the previously selected GUID.

--> You will get all the role-task links assigned to this BP.

Matthias

[Former Member]

Hi,

thanks to all.

Both way are usefull but i solved it on my own using

DPR_BUPA_LINK -> bupa_guid = guid of business partner

then

DPR_ENTITY_LINK -> partecipant_guid = partecipant_guid of DPR_BUPA_LINK

Thanks again,

Luca