Rails - how to make query parameters optional in Model?

Question

I am trying to build a filter area on my index with multiple parameters. My problem is that I don't know how to make each of them optional if I need to. I mean, even if I don't set a value to a field, I want my filter to only work with the ones I filled.

I wrote this code which works well, except when I remove one or several parameters.

def self.filter(type, min, max, start_at, end_at)
 where(type => min..max, :first_date => start_at..end_at).order("#{type}": :desc)
end

I know I can use scope but as I am new to Rails, it's pretty unclear. If somebody can come with some hints? Thanks!

This has already been answered here: stackoverflow.com/questions/15474883/… — omnikron
– omnikron, Commented Sep 13, 2016 at 17:55

Bartłomiej Gładys · Accepted Answer · 2016-09-13 15:37:50Z

2

You can atrriubte these to nil

def self.filter(type =nil, min=nil, max=nil, start_at=nil, end_at=nil)
  a = YourModel
  a = a.where(type => min..max) if min.present? && max.present?
  a = a.where(first_date: start_at..end_at) if start_at? && end_at.present?
  a = a.order("#{type}#": :desc) if type.present?
  a
end

answered Sep 13, 2016 at 15:37

Bartłomiej Gładys

4,6151 gold badge17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3033467 · Accepted Answer · 2016-09-13 15:36:39Z

0

You could chain multiple where

result = where(type => min..max)
result = result.where(first_date: start_at..end_at) if start_date && end_date
return result

answered Sep 13, 2016 at 15:36

user3033467

1,21817 silver badges27 bronze badges

Collectives™ on Stack Overflow

Rails - how to make query parameters optional in Model?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related