Search include all values in list

[okkez]

Currently,

Facility.select.output_columns(["name"].filter("levels == 'A' && levels == 'B' && levels == 'C'")

I want to write same query like following:

Facility.select.output_columns(["name"]).filter.in_values(:levels, include_all: true, %w(A B C))
# or
Facility.select.output_columns(["name"]).filter.include_all_values(:levels, %w(A B C))

How about this?

[kou]

Extending in_values isn't good idea. in_values is the same semantics as IN in SQL.
We should not add AND mode to in_values.

The following will return what you want:

Facility.select.filter("query(%{match_columns}, %{query})", match_columns: "levels", query: "A B C")

It's a good idea that we provide the following API for this use case:

select.filter.query([:levels], "A B C")

NOTE: It seems that using == for vector is unexpected. @ is a suitable operator for "whether the specified element is included in the vector" query.

[okkez]

select.filter.query([:levels], "A B C")

is LGTM.