graphile-contrib/postgraphile-plugin-connection-filter

notOverlaps and notContains for arrays?

kuldeep-extentia opened this issue · 1 comments

Hi,
Is there support for notOverlaps and notContains for array type column?
Also, above stuff in insensitive form?

(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.