marikka! awesome. Thanks for sharing. On Mon, Mar 8, 2010 at 8:35 AM, marikka <marek.mietti...@gmail.com> wrote: > Thanks Jarin for the idea! > > I used named scopes in my user model like this: > > named_scope :age_gt, lambda { |age| { :conditions => ['birthdate < ?', > age.to_i.years.ago] }} > named_scope :age_lt, lambda { |age| { :conditions => ['birthdate > ?', > age.to_i.years.ago] }} > > now I don't need to use a special query to achieve this. > > > > On 21 helmi, 01:06, Vincent P <ease...@gmail.com> wrote: >> Converting to datetime object is an excellent idea. Thanks Jarin! >> >> On Feb 20, 12:02 am, Jarin Udom <ja...@robotmo.de> wrote: >> >> > For that particular search, you'll have to build your own search >> > queries. The only other option is to load all records into memory and >> > filter by the age instance method, but of course you don't want to do >> > that. >> >> > Searchlogic will still make the search easier though. You can convert >> > the age from an integer into a datetime object and use it in a >> > Searchlogic search like so: >> >> > age = 29 >> >> > User.birthdate_greater_than(age.years.ago).birthdate_less_than((age - >> > 1).years.ago).all >> >> > Hope this helps! >> >> > Jarin Udom >> > Robot Mode LLC >> >> > On Feb 19, 10:30 pm, Ease Bus <ease...@gmail.com> wrote: >> >> > > Can I use something like searchlogic to search for objects based on >> > > the return values of instance methods? E.g., I'd like to search for >> > > users of a certain "age" but age is not a column, it's an instance >> > > method, returning the age value calculated from the birthdate, which >> > > is a column. >> >> > > Is there a quick way like searchlogic to do this or do I have to build >> > > my own search queries? Thanks. > > -- > 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. > >
-- 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.