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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Arcadi 794 on at

Like (0)

Report

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.

Was this reply helpful? Yes No