2nd Filter Not Filtering

  • 1
  • Question
  • Updated 10 months ago
  • In Progress
I added a table to my page - it requires 2 filters.  The first one (Service Type) works just fine.  I followed the exact same steps to create the second (Status) but it just looks like a text field.  The Status field is indeed a picklist - it's an added field to the model - the conditions for both were automatically created - what am I missing?

Photo of Audrey Lesui

Audrey Lesui

  • 94 Points 75 badge 2x thumb
  • confused

Posted 10 months ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Audrey,

How many pick list options are there for Status?  I am not sure of the number, but I think after 25 options the 'auto-filter' will switch to a type ahead control instead of the pick list.

Have you tried using the filter?  Does it work?

Thanks,

Bill
Photo of Audrey Lesui

Audrey Lesui

  • 94 Points 75 badge 2x thumb
Totally makes sense - there are about 40 options to choose from.  And no - it doesnt work, when I type in the option I want to filter - it doesn't work.  I will need to research how to limit the Skuid filter to show only the options that in my Skuid table.  Thanks again for clearing that up for me Bill!
(Edited)
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Audrey,

I just posted a sample page that shows how to use an Aggregate model to drive the pick list options for a filter.  I think this will get you what you want.

Link

Thanks,

Bill
Photo of Audrey Lesui

Audrey Lesui

  • 94 Points 75 badge 2x thumb
You're my hero Bill - This did exactly what I needed to do. Thanks so much!!