PG::UndefinedTable: ERROR: missing FROM-clause entry for table "clients"

Question

I got the following error:

PG::UndefinedTable: ERROR: missing FROM-clause entry for table "clients".

This occurs when I try to execute the following query:

SELECT  "folders".* FROM "folders" WHERE (clients.name ilike '%aleena%')  ORDER BY clients.name LIMIT 10):

The following code is used for select:

  def search_folders
    Folder.where('clients.name ilike :search', search: "%#{@params[:s]}%")
          .references(:clients)
          .order('clients.name')
          .limit(@params[:per] || 10)
  end

Do you have folders table in your db? Did you create and run your migrations? — Marek Lipka
You are using :clients table in the where clause but it doesn't present in the :from — Alexander Shlenchack
Like @AlexanderShlenchack wrote, you try to fetch folders, but you're using clients columns in your where clause. — Marek Lipka

Marek Lipka Marek Lipka · Accepted Answer · 2015-12-18T07:44:34

You should join your clients table in your query:

Folder.joins(:client)
      .where('clients.name ilike :search', search: "%#{@params[:s]}%")
      .references(:clients)
      .order('clients.name')
      .limit(@params[:per] || 10)

PG::UndefinedTable: ERROR: missing FROM-clause entry for table "clients"

1 Answers