Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 195 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Parameters in Layout If Statement Not Working

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: './/{CERT_NAME_P}'.
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
Best Answer
-
I finally got this working by using this :
<?If:CERT_NAME_P = ''?>All<?end if?> <?If:CERT_NAME_P != ''?><?CERT_NAME_P?><?end if?>
2
Answers
-
Very helpful information.
Thanks for sharing @User_9ZFXH!
1