Parameters in Layout If Statement Not Working

drudd

So I have a multi-select parameter that returns null when All is selected.

I am printing my parameters to my RTF layout.

I have tried:

<?if@notEmpty:{CERT_NAME_P}?><?CERT_NAME_P?><?else?>All<?end?>

<?if@inlist:{CERT_NAME_P}?><?CERT_NAME_P?><?else?>All<?end?>

I get an error like this most of the time

<Line 42, Column 72>: XML-22013: (Error) Error in expression: &#39;.//{CERT_NAME_P}&#39;.

The closest thing I've gotten to work is

<?if@section CERT_NAME_P?><?CERT_NAME_P?><?else?>All<?end?>

It returns All if All is provided which is good

When on item is selected it looks like this:

Selection1All

I would expect the All to go away but it's added to the end.

If I select two options it looks like this:

[Selection1,Selection2]All

Just adding for context

drudd

I finally got this working by using this :

<?If:CERT_NAME_P = ''?>All<?end if?> <?If:CERT_NAME_P != ''?><?CERT_NAME_P?><?end if?>

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/64090#Comment_64090

Very helpful information.

Thanks for sharing @User_9ZFXH!