Custom dropdown value not in sequence

[Aamir Khan]

Hi

We have a custom dropdown with value 1 to 100. but its showing not in sequence order despite from the backend its already in sequence

Pls advise how this can be in sequence.

#ca_sdm_17.1
#caservicedesk17.0 

​​

[Arunava Saha]

I hope you used pdm_list functionality for this feature. I am also interested to know if there is any way to impose a order by clause while using pdm_list functionality in HTMPL.

Thanks
ArunavaS

------------------------------
[ServiceDesk Consultant]
[ADP Pvt Ltd]
[Pune] [India]
------------------------------

[Brian Mathato]

Hi Aamir,

What is the data type for your dropdown list displayed on the attached screen (string or integer)?

P.S. I also just spotted issue (probably some oversight) where the value '2' is duplicated. You might want to fix that ;-)

------------------------------
Kind Regards,
Brian
------------------------------

[Aamir Khan]

Hi brian

string data type i used. Earlier i used integer but for that the dropdown was showing ID against each value. 

[Aamir Khan]

Hi Brian

yes 2 is a duplicate over here n i have removed it.. But why it not in sequence? pls advise

[Lindsay Estabrooks]

If it is defined as string then it is being sorted correctly. Integer 11 is less that the integer 100 but string "100" is less than string "11".

------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------

[Aamir Khan]

Hi Lindsay

So in this case how can i put this in order? pls advise

[Lindsay Estabrooks]

The easiest way would be to make all the values 3 digits:
001
002
003
...
010
011
...

------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------