CODEWITHSUNDEEP
postgresqlelixirphoenix-frameworkecto
Paulo Janeiro
Paulo Janeiro

Reputation: 3221

How to full text search more than one "model" field using Ecto and PostgreSQL

I'm using this search function in my controller:

def search(query, search_term) do
    (from u in query,
    where: fragment("to_tsvector(?) @@ plainto_tsquery(?)", u.name, ^search_term),
    order_by: fragment("ts_rank(to_tsvector(?), plainto_tsquery(?)) DESC", u.name, ^search_term))
  end

It's working for just one field of my model. I would like to search all fields or be able to search a selected few (name_label, contacts, ...) at the same time. How to do it?

Upvotes: 0

Views: 866

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247575

You can use

(to_tsvector(col1) || to_tsvector(col2))) @@ plainto_tsquery(?)

to concatenate text search vectors.

Upvotes: 1

Related Questions