sql - rails named scope issues -

I have two designated scopes ... both of which work separately, but when combined do not work.

  Named_scope: Total,: Select => "As the COUNT (*) days, average (value) as the value, SUM (value) total" ,: group = & gt; : Parent_id name_scope: currency, lambda {| Code | {: Choose => Example:  

P>

  C = booking Total.currency ("EUR") Find_all_by_parent_id (63)  

The total designated scope works but the currency is not ...

  c = Booking.currency ("EUR"). Total.find_all_by_parent_id (63)  

Scope named design works, but not yoga ...

Any thoughts?

I think you have some problems.

• Both scope "define value" and they define conflict, this will generate invalid SQL

• One scope There is a group segment, but there is not an overall work on the non-classified feature in the second selection section, the result will be in the invalid SQL.

Instead of the complexity of your class, consider using a math feature on your booking model.

  Class Booking DIF currency (code = "USD") Price * CurrencyRate.get_rate (code), 1) End and  

You can do this now

Booking for ticket in booking = booking.otal_fin_all_by_parent_id (63) ends booking.currency ("EUR")

if you If you want to use a scope, then consider combining them. I know you probably do not want to designate nomination for each permutation, but I think there must be some changes. You can create a named_scope: currency_total

  named_scope: currency_total, lambda {| Code | {: Choose => "Value as the price (*), AVG (Price * # {(currency RA.GetTrot (" US Dollar ", (code =" USD "), 1))}) As the value, SUM (Value * # Get_rate ("USD", (code || = "USD"), 1))}) Total ",: group = & gt; : Parent_id}}