Custom CRITS in record browser

dexcampos

Hello,

I'm trying to apply some crits to contact records.

I'm trying to do this where clause: id IN(14,15) OR (company_name IN(5,6) AND group IN('custm','developer') AND email IS NOT NULL AND first_name LIKE '%John%'

These are the crits I used that didn't work
[list:2iz5601y]

$crits = array('(id'=>array(14,15), '|group'=>array('custm','developer'), 'company_name'=>array(5,6), '"~first_name' => DB::Concat(DB::qstr('%'), DB::qstr('John'), DB::qstr('%')), '!email'=>'');

[/list:u:2iz5601y]
[list:2iz5601y]

$crits = array('(|group'=>array('custm','developer'), 'company_name'=>array(5,6), '(id'=>array(14,15), '"~first_name' => DB::Concat(DB::qstr('%'), DB::qstr('John'), DB::qstr('%')), '!email'=>'');

[/list:u:2iz5601y]

Please help.

Thanks.

ajb

Hi,

use this:

Utils_RecordBrowserCommon::merge_crits(

    array('id'=>array(14,15)),  // first crits

    array('company_name'=>array(5,6), '"~first_name' => DB::Concat(DB::qstr('%'), DB::qstr('John'), DB::qstr('%')), '!email'=>''), // second crits

    true // true to OR, false to AND

);

Regards,
Adam

dexcampos

Hello

I tried what you suggested



$crits1 = array('id'=>array('78'=>'78'));

$crits2 = array('company_name'=>array('65'=>'65'),'!email'=>'');

$finalCrits = Utils_RecordBrowserCommon::merge_crits($crits1, $crits2, true);

Final criteria was like this:

array(3) { ["^id"]=> array(1) { [78]=> string(2) "78" } ["^company_name"]=> array(1) { [65]=> string(2) "65" } ["!email"]=> string(0) "" }

The result is that is shows all records and is not filtering any 🙁

I believe this should be the SQL form of the criteria above

WHERE id IN(78) OR (f_company_name IN(65) AND NOT f_email='');

And when running the SQL form, it displays the data correctly.

ajb

I confirm that something is wrong and I also get all records...

dexcampos

Hello.

Is there a fix already for this?

ajb

Nope 🙁

All I know is that merging your crits with permission crits causes such problem. Those merged crits are transformed to wrong SQL query.
Instead of
(your-crit-1 OR your-crit-2) AND (permission-crit-1 OR permission-crit-2)
EPESI generates
(your-crit-1 OR your-crit-2 OR permission-crit-1 OR permission-crit-2)
what gives you all records.

I was trying to fix this, but I suspect that it may be unsolvable due to bad design 🙁

Regards,
Adam

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge