Filter array on an object fields about tile38 HOT 4 CLOSED

# with field numerical values which is faster than filter expressions)

SET collection item1 FIELD isAdmin 1 OBJECT '{"type":"Feature","geometry":{"type":"Point","coordinates":[-112,33]},"properties":{"speed":55,"age":23,"name":"Carol","role":["admin","user","guest"]}}'  

SET collection item2 FIELD isAdmin 2 OBJECT '{"type":"Feature","geometry":{"type":"Point","coordinates":[-112,33]},"properties":{"speed":55,"age":23,"name":"Carol","role":["user","guest"]}}'  

SCAN collection WHERE isAdmin 1 1
>> returns item1 only

SCAN collection WHERE isAdmin 1 2
>> returns item1 and item2

SCAN collection WHERE isAdmin 2 2
>> returns item2 only

# with filter expressions

SET collection item1 FIELD isAdmin true OBJECT '{"type":"Feature","geometry":{"type":"Point","coordinates":[-112,33]},"properties":{"speed":55,"age":23,"name":"Carol","role":["admin","user","guest"]}}'  

SET collection item2 FIELD isAdmin false OBJECT '{"type":"Feature","geometry":{"type":"Point","coordinates":[-112,33]},"properties":{"speed":55,"age":23,"name":"Carol","role":["user","guest"]}}'  

SCAN collection WHERE 'isAdmin === true'
>> returns item1 only

SCAN collection
>> returns item1 and item2

SCAN collection WHERE 'isAdmin === false'
>> returns item2 only

{
  "type": "Feature",
  "geometry": { "type": "Point", "coordinates": [-112, 33] },
  "properties": {
    "speed": 55,
    "age": 23,
    "name": "Carol",
    "hobbies": ["music", "game", "sport", "dance", "racing", ...... ]
   }
}