Rails adding computed field to a join of multiple tables

Rails
1

I did join on three tables.

arel = OfferOrder.includes(:a, :b, :c) arel = arel.select(’(CASE WHEN
ISNULL(c.field2) THEN c.field1 ELSE c.field2 END) AS fraud’)

but when I run my code it gives error that

(Mysql2::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'AS fraud)

2

Also I did try it this way,

arel = OfferOrder.includes(:a, :b).joins(:c).select(’(CASE WHEN
ISNULL(c.fields2) THEN c.fields1 ELSE c.field2 END) ')

Got error,

ActiveModel::MissingAttributeError (missing attribute: a_id):

I did join on three tables.

3

On Thu, Mar 14, 2013 at 5:16 AM, Sumit S.
[email protected] wrote:

near 'AS fraud)

What was the SQL it generated?

4

On 15 March 2013 16:41, tamouse mailing lists
[email protected]wrote:

(Mysql2::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use
near 'AS fraud)

What was the SQL it generated?

Resolved this. Had to defined the join conditions and it worked. Though
am
stuck on another.
The select query is not working when another query is made using <<SQL
tags
in the code. Can’t avoid using those.

Regards
Sumit S.

The power of imagination makes us infinite…