Optional Parameter Prompts

[emir_abushala]

There are so many answers on the internet regarding this implementation, yet neither is 100% accurate.

So I am trying to create an optional parameter prompt, when nothing is inputted all results are displayed. When specifics are inputed, those results are supposed to be displayed.

I created 2 parameters, {param} and {paramA}

On my sql, I am calling for {paramA} which has default value expression -

($P{param} != null && $P{param}.trim().length() > 0) ? $P{param}: "New"

 

This method works, problem is, if you have more values than 'New', how do you implement that?

 

Thanks,

EA