Where clause translation to new jasperQL language V7.8 in Products Posted February 12, 2021 Hi ninjas,I'm getting some trouble trying to translate the following statement:WHERE tt_actor.IS_NEW = 1 AND ( ($P{cat} = $P{bank} AND tt_actor.TYPE = $P{pNumber}) OR ($P{cat} = ${customer} AND tt_actor.TYPE_CLASS = $P{pNumber}))I don't know yet the new JSON syntax. Thanks in advance for your help
Where clause translation to new jasperQL language V7.8
in Products
Posted
Hi ninjas,
I'm getting some trouble trying to translate the following statement:
WHERE tt_actor.IS_NEW = 1 AND ( ($P{cat} = $P{bank} AND tt_actor.TYPE = $P{pNumber}) OR ($P{cat} = ${customer} AND tt_actor.TYPE_CLASS = $P{pNumber}))
I don't know yet the new JSON syntax. Thanks in advance for your help