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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Advanced Search on Activities for Type Membership Renewal returns empty result.
Pages: [1]

Author Topic: Advanced Search on Activities for Type Membership Renewal returns empty result.  (Read 1456 times)

Aahar

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 3
  • CiviCRM version: 3.4 and 4.0
  • CMS version: Drupal 6.17, 6.x and Drupal 7.x
  • PHP version: 5.2
Advanced Search on Activities for Type Membership Renewal returns empty result.
January 14, 2012, 11:30:28 am
 Advanced Search on Activities for Type 'Membership Renewal' returns empty result. But I checked that there are Activities of Membership Renewal. Is this a bug or am I missing something.
I tried including the date range, added more activity type, then added Individual contact-type in subsequent attempts. Yet all results were empty

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: Advanced Search on Activities for Type Membership Renewal returns empty result.
January 14, 2012, 03:42:57 pm

1. Can you try and see if this works with Find Activities

2. There is a bug / anomaly with Advanced Search. Most likely it will only find activities which have a target contact. Some of the default activities use the assignee rather than the contact. There is a plan to clean up activities and normalize the tables in a future version

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

Aahar

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 3
  • CiviCRM version: 3.4 and 4.0
  • CMS version: Drupal 6.17, 6.x and Drupal 7.x
  • PHP version: 5.2
Re: Advanced Search on Activities for Type Membership Renewal returns empty result.
January 15, 2012, 07:42:34 am
Thanks for response.

1. I tried with Find Activities. It did Not work. Even providing a name or email did not produce any result. In fact no matter how much I broaden the search the results is empty

2. Can I do something to clean up. I would need some guidance. This feature is important for my non-profit org.

I need to know the list of all the members who renewed membership in last one month (or even better if a date range is possible). Is there a work-around?

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: Advanced Search on Activities for Type Membership Renewal returns empty result.
January 15, 2012, 09:00:33 am

1. Your best bet would be to look at the queries generated and see the final query and whats going wrong

2. I think we need to do an activity table normalization (i.e. collapse the 2 tables / 3 fields (source, assignee, target)) into one table. This will make search a lot faster (fewer left joins) and across all contacts involved with the activity (something we cannot do now because of scaling reasons). The actual change should be quite easy (10-20 hours work) but the upgrade script will be a slight issue since these tables are potentially huge and will need to be done incrementally

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

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: Advanced Search on Activities for Type Membership Renewal returns empty result.
April 25, 2012, 10:41:43 pm
hi lobo - to be clear are you saying this work will be involved so that we can have any capability of using Adv Search to eg find all those who did a renewal during a certain period based on the Activity = Membership Renewal since I am also failing to get any results from trying such a search regardless of how many % I throw at it
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

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: Advanced Search on Activities for Type Membership Renewal returns empty result.
April 26, 2012, 06:45:37 am

hey pete:

check if membership renewal puts the contact as assignee or target. If assignee, advanced search wont find it :(

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

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: Advanced Search on Activities for Type Membership Renewal returns empty result.
April 26, 2012, 01:12:58 pm
hmm - yes Membership Sign Up, Membership Renewal, Contribution, are all put in as assignee

seems like we are losing some valuable options by not being able to search for these - I suspect there could be others too.
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

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: Advanced Search on Activities for Type Membership Renewal returns empty result.
April 26, 2012, 02:16:32 pm

all this will be fixed when eileen start her "grand activity restructuring and scalability" project, coming in a release in the not-too-very-distant-future

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

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: Advanced Search on Activities for Type Membership Renewal returns empty result.
April 26, 2012, 02:40:29 pm
 ;D cool - i will let her know
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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Advanced Search on Activities for Type Membership Renewal returns empty result.

This forum was archived on 2017-11-26.