Skip to Content
avatar image
Former Member

Warning message in Prompt selection

Hi,

We are working on a requirement, where we need to display a warning message in prompt screen when the value of End Date is less than the Start Date. Please let me know if this is possible in BO 4.1. Also any workaround solution is appreciated.

Thanks,

Karthik K

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 08, 2015 at 02:22 PM

    You can validate it after the prompt selection, as probably the query will return no data, when the report is to be rendered you can test for the condition.

    If the condition is met (Start Date > End Date), you use Javascript tp show thw popup and after it you force the refresh (take a look at).

    Create a filter variable {filter] = If ([Start Date] > [End Date];1;0)

    Drop a blank Cell on the report, create another variable , [script] = If ([filter] =1;

    "

    <script>

      alert("Start Date grreater than End Date");

      self.parent._askConfirmationBeforeClosingDoc=false;

      setInterval(function(){window.parent.parent.location.reload();},n*1000);

      </script>")

    Save the report, re-open it set the property of the blank cell "Read as" to HTML and assign [script] to the blank cell (drop it on the blank cell.

    Save the report again.

    If the user enters an Start date greater the End date, the report will show the mesage "No data retrieved for Query ", when the user closes this pop-up, the pop-up with the alert will be shown, closing it will force the documents refresh.

    Take a look at

    How to set a WEBI document to autorefresh each n seconds

    It will only work in the HTML client.

    Cheers,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 01:50 PM

    Hi Karthik ,

    It is not possible to validate conditions at prompt level .

    Add comment
    10|10000 characters needed characters exceeded