SETFILTER on an Option Field

Dynamics 365 Business Central/NAV Developers Forum
1

Hye people… I need some help. I want to apply a filter on an Option Field. But this filter will be a composed filter from a Text. I want to do something like this: Table1.SETFILTER(Table1.OptionField,’%1’,AnotherTable.FilterToApply); FiltertoApply is a Text field and the values of this field will be something like ‘1|2’ or ‘1|4|6’ When I try compile it returns an error that Type conversion is not posible Option:=Text Do you have any amazing idea to resolve this? Thanks

2

Have you tried removing the %1? Table1.SETFILTER(Table1.OptionField,AnotherTable.FilterToApply);

3

Nelson’s ideas are always that amazing [;)]