DataAssist Search question
Hi,
I have the following defined with DataAssist Search:
---
$WADbSearch1->addComparisonFromList("object_City","City","AND","=",0);
$WADbSearch1->addComparisonFromList("object_Typeobject","typeobject","AND","=",0);
$WADbSearch1->addComparisonFromList("object_Typeoffer","typeoffer","AND","=",0);
$WADbSearch1->addComparisonFromEdit("object_Square","square","AND",">=",1);
$WADbSearch1->addComparisonFromEdit("object_Square","square2","AND","<=",1);
$WADbSearch1->addComparisonFromEdit("object_Squarefrom","square2","OR","<=",1)
---
When the last one is at OR the other filters like "City" or "Typeobject" are "ignored".
I would like to have the last 3 as in this query sample (see extra brackets) so the orther filters are not ignored:
AND
(objecten. object_Square >= 500 AND objecten. object_Square <= 700 OR objecten.object_Squarefrom <=700)
Is this possible?
Thanks, Ron