Search for array values

[ursulnegrul]

Given a Jig mapper:

{
"set": 123,
"opt": [
            4,
            5,
            6
        ],
}

How can I search using IN array

 $Obj->load([
'set = :set AND :opt IN opt',
 ':set' => 123,
 ':opt' => 5
]);

I guess is not possible and I should use relationships?

[ikkez]

Well it would be possible with the raw Jig Mapper, but there's no handy feature in the cortex query parser that would help here. however, you can write it as php filter instead, try: $obj->load(['set = :set and in_array(:opt,@opt)', ':set'=> 123, ':opt'=> 5]).

Not tested though.

[ursulnegrul]

Nope, it searches for the "in_array" column.