Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

             {"field":"ObjectStatus","value":"Free","operation":"=","andora ndor":"or","useBrackets":")"},

...

       {"field":"Price","value":" '0' and '10000000' ","operation":"between","andor":"and"}

]


The function useBrackets is what allows to assemble this into one.

...

operation - type of operation to be searched for ( =, <>, >, <, between, like)

andor - type of data connection (and, or)

useBrackets - allows joining results of several filters at once, you need to open them and close them, like in math formulas. 


Note that syntax for when you set do an operation BETWEEN in "value" is a single upper quote (‘)

{"field":"Bedrooms","value":" '2' and '2.9' ","operation":"between","andor":"or"}

but - {"field":"Bedrooms","value":"2","operation":"=","andor":"or"} , when no between is used. 


You can also sort results - 

...

         {"field":"Bedrooms","value":" '#Variable:f_cb_0#' and '#Variable:f_cb_0#.9' ","operation":"between","andor":"or","useBrackets":"("},

         {"field":"Bedroomsр","value":" '#Variable:f_cb_1#' and '#Variable:f_cb_1#.9' ","operation":"between","andor":"or"},

         {"field":"Bedrooms","value":" '#Variable:f_cb_2#' and '#Variable:f_cb_2#.9' ","operation":"between","andor":"or"},

         {"field":"Bedrooms","value":" '#Variable:f_cb_3#' and '#Variable:f_cb_3#.9' ","operation":"between","andor":"or"},

         {"field":"Bedrooms","value":" ‘#Variable #Variable:f_cb_4# ","operation":">=","andor":"or","useBrackets":")"},

   {"field":"Kitchen_size","value":" '#Variable:filter_square_kit_ot#' and '#Variable:filter_square_kit_do#' ","operation":"between","andor":"and"},

   {"field":"Total_Size","value":" '#Variable:filter_square_ot#' and '#Variable:filter_square_do#' ","operation":"between","andor":"and"},

   {"field":"Floor","value":" '#Variable:filter_floor_ot#' and '#Variable:filter_floor_do#' ","operation":"between","andor":"and"},

   {"field":"Floor","value":"#Variable:filter_floor_not_one#","operation":"<>","andor":"and"},

...

   {"field":"Price","value":" '#Variable:filter_price_ot#' and '#Variable:filter_price_do#' ","operation":"between","andor":"and"},

    {"field":"Finishing","value":"#Variable:filter_finishing#","operation":"=","andor":"and"}

...