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 CiviReport (Moderator: Dave Greenberg) »
  • Creating a report limited to a individual relationship
Pages: [1]

Author Topic: Creating a report limited to a individual relationship  (Read 1318 times)

sraisz

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
    • sambandha.net
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
Creating a report limited to a individual relationship
April 15, 2010, 01:32:02 pm
I am trying to create a report that would give a listing of contacts filtered by a condition that the CiviCRM user has a relationship ( in this case Mentor of) with the contact. I want to make this available to put in the dashboard for all users.

This is similar to the activities report which lists only activities that are assigned to the logged in user ( unless they have permission to see everything).

I assume this would acquire some custom PHP. I am not a PHP programmer so I would appreciate any guidance on this.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Creating a report limited to a individual relationship
April 15, 2010, 03:10:45 pm

Your best bet would be to hire someone from http://civicrm.org/professional/ to help you write the report.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

sraisz

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
    • sambandha.net
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
Re: Creating a report limited to a individual relationship
April 16, 2010, 01:32:58 pm
OK

I will put together a brief and get a quote.

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Creating a report limited to a individual relationship
April 20, 2010, 04:59:57 pm
There already is a relationship report, and it does let you filter by the relationship type.
It also lets you filter by group, so if you have a subset of records you want to restrict to, you can do that.

Or were you looking to limit the results by the logged in user? If so, yes -- that would require custom work.

I made some mods to the activity report to allow restriction by logged in user (http://issues.civicrm.org/jira/browse/CRM-5902).
Haven't looked at the relationship report, but you might be able to borrow some of the code from that report.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Creating a report limited to a individual relationship

This forum was archived on 2017-11-26.