Skip to Content

sort drop-down lists alphabetically

Dear all,

this seems like a question too simple to ask, but I am still struggling:
how do I sort the values in a dropdown-list in C4C alphabetically?

Any hint would be appreciated.

Regards,

Martin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 18 at 08:36 PM

    Hi Martin,

    For extension field type drop-down list, the backend system actually understand just the value in the column code. The description is just presented in the frontend.

    It could works in case you are using one single language, but when using more than one language for description it probably will not match the same alphabetic position.

    As we do not have a configuration for description sequence in runtime for this kind of field, it will not be possible.

    Let us know in case any other question.

    Thanks and Regards,

    Khayan Padilha

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Khayan,

      I was afraid that would be the answer. But it makes sense. So thank you for your help!

      Regards,

      Martin

  • May 16 at 02:16 PM

    Hello Martin,

    Can you please clarify, which screen you referring (appreciate if can attach screenshot).

    In General you can sort in Ascending or Desending order (for e.g. Sales Quote view ->select column Description) .

    =>If you sort Description in Ascending order (it sort A-Z) ,whereas if you sort Descending Order(it sort Z-A ) sequence. .

    If this help, do set post as answered else kindly provide more details on your query .

    Best Regards,

    Ankush Pashine.

    Add comment
    10|10000 characters needed characters exceeded

  • May 17 at 10:36 AM

    Hello Martin,

    Just to add to my previous note .

    1.In general for certain drop-down it will be bydefaulted in aplhabetical order.
    2.However for certain drop-down you can maintain the sequence base on Business
    Configuration .

    For e.g. In case of Ticket - Status , drop-down order sequence can be set as
    follow.

    Go to Business Configuration->Fine Tune activity->Open Activity 'Tickets for
    Employee Support '->Maintain Status Schema .

    =>Here you can see there is column as "Sort Sequence" , where you can decide
    on sequence .

    Hope this helps.

    Thanks and Regards,
    Ankush Pashine

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Ankush,

      thank you for getting back to me.
      What about a drop-down list in an extension field we created? If I change the three-digit code to get the values in the right order, existing entries in the database will probably be messed up.

      Is there any other way?

      Regards,
      Martin