Not Sorting Order As Numeric in List Widget ExB Developer Edition

Question

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.

DanJiang · Answer

Glad to know that the issue is finally solved!.

Best,

Dan

HasanHöl · Answer

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.

DanJiang · Answer

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