CODEWITHSUNDEEP
ruby-on-railsactiverecord
Sergey Chechaev
Sergey Chechaev

Reputation: 570

How to show Query result Activerecord Query Interface

I have а little question, write through Activerecord Query Interface It's actually:

Gp.select("date('gps'.'created_at') as date,('users'.'name') as name, SUM('gps'.'sum_issue') as sum_issue").joins('LEFT JOIN users ON users.id = gps.user_id').where("users.ab_id = :abs_id AND users.id != 20", {:abs_id => current_user.ab_id}).group("users.name")

Result of query must be user name, sum,and date. If i do this query directly from SQLlite it's work, But Active Record Query Interface give me 

[#<Gp sum_issue: 289000>, #<Gp sum_issue: 364130>, #<Gp sum_issue: 620000>]

How i can get a name,date,sum_issue and show it in my helper. like this:

{
 created_at: datet,
 sum_issue: sum_issue,
 name: name
}

Upvotes: 1

Views: 728

Answers (1)

Denis Tataurov
Denis Tataurov

Reputation: 193

Try

Gp.select("date('gps'.'created_at') as date,('users'.'name') as name, SUM('gps'.'sum_issue') as sum_issue").joins('LEFT JOIN users ON users.id = gps.user_id').where("users.ab_id = :abs_id AND users.id != 20", {:abs_id => current_user.ab_id}).group("users.name").first.name

Upvotes: 1

Related Questions