what is equivalent with "IN" operator in Aerospike?

Question

I have a set by this structure and data:

+--------+-----------+---------+
| MODEL  | COLOR     | OWNER   |
+--------+-----------+---------+
|Benz    | Red       | p1      |
+--------+-----------+---------+
|BMW     | Blue      | P2      |
+--------+-----------+---------+
|Ferrari | YelloW    | P3      |
+--------+-----------+---------+
|Audi    | Blue      + P4      |
--------------------------------

now want to search in aerospike for just yellow and blue cars. I search in aerospike documentation in both AQL and Query section but I cannot find any things. I want to simulate this SQL query in aerospike with C# client:

Select * from cars where color in ('Yellow', 'Red')

user_1917187 · Answer

Color IN (Yellow, Red) would logically be same as Color==Yellow OR Color==Red. You can build such an Expression to filter the query. See example in response to : using multiple logical operations like OR,AND,NOT in Aerospike

For C# client see: QueryExp.cs in the Csharp client code / Framework/AerospikeDemo

user_1917187 · Answer

Aerospike recently updated Predicate Filters to Expressions. Currently clients and server will support both but at some point Predicate Filters will be deprecated. Expressions are more intuitive in syntax, achieve the same functionality as Predicate Filters and further extend it. For C#, this link should show you the code example: https://github.com/aerospike/aerospike-client-csharp/blob/master/Framework/AerospikeDemo/QueryExp.cs

what is equivalent with "IN" operator in Aerospike?

2 Answers