OS Property support center

extrafields quiery change from AND to OR

  • sergey
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 months 2 days ago #160067 by sergey
H , in \com_osproperty\classes\listing.php there is static function advSearch($option){  right, and inside of it I found a code for extra fields, BUT I want to make it in such a way that if the property has at least one of the extrafields selected in search module - then I will show it in the search query - so I want to change AND for OR in it, and I did - BUT - nothing changed, I searched all the codes but there is no other search query fo the extra fields with AND in it, can you please guide me what to look for? 

And here is the code we had before and how I changed it:
FROM:
    if((isset($extrafieldSql)) AND (count($extrafieldSql)) > 0){
                $extrafieldSql = implode(" AND ",$extrafieldSql);
                if(trim($extrafieldSql) != ""){
                    $where .= " AND ".$extrafieldSql;
                }
            }

TO:
    if((isset($extrafieldSql)) AND (count($extrafieldSql)) > 0){
                $extrafieldSql = implode(" OR ",$extrafieldSql);
                if(trim($extrafieldSql) != ""){
                    $where .= " AND ".$extrafieldSql;
                }
            }
 

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamNguyen Phu Quan