Skip to Content

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 22, 2016 at 06:46 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.