An ambiguous sentence in Rails

Question

I am making a polymorphic compound as follows:

Object.joins(:customer).includes("jobs.name").merge(@customer.children.scoped).where("name LIKE :name OR job_number LIKE :name", {:name => "JOB" } ) 

And he returns like this:

 Mysql2::Error: Column 'name' in where clause is ambiguous 

Does anyone know how to make this unambiguous? :)

Answer 1

I do not like the name LIKE section.

It looks like each table has a column called name . Imagine a specific name with the name of the table from which you want this value to be.

It looks like it should be either

 .where("jobs.name LIKE :name OR job_number LIKE :name", {:name => "JOB" } ) 

or

 .where("customers.name LIKE :name OR job_number LIKE :name", {:name => "JOB" } ) 

I found in general, the best way to solve these problems is to look at the sql created and determine where the problem is. You can find sql in the logs.

Answer 2

name must be a property (and a column) in both tasks, and, nevertheless, any other object (table) must be fully qualified.

change

 "name like..." 

to

 "tablename.name like..." 

just like you qualify

 "jobs.name"