fitering the data

Finance and Operations/AX Technical Forum
1

Hi all,

i have to filter the data in the form based on the value of enum.

For Example if my ENUM consist of three values A,B,C

in the form i need the filter all the records having the enum type A in the table .

Can some one suggest how to do it…

2

hi harish,

You should add an init method in your form datasource, where your want to filter, with the following code

this.query().dataSourceNo(1).addrange(fieldnum(your_table,your_field)).value(enum2str(your_enum::your_enum_value);

hope it helps,

regards,

Thomas

3

Thank you,its working