Finance | Project Operations, Human Resources, ...

Query range in AOT for enums

(0) Share

Report

Posted on by junior AX

1,552

Hi,

I created an enum with multiple values where this enum is used in a table.

I created a query with this table and i put a range in the value property MyEnum::Value2 and i didn't get anything however when i put in the value property 2, i got the result correctly. Why is that?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi,

You can put "Value2" in the query range value and it should work as well. You need to mention the actual value and not the enum type

The MyEnum::Value2 probably has the "enum value" 2 which is why it worked for you.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi JuniorAX,

You can use enum value (2) or enum symbol (Value2, but not MyEnum::Value2). Using enum symbol is the recommended way for extensible enums.

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Gunjan,

yeah it has the same value. Which is better to put the value or the number?

but i once created a view and put a range on the field and filled the value property with <MyEnum::Finish and it worked, so what makes that different?

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Sergie,

Thanks but as i mentioned in my previous reply, is that i once created a view and put a range on the field and filled the value property with <MyEnum::Finish and it worked, so what makes that different?

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi, Junior_AX,

So you mean that MyEnum::Value2 didn't work, by MyEnum::Finish works?

Anyway, recommended way is to use the enum symbol (Finish), instead of the enum value. In case if you decide to re-number values in enum (it's rare case, but anyway it's possible) you don't need to fix ranges in queries. For extensible enums you will get BP warning about using enum symbol.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

Using the name is the common practice. For an example, in SalesTableListPage query, the range ReturnStatus has values provided with Enum names -

I have not tried putting the whole value of the Enum in a query. Could you share a screenshot of what you did in the view?

Was this reply helpful? Yes No