Filter Widget | Option to display order of predefined values in filter that have been set in particular order in SQL generator

[Christian_Sebaly]

The Filter widget only displays values in alphabetical / alphanumerical order. When i add predefined values (using the SQL Generator) i can add values in a particular order but the filter widget does not keep those values in the specified order. It would be very helpful if the Filter widget could be enhanced to keep the order of values in the filter according to the arrangement i set in the generator.

[RyanBohan]

If you manually enter predefine values, Exb gives you a nice option to order them any way you want.

Unfortunately, that order is ignored, when the app is published.

[BrittanyBurson]

Posting my use case. Need to order based on Pavement Condition Index order, not alphabetical. I wish the defined value order would stick.

[Damian]

Same issue here. Please get this fixed.

[JoseBarrios1]

I encountered the same problem! The ability to rearrange values in the settings while the action remains ignored seems more like a bug than a functional limitation. I look forward to the great Ex. B. team addressing this issue.

Thanks,

JB

[LStroupe]

Same issue here. We've only found a couple ways to get around it so far:

  

[WillMcAllister7]

Adding my name to the list! I have the same use case as Brittany, ordering pavement condition where alphabetical order does not make sense. 

[DarraghOSullivan]

Yes, same here. Need to order by text values that are not in alphabetical order. E.g. Poor, Average, Good

[kmsmikrud]

I last posted on this same filter unique value sorting 2 years ago which is after months of trying to use Experience Builder. After running into numerous issues, I had to switch to embedded dashboards in EB. Somehow dashboards are so amazingly reliable and have basic functions one would think the 'latest and greatest/modern' technology would have like being able to sort values in a filter without manually having to define them.

I landed back on this topic today in setting up a filter for text field that has dates.  I was reminded when seeing the list of values showing in the filter drop-down of the issue and its still there :(.  

Please enhance/add this functionality it seems so basic.

Thanks,

Kathy

[rmcooper_wcpss]

Being able to provide a custom sort of predefined filter values is a must have. The interface for configuring the list suggests that it will honor the order of the predefined values by letting you to manually sort them. Very frustrating to go through the process of carefully ordering your values only to have that ignored in the widget.

[KevinN_CSJ]

Frustrating that this has been a suggestion for a year and a half and there are no replies from any ESRI staff. Today I am working on an experience for our environmental services department to display results from a survey their inspectors fill out. We even set it up to use a coded value so that they were in order, but the widget automatically sorts them by the label instead of the coded value or the arranged order in the SQL Builder. Please anyone at ESRI acknowledge that this is an oversight and fix this!

Currently configuring to use the same workaround as @LStroupe above, but that is not ideal when it should be native configurable.

Version used: Experience Builder, Portal, Enterprise 11.3