ruby on rails - Search date with the condition -

i have model, define block looks like:

define_index   indexes title, content, manager, note, start_date, end_date    has created_at, updated_at    has user_id, :as => :user_id, :type => :integer    set_property :delta => true end 

i want search tasks date, can fall gap between start_date..end_date , how can ?

seems standard active record sql call. since you're passing parameters, can hashed query so:

    tasks = task.where("start_date > :start_date , end_date < :end_date", {:start_date => start_date, :end_date => end_date}) 

drop in method supplies start_date , end_date so:

def tasks_within_range(start_date, end_date)   task.where("start_date > :start_date , end_date < :end_date {:start_date => start_date, :end_date => end_date}) end 

and you've got dynamic finder! :)