2nd Filter Not Filtering | Skuid Support Community

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?

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1689461/RackMultipart20180105-118140-11zmlym-image_inlinepng1515187480

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1689461/RackMultipart20180105-118140-11zmlym-image_inlinepng1515187480

Audrey Lesui

94 Points
confused

Posted 1 year ago

1 year ago

Bill McCullough, Champion

12,888 Points

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

Comment

1 person likes this

2018-01-08T16:19:53+00:00

Audrey Lesui

94 Points

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)

2018-01-10T21:37:59+00:00

Bill McCullough, Champion

12,888 Points

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

2018-01-11T15:50:39+00:00

Audrey Lesui

94 Points

You're my hero Bill - This did exactly what I needed to do. Thanks so much!!