Conditional queries

Hi. I’m attempting to return a result set which filters Pages by their
active state and their start/end date. Whilst the code I have at the
moment is doing this without problem, some of the Page items may not
have an end date set and I can’t see a way of conditionally doing the
query so these are not excluded.

Perhaps showing some code will help explain better;

search_controller.rb

  @results = Page.multi_search(
    "active:(true)
    *:(#{params[:s]})
    search_start_date:( <= #{Time.now.strftime("%Y%m%d")} )
    search_end_date:( >= #{Time.now.strftime("%Y%m%d")} )",
    [],
    {:offset => @offset, :limit => @limit}
  )

Page.rb

def search_start_date
self.start_at.strftime("%Y%m%d") if self.start_at
end

def search_end_date
self.end_at.strftime("%Y%m%d") if self.end_at
end

The problem being that I can’t figure out how to do the equivalent of:

    search_end_date:( IS NULL OR >= #{Time.now.strftime("%Y%m%d")} 

)",

Thanks for any help/advice,

Cam

On Thu, Nov 23, 2006 at 12:07:07PM +0100, Cameron Yule wrote:

Hi. I’m attempting to return a result set which filters Pages by their
active state and their start/end date. Whilst the code I have at the
moment is doing this without problem, some of the Page items may not
have an end date set and I can’t see a way of conditionally doing the
query so these are not excluded.

[…]

The problem being that I can’t figure out how to do the equivalent of:

    search_end_date:( IS NULL OR >= #{Time.now.strftime("%Y%m%d")} 

)",

indexing some special value like 99999999 for the end_date of records
not having an end data could to the trick.

Jens


webit! Gesellschaft für neue Medien mbH www.webit.de
Dipl.-Wirtschaftsingenieur Jens Krämer [email protected]
Schnorrstraße 76 Tel +49 351 46766 0
D-01069 Dresden Fax +49 351 46766 66

Jens K. wrote:

indexing some special value like 99999999 for the end_date of records
not having an end data could to the trick.

Jens

Hi Jens, thanks for the reply. I’d considered something along those
lines, but was curious if there was a neater method actually using the
AAF querying syntax itself. Still, I think I’ll use your solution in the
meantime.

Many thanks

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs