Author Topic: Search result only showing 17 not 50 rows per page (Read 1398 times)

petednz · February 15, 2010, 03:58:47 pm

Hi - happening on a 2.2.8 and a new 3.1.2 site.

Adv Search for something with over 50 records. Page 1 shows 1-17, page 2 shows 18-35 etc hence 'last page' shows results that are only about one third through the list.

any pointers

Kiran Jagtap · February 16, 2010, 03:16:27 am

If I had to guess - row count per page is change across entire site or specific for contact selector.

can u confirm
1. CRM/Utils/Pager.php go to line around 56 do check 'ROWCOUNT', is it 50 ?
2. CRM/Contact/Selector.php go to line around 290, check is it like

Code: [Select]

$params['rowCount'] = CRM_Utils_Pager::ROWCOUNT;
hope this help

kiran

petednz · February 16, 2010, 11:48:44 am

Hi kiran - thanks for trying to help

Quote from: Kiran Jagtap on February 16, 2010, 03:16:27 am

can u confirm
1. CRM/Utils/Pager.php go to line around 56 do check 'ROWCOUNT', is it 50 ?
2. CRM/Contact/Selector.php go to line around 290, check is it like
Code: [Select]
$params['rowCount'] = CRM_Utils_Pager::ROWCOUNT;

They are both as stated above - and no customisation done

Eileen · February 17, 2010, 07:58:07 pm

Hi,

This is REALLY odd. 3.1.2

If I do a normal search for TAYLOR on the basic search & edit no other search fields I get 112 records returned. When I browse those records I see less than 112 and the last name I see is Phillip Taylor.

If I export them I get 112 records and there are names after Phillip Taylor.

If I click on the 'T' in the pages I'm suddenly told I have 120 records to work with even though there are 6 records of the original 112 that no longer show in the list as they don't start with T.

kdas · February 21, 2010, 02:49:30 pm

I see 26 records when it says Contact 1-50. I see the same results in 2.2.2, 31b5. I tried on Demo sandbox "Powered by CiviCRM 26090" it seems to work fine. Then I thought it should have been fix in 3.1.2 that just came out last week. I still get 26 records in 3.1.2. It seems someone may have fixed it on Demo sandbox after 3.1.2. Does anyone know?
Just want to clarify that there are over 1200 records in the search. If you click on Last that was not really the last page. There should have been more contacts after that. Just to help in debugging or isolate the problem, if you select a search profile in Adv Search then it really shows 50 records for Contact 1-50 that is correct.

Eileen · February 21, 2010, 02:56:15 pm

This turns out to be a data problem not a code problem

http://forum.civicrm.org/index.php?topic=11659.0

I tidied up the data using the sql statements in that thread (although they are examples not generic code) and the good news is that the next point version of CiviCRM will do this data tidy-up as part of the upgrade process.

kdas · February 21, 2010, 03:29:23 pm

Thanks for responding. In my database there are no duplicate primary addresses. I ran the following query and found 0 records.

SELECT CONTACT_ID , count(`ID`) as count FROM `civicrm_address` WHERE is_primary=1
GROUP by CONTACT_ID
having count(`ID`) > 1

Eileen · February 21, 2010, 03:32:34 pm

did you check emails too?

CiviCRM Community Forums (archive)

News:

Author Topic: Search result only showing 17 not 50 rows per page (Read 1398 times)

petednz

Search result only showing 17 not 50 rows per page

Kiran Jagtap

Re: Search result only showing 17 not 50 rows per page

petednz

Re: Search result only showing 17 not 50 rows per page

Eileen

Re: Search result only showing 17 not 50 rows per page

kdas

Re: Search result only showing 17 not 50 rows per page

Eileen

Re: Search result only showing 17 not 50 rows per page

kdas

Re: Search result only showing 17 not 50 rows per page

Eileen

Re: Search result only showing 17 not 50 rows per page