I would like to ask how to use XML tags to achieve this effect in the report type, because XML tags do not seem to support the combination of multiple conditions, because I do not want all these parameters to be null;
Or are there other good ways and suggestions?
thanks
gerd
<if> <exp1>#Parameter1#</exp1> <op>is null</op> AND
<exp2>#Parameter2#</exp2> <op>is null</op> AND
<exp3>#Parameter3#</exp3> <op>is null</op> AND
<exp4>#Parameter4#</exp4> <op>is null</op> AND
<exp5>#Parameter5#</exp5> <op>is null</op>
<text> and 1=2 </text> <elsetext> and 1=1 </elsetext>
</if>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I would like to ask how to use XML tags to achieve this effect in the report type, because XML tags do not seem to support the combination of multiple conditions, because I do not want all these parameters to be null;
Or are there other good ways and suggestions?
thanks
gerd
<if> <exp1>#Parameter1#</exp1> <op>is null</op> AND
<exp2>#Parameter2#</exp2> <op>is null</op> AND
<exp3>#Parameter3#</exp3> <op>is null</op> AND
<exp4>#Parameter4#</exp4> <op>is null</op> AND
<exp5>#Parameter5#</exp5> <op>is null</op>
<text> and 1=2 </text> <elsetext> and 1=1 </elsetext>
</if>
XML tags don't have options for AND/OR etc. Probably you can use the groovy option and construct your sql as required.