> > @licences = Licence.scoped_by_user_id(10) > usedpermlicence = @licences.scoped_by_status_and_licence_type(1, 0) > usedtemplicence = @licences.scoped_by_status_and_licence_type(1, 1) > remainlicence = @licences.scoped_by_status_and_licence_type(0, 0) > remaintemplicence = @licences.scoped_by_status_and_licence_type(0, > 1) > > Please let me know is there any way to store all the licences into one > object and can retrieve data from this object without any db query. >
Sure: usedpermlicence = @licences.select {|o| o.status == 1 && o.licence_type == 0} usedtemplicence = @licences.select {|o| o.status == 1 && o.licence_type == 1} etc... You can treat @licences as an array and just select the items you want. One DB query (which you're already doing) and a quick bit of filtering. http://ruby-doc.org/core/classes/Array.html#M002191 Cheers, Andy -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.