nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sort order in Filter Widget

rzufelt

Is there a way to change the sort order in the filter widget, especially to Natural Sort?

I have set up an expression using the unique values option. Nice as it gives me the list of values to filter on, but they are sorted alphabetically, and I need a natural sort option.

Really confusing the the user when things are way farther down the list than expecting.

W1 and W2 should come before 10, and so on.

Looks like this	Want to look like this
W10-1	W1-1
W11-1	W2-4
W1-1	W10-1
W2-4	W11-1

Find more posts tagged with

Accepted answers

All comments

ryan_grammer

Hello all, this has 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,

RyanBohan

Please consider upvoting the Idea to add this functionality to Experience Builder. Filter Widget | Option to display order of predefi... - Esri Community

BrittanyBurson

Super unfortunate this is a thing. We need control over the sorting order, can't just be alphabetical.

LAG155

Hello, the same thing is happening to me with the months of the year.
I tried using the default values however the widget sorts it automatically without respecting the order of the given list.

PLEASE TAKE INTO ACCOUNT THE IMPROVEMENT

orderbyfilterEB.jpg

kmsmikrud

Hello,

I was trying to migrate a dashboard to EB for the sole reason of the filter option being able to have more flexibility in the statements. I need a filter that will select values from within a list so it was suggested to use EB.

Similar to other posts here, I am finding the sort options not great. For instance, I would like to be able to filter the data by year and so I'm using all unique values. However I would like it to open with the most recent year as the default value. I tried creating a view with year values sorted descending but the filter still shows the years ascending. I also don't see an option to have the last year be the default. Is this possible?

The frustrating thing is the dashboard selectors allow default values with first and last and apparently more functionality than the filter widget EB. However the dashboard selectors only have equal/does not equal for options hence the reason I'm trying to now use EB. Now I'm struggling with sort and default values in the EB filter. Hopefully I'm just overlooking settings.

Thanks!,

Kathy

Erwinvan_Veen1

Is there perhaps any update on this question @TonghuiMing? I am looking at the same thing as the others described. I would be great if the configured order is honored.

Attached I have a sample. Although in Dutch, I presume the intended order is pretty clear.

Any update would be much appreciated.

Sample filter with desired order.png

Sample filter with configured order.png

TanGnar

I'm running into these issues as well, but using Predefined Unique Values. I need to be able to sort the predefined values filter smallest to largest, but keep different nomenclature. See below. I can drag the predefined values to my desired order, but it does not affect the way the filter is sorting in the app. It seems that it defaults the sorting based on the Label. As a workaround, I can change the labels to get an order I need, but it's not very clean and it would be easier if the order I specify when I'm defining the values was used in the app.

TonghuiMing

Okay, let me try creating some data similar tomorrow and give it a try first. Thanks for the info.

rzufelt

@TonghuiMing There is a domain on the field, and my filter query looks like:

So it only pulls values that are currently populated in the data.

The drop down list I get when I edit/add a feature shows the entire domain list and is sorted by the order of the domain table (so, no sort).

It appears as if the filter widget is still sorting like the previous version:

I tried to add you to my ESRI support group, but couldn't find @TonghuiMing.

Thanks,

TonghuiMing

Hi @RhettZufelt - we have done some enhancements for the sorting for the release yesterday. Could you please check again and see if the natural sort works for you now? I do not know your data type/structure - are these coded values or not?

It would be nice if you could share with me the data for a quick test as well, if possible.

rzufelt

Thanks @TonghuiMing, however, I really can't be changing values of a standard in order to work around the sort issues.

Any chance future versions we can have full access to SQL in the Filter Widget instead of the limited set available in the drop downs? Natural sort on this kind of data is not too difficult with SQL if we have the tools available.

Also, am I just missing it, or is there not an option to decide sort field/order in the Filter Widget other than the default sort on the Filter field?

If there were a way to sort on field of choice, I could use SQL to populate/maintain a separate column for sorting as a workaround.

TonghuiMing

@RhettZufelt - after investigation, here are some complications to your case -

If the values are just labels, then there could be a way to sort them naturally, such as the following case:

However, it is values that are being used for Filter > SQL in your case, thus, it may be the current designed behavior - since it says string field value by the starting 'W', it could not use the numeric logics, which will honor the natural sort order.

A workaround might be, to use 01 to distinguish 10+ numbers. Hope it could help.

rzufelt

Thank you @TonghuiMing, I look forward to the next update.

TonghuiMing

@RhettZufelt It appears to be the current sorting mechanism and we will take a look at it to see if it can be enhanced. Thanks for bringing it up.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.