CiviCRM Community Forums (archive)

I have a custom search that returns more than one page worth of results. However, the table "civicrm_prevnext_cache" remains empty.   What in the custom search normally triggers appropriate records getting inserted into the "civicrm_prevnext_cache"?   

You have to check couple of things. There are

1) Your custom search class should extends with CRM_Contact_Form_Search_Custom

2) Your custom search class should have contactIDs method.
 
function contactIDs($offset = 0, $rowcount = 0, $sort = NULL) {
    return $this->all($offset, $rowcount, $sort, FALSE, TRUE);
  }
3) Check that $this->all() method should return the sql query like

SELECT contact_a.id as contact_id FROM
Query should be select only contact id field from table.


For additional info:
civicrm_prevnext_cache table insertion is code is on below file and method. Please check.

 civicrm/CRM/Contact/Selector.php

function fillupPrevNextCache($sort, $cacheKey, $start = 0, $end = 500) {
...
}

Thanks