Rails SQL Query if null

Question

I'm trying to do a rails scope using a lambda function by passing in one value:

"scope :for_rank, lambda {|rank| where('min_rank <= ? AND max_rank >= ?', rank, rank)}"

however, it is possible that max_rank is null. In this situation, I want the query to only do the min_rank <= ? part. How can I do this?

Example:

"a.min_rank = 10"
"a.max_rank = 20"
"b.min_rank = 15"
"b.max_rank = nil"

i want the search of for_rank(15) should return both a and b.

Rahul Tapali · Accepted Answer · 2013-03-03 18:10:57Z

2

Try this:

 scope :for_rank, lambda {|rank| where('(min_rank <= ? AND max_rank IS NOT NULL AND max_rank >= ?) OR (min_rank <= ? AND max_rank IS NULL)', rank, rank, rank)}

edited Mar 3, 2013 at 18:10

answered Mar 3, 2013 at 18:05

Rahul Tapali

10.2k7 gold badges33 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Rails SQL Query if null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related