How to make activerecord use a field generated on the fly by find_by_sql

230 Views Asked by At

I'm using find_by_sql with Activerecord which I generate another field there that doesn't in the original table as a combination of different fields like:

select (field1 + field2) as new_field_name

If I try to access the newly generated field like:

@user.new_field_name

I get nothing! How do you suggest I should approach this problem

1

There are 1 best solutions below

3
On BEST ANSWER

@user = select (field1 + field2) as new_field_name

This will return array although you get only one record.itearte a loop over @user

for user in @user
   puts user.new_field_name ###this should return a sum of field1 & field2 ###
end
OR
if you want 1st record then

@user[0].new_field_name