Page Comparison

BasicAREA:
{"$area": {"type":"county", "name":"Kent"}}
{"$area:like": {"type":"county", "name":"Kent"}}
{"$area:match": {"type":"county", "name":"Kent"}}
{"$area:beginsWith": {"type":"county", "name":"Kent"}}


AREA $IN:
{"$area": {"type":"county", "name":"Kent", "$in":{"id":["2", "5"]}}}
{"$area": {"type":"county", "name":"Kent", "$in:like":{"name":["pples", "gol"]}}}
{"$area": {"type":"county", "name":"Kent", "$in:match":{"name":["apples", "golf"]}}}


--- SINGLE TABLE ----- 

AREA TABLEFIELD - Single table - Single value
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id": "BD-1800.2000"}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:like":[{"service_taxonomy.taxonomy_id": "BD-1800.2000"}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:match":[{"service_taxonomy.taxonomy_id": "BD-1800.2000"}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:beginsWith":[{"service_taxonomy.taxonomy_id": "BD-1800.2000"}]}}


AREA TABLEFIELD - Single table - Single value - INNER OVERRIDE
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id:like": "BD-1800.2000"}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id:match": "BD-1800.2000"}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id:beginsWith": "BD-1800.2000"}]}}


AREA TABLEFIELD - Single table - array value
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:like":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:match":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:beginsWith":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]}]}}


--- MULTI TABLE ----- 

AREA TABLEFIELD - multi table
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code": ["49503"]}]}}

AREA TABLEFIELD - multi table - INNER OVERRIDEs
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id:match": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code:like": ["49503"]}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field":[{"service_taxonomy.taxonomy_id:match": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code:beginsWith": ["49503", "49504"]}]}}

AREA TABLEFIELD - multi table - OUTER LIKE
{"$area": {"type":"county", "name":"Kent", "$table.field:like":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code": ["49503"]}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:like":[{"service_taxonomy.taxonomy_id:match": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code:beginsWith": ["49503"]}]}}

AREA TABLEFIELD - multi table - OUTER MATCH
{"$area": {"type":"county", "name":"Kent", "$table.field:match":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code": ["49503"]}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:match":[{"service_taxonomy.taxonomy_id:like": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code:beginsWith": ["49503"]}]}}

AREA TABLEFIELD - multi table - OUTER BEGINSWITH
{"$area": {"type":"county", "name":"Kent", "$table.field:beginsWith":[{"service_taxonomy.taxonomy_id": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code": ["49503"]}]}}
{"$area": {"type":"county", "name":"Kent", "$table.field:beginsWith":[{"service_taxonomy.taxonomy_id:match": ["BD-1800.2000", "PH-6100.6800"]},{"physical_address.postal_code:like": ["49503"]}]}}



$or
{"$or":[{"name":["PALLIATIVE CARE", "PUBLIC LIBRARY"]},{"name":"911 SERVICES"}]}

$or:like
{"$or:like":[{"name":["PALLIATIVE CAR", "UBLIC LIBRARY"]},{"name":"911 SERVIC"}]}

$or:match
{"$or:match":[{"name":["PALLIATIVE", "LIBRARY"]},{"name":"SERVICes"}]}


$and
{"$and":[{"name":["PALLIATIVE CARE", "PUBLIC LIBRARY"]},{"id":"69"}]}

$and:like
{"$and:like":[{"name":["PALLIATIVE CAR", "UBLIC LIBRARY"]},{"id":"69"}]}

$and:match
{"$and:match":[{"name":["PUBLIC"]},{"alternate_name":"FIRE"}]}