Author Topic: Custom Search - How to not show all records from the SQL query (Read 1239 times)

SarahG (FountainTribe) · May 25, 2009, 06:22:55 pm

I have a custom search that is working well. But I want to improve it by allowing an additional selection criteria. But the problem is I won't know if the record meets the criteria until after the data comes back from the database and I have called my PHP function. I already am using the "alterRow" function to alter the contents of certain cells. But how do I exclude certain rows?

For example, the sql query returns 100 records. But I only want to display 30 records to the screen. ( the other 70 do not meet the criteria. ) And no, I cannot put the criteria in the SQL WHERE clause because I need to need to call a PHP function to know what to exclude. Also how will this impact the "count" function?

Thanks

Donald Lobo · May 25, 2009, 06:29:01 pm

the easiest option right now would be to use a temp table. Basically store all your results in the temp table. filter the temp table as needed using php function and delete rows etc. the count and sql are simple count/select on this temp table

check CRM/Contact/Form/Search/Custom/PriceSet.php

for an example of using a temp table

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Custom Search - How to not show all records from the SQL query (Read 1239 times)

SarahG (FountainTribe)

Custom Search - How to not show all records from the SQL query

Donald Lobo

Re: Custom Search - How to not show all records from the SQL query