notOverlaps and notContains for arrays?
kuldeep-extentia opened this issue · 1 comments
kuldeep-extentia commented
Hi,
Is there support for notOverlaps and notContains for array type column?
Also, above stuff in insensitive form?
mattbretl commented
(Sorry for the delayed response!)
You should be able to use not
to construct notOverlaps
or notContains
, e.g.
allThings(filter: { not: { someField: { overlaps: $arr } } }) {
...
}
For more complex logic (e.g. case-insensitive versions of these array operators), I recommended writing a small plugin where you can take full control of the SQL. See #173 (comment) for an example.