Search form min and max values

Discussion in 'Feature Requests' started by Scotty Delicious, Jan 4, 2015.

  1. Nörden Bräu

    Nörden Bräu New Member

    Joined:
    Jan 4, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    When doing a recipe search, a nice feature would be the ability to set min and max values for ABV and IBU. It may requiring adding an index on those fields to optimize the DB, but you may already have one since I can sort by both fields. I am not sure what backend you use, but an additional WHERE clause like

    Code:
    SELECT * FROM recipes WHERE recipe.ibu < request.max_ibu AND recipe.ibu > request.min_ibu
    Forgive the lame pseudo code and over generalizations, but looking for a good starter recipe with an IBU less than 35 in the color I was looking for took me 45 minutes since i was unable to limit my search to what I was looking for. Something like this may be a useful feature in these situations.
     
  2. Ozarks Mountain Brew

    Staff Member

    Joined:
    Nov 20, 2012
    Messages:
    7,468
    Likes Received:
    3,625
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    IT Managment
    Location:
    The Ozark Mountains of Missouri
    a page pagination would help searching on each category also as to not limit the search just a small amount of recipes
     
  3. Josh (Brewer's Friend)

    Josh (Brewer's Friend) Administrator
    Staff Member

    Joined:
    Nov 24, 2014
    Messages:
    183
    Likes Received:
    38
    Trophy Points:
    28
    Gender:
    Male
    Location:
    Saint Johns, FL
    Home Page:
    Thanks for the feedback. The search functionality could definitely use a little love and some more advanced options. Adding this to our feature tracker now. It's fairly straightforward to implement, so I'll plan to get to this soon. Thanks!
     

Share This Page

arrow_white