Witam.
Request.unsettled.find(:all,
:conditions => {:development_id => params[:development_id], :user_id => current_user.id}).any?
named_scope :unsettled -> accepted IS NULL AND expired_at IS NULL
generuje mi takie zapytanie:
SELECT * FROM “requests”
WHERE (“requests”.“user_id” = 5 AND “requests”.“development_id” = 77)
AND (accepted IS NULL AND expired_at IS NULL)
Jak zmienień powyższy kod aby dodać takie OR jak poniżej.
SELECT * FROM “requests”
WHERE (“requests”.“user_id” = 5 AND “requests”.“development_id” = 77)
AND ((accepted IS NULL AND expired_at IS NULL) OR (expired_at > now()))
Mam odpowiedniego named_scopa:
named_scope :active, lambda {{:conditions => ['expired_at > ?', Time.zone.now]}}
tylko nie wiem jak go dołączyc do tego finda powyżej.