views assignees and target contacts on same table

[kennedy]

I have created an activity view with this relationship ' CiviCRM Activity Contacts: Activity Contact ID '. My idea is to list and match activity assignees to their assigned activities (activity targets) on the same table , just in different columns. Any hint? I am really struggling here.

[petednz]

hi kennedy

assuming this is a View built on Activities

add views Relationship twice - and set it once for Trage and once for Assignee

then in Fields, add Civi Display Name twice and for one use the Target Relationship and the other Assignee

it really helps in the Relationship to rename it both in the 'name' and under 'more' to eg Target so you know which is which

helpful?

[kennedy]

You saved my day! It is exactly what i wanted. Many thanks

[petednz]

glad you asked a question i could nail that easily