I'm writing an expression for an inline list source filter and getting exceptions when trying to use nested conditions, which is possible in SQL.
For example, I would write...
AE=FP(AccountingEntityID) AND (D1=FV(vA1) OR D1=ALL) AND (D2=FV(vA2) OR D2=ALL)...
However I get a syntax error on ), so the expression is not parsing correctly to SQL.
Based on docs.infor.com/.../led1505201037998.html I tried using an IN clause. However, both of the following throw an illegal expression exception.
AE=FP(AccountingEntityID) AND D1 IN (FV(vA1);ALL) AND D2 IN (FV(vA2);ALL)...
AE=FP(AccountingEntityID) AND "D1":("FV(vA1)";"ALL") AND "D2":("FV(vA2)";"ALL")...
How can we either nest conditions or use IN statements in an inline filter expression?
