General

Re: Change sort order of dropdown with REST WEB SERVICE

donstephen — Mon, 14 Sep 2015 07:43:31 GMT

Hi Rommel,

This is a bit weird and I am also baffled by the outcome of the query. Could you check by displaying the data connections repeating table and see how many items are returned for both url strings (with and without the ordeby query) and post your results here?

Regards,

Re: Change sort order of dropdown with REST WEB SERVICE

Rommel Sta. Juana — Tue, 08 Sep 2015 02:17:09 GMT

Hi Good day. I do have some concern using order by. I have a REST URL as below

https://servername/_vti_bin/ListData.svc/ListName?$select=Function,RegionGroup&$orderby=RegionGroup

When I preview the form in browser, the Region Group value will be sorted ascending but only the first three value would be return in the dropdown. But when I remove the orderby in the query, the dropdown will display all available value but it is not sorted.

Can you please advice.

Regards,

Rommel

Re: Change sort order of dropdown with REST WEB SERVICE

donstephen — Thu, 12 Dec 2013 12:27:54 GMT

Hi,

Your REST Web Service URL should have a pattern similar to this:

Hope this helps.

Change sort order of dropdown with REST WEB SERVICE

d24n4e — Thu, 12 Dec 2013 10:59:58 GMT

Please can anyone tell me how to pull my rest web service data through in alphabetical order, rather than in ID number order?

We regularly add data to the lookup source data and I need this to always come through on the dropdown list in alphabetical order as there is circa 350 items on there.

Thank you