idea Filter Widget | Option to display order of predefined values in filter that have been set in particular order in SQL generator in ArcGIS Experience Builder Ideas

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

Christian_Sebaly — Thu, 01 Jun 2023 07:03:49 GMT

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.

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

RyanBohan — Wed, 06 Dec 2023 18:40:06 GMT

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.

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

BrittanyBurson — Fri, 05 Jan 2024 21:42:11 GMT

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

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

Damian — Fri, 29 Mar 2024 11:33:37 GMT

Same issue here. Please get this fixed.

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

JoseBarrios1 — Wed, 10 Jul 2024 17:51:50 GMT

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,

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

LStroupe — Wed, 10 Jul 2024 20:12:08 GMT

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

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

WillMcAllister7 — Wed, 24 Jul 2024 19:01:47 GMT

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

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

DarraghOSullivan — Fri, 02 Aug 2024 09:40:23 GMT

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

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

kmsmikrud — Tue, 20 Aug 2024 17:28:42 GMT

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

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

rmcooper_wcpss — Wed, 04 Dec 2024 19:36:46 GMT

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 manually sort them. Very frustrating to go through the process of carefully ordering your values only to have that ignored in the widget.

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

KevinN_CSJ — Tue, 29 Oct 2024 23:06:26 GMT

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

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

KevinN_CSJ — Tue, 29 Oct 2024 23:20:15 GMT

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

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

KateL — Tue, 03 Dec 2024 20:45:55 GMT

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).

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

SimonCrutchley — Fri, 10 Jan 2025 14:34:49 GMT

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

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

Christian_Sebaly — Wed, 29 Jan 2025 12:02:37 GMT

@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.

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

MelissaSullivan — Fri, 07 Feb 2025 18:37:10 GMT

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.

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

Markbe_utco — Tue, 18 Feb 2025 16:19:44 GMT

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.

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

RichlandGIS — Tue, 18 Feb 2025 21:12:26 GMT

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.

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

ryan_grammer — Thu, 17 Apr 2025 18:12:53 GMT

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

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

ZenMasterZeke — Mon, 12 May 2025 20:17:02 GMT

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