Undefined method where for Array

Question

I have this query, but I get this error: undefined method `where' for #Array:0x0000000443cd18

@kpig = KpiGroups.find_by_sql('select * from (
      select lk.login,sdf.* from (select kg.id, kg.name as "GROUP_NAME", kt.name, kt.id as "KPI"
      from spartacus.kpi_groups kg, spartacus.kpi_types kt left outer join (select kpiid as kpi, max(max_value) as max_val ,min(min_value) as min_val
      from (select kpiid,max_value,min_value from spartacus.stations group by  max_value,min_value,kpiid) group by kpiid) sel on(sel.kpi=kt.id) where  kt.parentcatalogid=kg.id) sdf
      left outer join spartacus.LKBs lk on lk.kpi_id=sdf."KPI" )').where("login = '#{current_user.login}'")

Oleg Rogov · Accepted Answer · 2013-10-24 07:05:43Z

1

You can do:

    @kpig = KpiGroups.find_by_sql("select * from (
  select lk.login,sdf.* from (select kg.id, kg.name as GROUP_NAME, kt.name, kt.id as KPI
  from spartacus.kpi_groups kg, spartacus.kpi_types kt left outer join (select kpiid as kpi, max(max_value) as max_val ,min(min_value) as min_val
  from (select kpiid,max_value,min_value from spartacus.stations group by  max_value,min_value,kpiid) group by kpiid) sel on(sel.kpi=kt.id) where  kt.parentcatalogid=kg.id) sdf
  left outer join spartacus.LKBs lk on lk.kpi_id=sdf.KPI ) where login='#{current_user.login}'")

answered Oct 24, 2013 at 7:05

Oleg Rogov

7203 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marek Lipka · Accepted Answer · 2013-10-23 14:19:41Z

1

find_by_sql method returns Array instead of ActiveRecord::Relation instance.

answered Oct 23, 2013 at 14:19

Marek Lipka

51.3k7 gold badges90 silver badges93 bronze badges

Collectives™ on Stack Overflow

Undefined method where for Array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related