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

[former_member231800]

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.

[eric_festinger · Accepted solution]

hello,

As you "don't want to pass any value", just: do not pass any value

You don't even need to give any answer at all! Only the parameter id. For example:

<parameters>

  <parameter>

    <id>6</id>

  </parameter>

  ...

</parameters>

Regards,

eric

[former_member231800 · Accepted solution]

thks very much.

i used to pass the <value></value> as the answer.