Skip to Content
0
Jul 22, 2016 at 04:45 AM

prompt is optional ,how to deal with empty value, BI 4.1

407 Views

HI,

I having trouble with handling prompt which I don't want to pass any value.

The reports have many prompts and most of them are optional.

In Java, I pass some values to the mandatory prompts and it works OK.

However, when I try to set blank to the optional prompts, it does not work well.

If the prompt is optional and value is null ,xml structure will not contain this param.

set param url: /biprws/raylight/v1/documents/{documentId}/parameters

If I set explicitly "" to the value, this "" seems to be treated [EMPTY_VALUE] and be included in WHERE clause of the generated SQL query to refresh the report.

That looks like WHERE COL1 IN ("").

This is not what I want it to be. I want it to disappear completely in the query.

thks.