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) »
  • AdvSearch search gives different total (-2) to Find Member but export same
Pages: [1]

Author Topic: AdvSearch search gives different total (-2) to Find Member but export same  (Read 1196 times)

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
AdvSearch search gives different total (-2) to Find Member but export same
March 03, 2008, 12:23:23 pm
Hi - this may not be an issue at all - and I tried on your sandbox with no joy.
Because I need to build reports with Member Data and Custom Data I am exporting from both CiviMember and from AdvSearch.
When i use exactly the same search criteria (ie just tick same membership type and not any other selections) I get a different total (seems to be out by 2 each time) between Find Member (CiviMember) and AdvSearch (CiviCRM). Yet when I export results I had the same data set (phew)
It threw me a few times as I thought new members may have been added while I was doing the searches, but it has become consistent - ie FindMembers gives me 4263 and Adv Search 4261.
As I say, may not be an issue of concern but thought I would post in case it is indicative of something not quite working as you might hope it does
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: AdvSearch search gives different total (-2) to Find Member but export same
March 03, 2008, 01:44:17 pm

most likely advanced search gives you only unique contact ids (i.e. if a contact has multiple memberships, it will only display 1). Find Member is focussed more on memberships and will give repeat the contacts that have duplicate memberships. So i suspect u have 2 contacts who have 2 memberships each

export in advanced search should actually just export 4261 records (and not 4263). so there is bug with export there :( If you can reproduce on drupal.demo that would be great and help us fix it :)

thanx

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: AdvSearch search gives different total (-2) to Find Member but export same
March 03, 2008, 02:36:08 pm
Hmm - nailing this down may not be easy - but thought I would check this.

Adv Search = All party members = search result says 4621 - click on 'last' to see if there really are only 11 on it, rather than 13 (that i expect) - there are 11 - click All to grab all records again and hey presto it tells me there are 4623 now - click on 'last' (again - does it have 13 now) but even though the page says Contact 4251 - 4263 of 4263 - it only shows the original 11 results  ???

go back to Adv Search, redo to verify if two members have been added  - no still tells me only 4261

Export all '4261' records - get 4261 records

Go back to Adv Search - click All - get told there are 4263 records - Export (says 4263 to export) - get 4261 (brain ache)

This is not repeating what occured yesterday when it was exporting a larger number than it 'found'

Anyhow, i will desist. I will just not presume the number 'found' is the same as the number 'exported'  :-\

If i spot any other clues I will let you know, and yes we may have 2 members with 2 memberships but can't see that i can find just them from Find Member or Adv Search as both treat different 'status' as OR - and can't get to this via Search Builder.

Okay - i didn't desist - instead of exporting my 4261 using the 'standard profile' i used my own and yay it exported 4263 - so now i can presumably check what the two oddities are!
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

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: AdvSearch search gives different total (-2) to Find Member but export same
March 03, 2008, 02:43:44 pm
Aaargh - it was that bl&%dy Chris Burgess - three memberships on his record - so that explains the anomaly for me - but may not help you sort out why it produced different outcomes within the same AdvSearch - i can understand why it affected the export as when i ask it to export the memb status it has to do so x3 for chris (so 2 extra) but don't see why working within the search results - ie before export - it should keep slipping between 4261 and 4263.
Did that help? :-\
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) »
  • AdvSearch search gives different total (-2) to Find Member but export same

This forum was archived on 2017-11-26.