topic Re: Not Sorting Order As Numeric in List Widget ExB Developer Edition in ArcGIS Experience Builder Questions

Not Sorting Order As Numeric in List Widget ExB Developer Edition

HasanHöl — Mon, 23 May 2022 14:13:44 GMT

Hi Everyone,
I am using Experience Builder 1.8 Developer Edition and ArcGIS Enterprise 10.6.1.

In List Widget, I want to sort with ascending numeric but list widget is not working ascending numeric order as you see in the first screenshot.

What am I doing wrong? or is there a bug about sorting in List Widget?

Thank you in advance.

Re: Not Sorting Order As Numeric in List Widget ExB Developer Edition

ShengdiZhang — Tue, 24 May 2022 03:30:03 GMT

Hi @HasanHöl

I am unable to reproduce your problem using the data view or the list sorting tool. Can you help to check if sorting on other non-numeric fields of this data or numeric fields of other data does not work as well?

Regards,

Shengdi

Re: Not Sorting Order As Numeric in List Widget ExB Developer Edition

HasanHöl — Tue, 24 May 2022 13:08:47 GMT

Hi @ShengdiZhang
Thank you for response.
I also checked sorting non-numeric fields as bus stop name field for the list widget. You can see the list sorting randomly for second character in the screenshot. I do not understand why this is happenning.

Is there any problems about relation between Portal for ArcGIS version and ArcGIS Experience Builder version? or configuration of Portal? I do not understand.

Regards,

Hasan Höl

Re: Not Sorting Order As Numeric in List Widget ExB Developer Edition

DavidColey — Tue, 24 May 2022 15:54:25 GMT

I have found that I get more consistent sort results when I create a view and apply the default sort on objectID. This works well if I am only using one attribute field as a sort option. The sort becomes inconsistent if I try to then add more than one attribute as a sort option.

Re: Not Sorting Order As Numeric in List Widget ExB Developer Edition

DanJiang — Fri, 27 May 2022 09:04:00 GMT

Hi @HasanHöl ,

We did a quick test with some sample data and cannot reproduce the issue. From your description, my best guess would be that the service you are using may not support sorting. Could you please check the data service from your side? You can open the query html of your service and fill the highlighted inputs (see the attached screenshot as an example), then click "Query(GET)" button at the bottom to check whether the returned features are in the correct order. Hope this info can help.

Best,

Dan

Re: Not Sorting Order As Numeric in List Widget ExB Developer Edition

HasanHöl — Wed, 01 Jun 2022 08:34:48 GMT

Hi @DanJiang

I tested the sorting problem and tried to figure out it. I don't still understand.

However, after your suggestion, I figured out that the best and simple solution is to create a new geodatabase in PostgreSQL, republish my map and configured web map in the Portal. Previously the spatial data was in Oracle database. I have no idea about any relation between two databases.

Now, I can sort the fields as I want.

Thank you for your response and help.

Best regards,

Hasan.

Re: Not Sorting Order As Numeric in List Widget ExB Developer Edition

DanJiang — Fri, 10 Jun 2022 09:14:57 GMT

Glad to know that the issue is finally solved!.

Best,

Dan