-1

I have a model table with 3 fields: "id", "amount" and "type". Im calling the paginate method to display the data but I need to replace the amount with "-" if type = "specific_type".

I can do this by replacing the values in the view with a "-" if the type condition is met. But this screws up the sort order as I would like the "-" values to be effectively evaluated as 0 but replacing values only in the view still leaves me with an incorrect sort order.

I thought about using find_by_sql and trying to create a virtual field using a CASE statement

select *, CASE type WHEN 'specific' THEN amount ELSE '-' END from amounts;

this way, I can use the virtual column.

The problem is that I need to take in a param hash of options which I would then have to manually render to SQL where clause. This sounds tedious unless there's a better way of doing it.

udit
  • 2,745
  • 3
  • 33
  • 44

2 Answers2

0

In your controller:

def index
    @resources = []
    your_resources = Resource.find(:all)        
    your_resources.each do |resource|
        resource.amount = '-' if resource.amount = "specific_type"
        @resources << resource  
    end 
end
thenengah
  • 42,557
  • 33
  • 113
  • 157
  • but I have to use_will_paginate for sorting it. if I do the above on the results from will_paginate, the result will not be sorted_right. – udit Mar 05 '11 at 00:48
0

I'd try to implement an attribute reader in your model like:

class YourModel < ActiveRecord::Base

  def amount
    (self.type == "specific_type") ? "-" : read_attribute(:amount)
  end

end
sled
  • 14,525
  • 3
  • 42
  • 70