Clarity Service Management

Expand all | Collapse all

Custom dropdown value not in sequence

Jump to Best Answer
  • 1.  Custom dropdown value not in sequence

    Posted 08-05-2019 02:30 AM
    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 





    ​​


  • 2.  RE: Custom dropdown value not in sequence

    Posted 08-05-2019 06:03 AM
    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]
    ------------------------------



  • 3.  RE: Custom dropdown value not in sequence

    Posted 08-05-2019 09:00 AM
    Edited by Brian Mathato 08-05-2019 09:01 AM
    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
    ------------------------------



  • 4.  RE: Custom dropdown value not in sequence

    Posted 08-05-2019 09:20 AM
    Hi brian

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






  • 5.  RE: Custom dropdown value not in sequence

    Posted 08-06-2019 04:52 AM
    Hi Brian

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


  • 6.  RE: Custom dropdown value not in sequence
    Best Answer

    Posted 08-06-2019 09:52 AM
    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
    ------------------------------



  • 7.  RE: Custom dropdown value not in sequence

    Posted 08-19-2019 06:40 AM
    Hi Lindsay

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


  • 8.  RE: Custom dropdown value not in sequence

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

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