How do I sort existing option values alphabetically?

(0) Share

Report

Posted on by Maddin

Hello guys,

here is what I'm going to do:

I have a field "Type" and it has option as data type.

As option values I have " ,hybrid,OnPrem,Cloud".

Now the users are bothered by the fact that the values are not sorted alphabetically and want the values to be displayed in the selection:

" Cloud,hybrid,OnPrem".

However, I have many orders in which the field is already filled.

Now I need a procedure that allows me to change the option values.
If I simply change the order of the options as desired, the result is that the type that was previously "hybrid", for example, is now "Cloud".

The integer value has not changed as a result of the sorting.

How should I solve this?

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

Then you can try to use the integer value of the option you want to refer to.

The options are zero indexed. So the first option is 0 and so on.

Was this reply helpful? Yes No
Maddin 30 on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

That is also not working.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

And it is two single quotations marks that should be used - just to be clear on that.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

Try using ::'' instead to indicate an empty string

Was this reply helpful? Yes No
Maddin 30 on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

In that way it does not work:

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,664 Moderator on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

Use FORMAT function format(yourfieldname::value)

Was this reply helpful? Yes No
Maddin 30 on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

Hello folks,

I have now made a new field 2 next to my old field with the non-alphabetically sorted values, whose values are now sorted alphabetically.

With a report I now assign the value from the old field to the new field 2 (OnAfterGetRecord()).

When I run the report, it does not assign the correct value, but the integer value again.

What am I doing wrong?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,664 Moderator on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

Yes Zhu is right here, as also mentioned in my answer earlier please write your logic carefully while transferring the data to new field.

Thanks.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 91,851 Super User 2025 Season 2 on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

Hi, Do not assign directly.

Try the following:

if "Service Header"."Worktype" = "Service Header"."Worktype"::hybrid then

"Service Header"."Worktype 2":= "Service Header"."Worktype 2"::hybrid;

Because you have more types, you can use Case statements.

More details:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-al-control-statements#case-statements

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Maddin 30 on at

Like (0)

Report

RE: How do I sort existing option values alphabetically?

Unfortunately, my logic does not work as I had hoped.

I have now created a new field (ID: 50059) and transferred the value from the old field to the new field via a report.

But now I have a different value in the new field than in the old one (ID: 50053).

How do I have to adapt my logic?

"Service Header"."Worktype 2" := "Service Header"."Worktype";

Thank you

Was this reply helpful? Yes No