D365FO ER filter issue on Boolean field

(1) Share

Report

Posted on by Ismail Tunca

Hi all,

I am trying to modify SAF-T Electronic report model mapping. We have a Boolean field on InventTable and I want to filter $Products with that.

Filter works with string fields , enum fields, numeric fields but unfortunately it gives error /Validation error: Invalid condition expression./ for the formula below.

FILTER(@.InventTable,@.InventTable.ARBReleased = true)

It accepted same condition with Where but it gave error on $Product_Join

WHERE(@.InventTable,@.InventTable.ARBReleased = true)

I tried creating Enum and using like FILTER(@.InventTable,@.InventTable.ARBReleased = ARBReleased.true) no luck.

I tried NoYes Enum , Numeric 1 value as well, no luck.

Unfortunately I can not change the field type now.

What should be the format for boolean filter?

Any help is greatly appreciated.

Thanks,

Ismail

All responses (1)

Answers (0)

Suggested answer

Arcadi 788 on at

Like (0)

Report

D365FO ER filter issue on Boolean field

You shouldn't create your own enum, instead declare the D365 enum that's being used by this field... it's not NoYes, could be NoYesBlank or any other so you should check the field in the table using Visual Studio.