CODEWITHSUNDEEP
elixirecto
rjurado01
rjurado01

Reputation: 5535

How to use ANY operator with array field with Ecto?

How to find all posts with a tag 'apple' ?

  schema "posts" do
    field :title, :string
    field :content, :string
    field :tags, {:array, :string}

    timestamps()
  end

With postgresql it would be:

SELECT title FROM posts WHERE 'apple' = ANY(tags);

Upvotes: 0

Views: 993

Answers (1)

Justin Wood
Justin Wood

Reputation: 10061

You will want to use Ecto's in/2 operator. The second example for that function is exactly what you want.

MyApp.Repo.all(from post in MyApp.Posts, where: ^"apple" in post.tags)

Upvotes: 3

Related Questions