sort drop-down lists alphabetically

[Former Member]

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

[k_padilha · Accepted solution]

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

[Former Member · Accepted solution]

Dear Khayan,

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

Regards,

Martin

[AnkushPashine]

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

[Former Member]

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

[AnkushPashine]

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.