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.

[KevinN_CSJ]

Maybe @AlixVezina or @Jianxia can help? (Found your names from a UC ExB presentation)

[KateL]

As others have stated, needing a specific order of filter values comes up often and should be basic functionality. It's frustrating this hasn't been implemented yet. Here's one simple example, we'd like to have values appear by grade order (Kindergarten, Elementary, Middle School, High School), but of course they appear in the published tool alphabetically (Elementary, High School, Kindergarden, Middle School). 

[SimonCrutchley]

Hi there,

I've been advised to add my user case as further support for what surely ought to be a basic requirement.

I am an archaeologist dealing with periods of time which need to be ordered sequentially, but even when I make my selection NEOLITHIC, BRONZE AGE, IRON AGE, ROMAN etc I still get BRONZE AGE, IRON AGE, NEOLITHIC, ROMAN, which is really confusing to users! I could try the work around, but there are at least 20 time periods.

Cheers

[Christian_Sebaly]

@Jianxiais there any chance that the development team will work on this subject? Would be great if the SQL generator in ExB could get an update.

[MelissaSullivan]

Still having this issue. Will probably use the above workaround too, but would be nice to have these sort as intended so that they are intuitive to the end user.

[Markbe_utco]

Bump, topic.

While I don't have a need for a custom sort order using a text field I would like a reverse alphabetical/numeric order since I'm filtering on dates with over 100 years.  Having to scroll through a hundred values to get the most recent year is frustrating.

[RichlandGIS]

Since still no progress on this that has been a known issue since at least 2/2022, figured I'd post to it again 'remind' ESRI that this is still 'broken'.

Get lots of people asking me to re-order the list so that "Good" comes before "Fair" and "Poor".

Bit embarrassing being the GIS guy and having to tell my customers they just have to live with the confusion.

R_

[ryan_grammer]

Hello all, this has already been logged as ENH-000150684: "In the ArcGIS Experience Builder Filter widget, provide the ability to keep the order of the predefined values."

Please reach out to Esri Technical Support and open a case to have your account added to this enhancement request. The support ticket request can be submitted as, "I am running into a known limitation when trying to change the display order of predefined values in the Filter widget (ArcGIS Experience Builder). There is an enhancement for this issue, ENH-000150684, and I would like to be added to it."

Thank you,

Ryan Grammer | ArcGIS Enterprise Support Analyst

[ZenMasterZeke]

Not a fix, but you could order them as 1 - Good, 2 - Fair, 3 - Poor as a workaround

[Ke_Xu]

Hi All,

It has been enhanced on ArcGIS Online in June 2025 and will be enhanced on ArcGIS Enterprise 12.0.

When you're using predefined unique values, the filter preserves the order set in the configuration, and that same order is displayed at run time.

Thanks,

Ke