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.
>
> 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)
>
>
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rubyonrails-talk+unsubscr...@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/ifFqk0WyB9YJ.
For more options, visit https://groups.google.com/groups/opt_out.
