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

Nitin Verma 21,708 Moderator on at

Like (1)

Report

Hi,

the solution I see as per below

create one more new field as you want with type option and transfer all the data from the old field to new field and of course you need to write a logic in that way the result you want.

after that you can delete the old field

not sure if it’s ok for you

Thanks

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi, If the user just wants to sort on selection. You can hide this field on the page.
Create a new Option field, for example, B field " ,Cloud,hybrid,OnPrem".

When B validates, A also assigns the corresponding value.

For example,

if B = B::Cloud then

A := A::Cloud

........

In this way, only one page needs to be modified.

Hope this helps as well.

Thanks

ZHU

Was this reply helpful? Yes No
Maddin 30 on at

Like (0)

Report

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
Suggested answer

YUN ZHU 95,679 Super User 2025 Season 2 on at

Like (0)

Report

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
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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
Maddin 30 on at

Like (0)

Report

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,708 Moderator on at

Like (0)

Report

Use FORMAT function format(yourfieldname::value)

Was this reply helpful? Yes No
Maddin 30 on at

Like (0)

Report

In that way it does not work:

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No