CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • views assignees and target contacts on same table
Pages: [1]

Author Topic: views assignees and target contacts on same table  (Read 543 times)

kennedy

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 5
  • CiviCRM version: 4.5.5
  • CMS version: Drupal
  • PHP version: 5.3.10
views assignees and target contacts on same table
October 01, 2014, 11:43:50 pm
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.
« Last Edit: October 01, 2014, 11:45:54 pm by kennedy »

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: views assignees and target contacts on same table
October 01, 2014, 11:46:20 pm
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?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

kennedy

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 5
  • CiviCRM version: 4.5.5
  • CMS version: Drupal
  • PHP version: 5.3.10
Re: views assignees and target contacts on same table
October 02, 2014, 12:02:37 am
You saved my day! It is exactly what i wanted. Many thanks

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: views assignees and target contacts on same table
October 02, 2014, 12:04:06 am
glad you asked a question i could nail that easily
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • views assignees and target contacts on same table

This forum was archived on 2017-11-26.