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) »
  • Views2 > CiviCRM relationships > relationship type field > no content in view
Pages: [1]

Author Topic: Views2 > CiviCRM relationships > relationship type field > no content in view  (Read 1647 times)

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Views2 > CiviCRM relationships > relationship type field > no content in view
July 15, 2010, 05:26:52 pm
Using Views2, when I create a view of type 'CiviCRM relationships' and add a field 'Relationship Type A-to-B', there is no content in the view.

Running the query by hand shows a number is being returned for the relationship_type_id field.

  • Do I need to tweak something to make this display?
  • On reflection, it would be nice to display the name of the relationship rather than the number. Where should such requests be made?

Thanks,
Ken
« Last Edit: July 15, 2010, 05:34:29 pm by ken »

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: Views2 > CiviCRM relationships > relationship type field > no content in view
July 15, 2010, 08:22:35 pm
One of the attachments here has a View that was successfully using Relationships in case that helps you reverse engineer something http://forum.civicrm.org/index.php/topic,14376.msg61425.html#msg61425
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

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Views2 > CiviCRM relationships > relationship type field > no content in view
July 16, 2010, 05:09:30 am
Thanks, Peter!

As I'm new to views, let me just think aloud for a moment...

  • I assume I can import the *.view.txt files into Views?
  • Neither file refers to 'relationship_type' but directory.view.txt refers to 'membership_type', so am I right in assuming the relationship is a membership?

If I'm correct, then comparing the code for membership_type and relationship_type should highlight what the problem is.

Ken

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: Views2 > CiviCRM relationships > relationship type field > no content in view
July 16, 2010, 01:42:54 pm
So yes you should be able to just import in to Views - yes it is Directory that is showing a Relationship - which is Relationship B = Company. Since I didn't build this I can't promise that it is being applied or whether some work had to be done to have it become an option but the site does have a Directory working whereby if you click on Company you get the records of all the employees. Hope it helps, apologies if it is just a red herring.
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

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Views2 > CiviCRM relationships > relationship type field > no content in view
July 16, 2010, 11:25:31 pm
Thanks for your help, Peter!

Greetings from across the Tasman, bro!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Views2 > CiviCRM relationships > relationship type field > no content in view

This forum was archived on 2017-11-26.