Tengo un query que en mysql funciona correctamente:
SELECT dependents.name as "NOMBRES", dependents.lastname1 as "APELLIDO PATERNO", dependents.lastname2 as "APELLIDO MATERNO" FROM user_dependents INNER JOIN dependents ON dependents.id = user_dependents.dependent_id WHERE ((dependents.name like '%HUGO%' or dependents.lastname1 like 'HUGO%' or dependents.lastname2 like 'HUGO%')) GROUP BY dependents.id
la presente consulta la estoy queriendo ejecutar en Ruby on rails y tengo el siguiente error de sintaxis:
def self.search_dependent_by_name(dependent_name, sercret) escaped_dependent_name = dependent_name.gsub('%', '\%').gsub('_', '\_') @list_dependents = find(:all, :select=>"select dependents.name as 'name', dependents.lastname1 as 'lastname1', dependents.lastname2 as 'lastname2' from user_dependents INNER JOIN dependents ON dependents.id = user_dependents.dependent_id", :conditions=>["(name like ? or lastname1 like ? or lastname2 like ?)", "%" + escaped_dependent_name + "%", escaped_dependent_name + "%", escaped_dependent_name + "%"] ) return @list_dependents end
Por favor si alguien me puede apoyar con modificar a una sintaxis correcta.
Gracias.