Jump to content
We've recently updated our Privacy Statement, available here ×
  • Facing 'Input Control Validation' error when trying access to a report (that contains NULL values in its Input Control) through Visualize.js


    Sarthak Chaudhary
    • Features: Input Controls Version: v7 Product: JasperReports® Server

    Problem: 

    When trying to access a report that contains input control with a NULL value with data type integer when being fetched through Visulaize.js. 


    Solution:

    If the report has a java.sql.Timestamp parameter; Since JasperReports Server v.7.2.0, Timestamp parameter value must be specified in format timestamp_1: ["2019-09-11T20:05:26"] while previously both formats were allowed timestamp_1: ["2019-09-11T20:05:26"] timestamp_1: ["2019-09-11 20:05:26"]

    As stated in the Visualize.js guide, in case an empty integer value should be passed as a parameter value, it should be specified as "~NULL~".

    Also, there are other special values: "" – An empty string, a valid value for text input, and some selectors. "~NOTHING~" – Indicates the lack of a selection.

    In multi-select parameters, this is equivalent to indicating that nothing is deselected, thus all are selected.

    In a single-select non-mandatory parameter, this corresponds to no selection (displayed as ---).

    In a single-select mandatory parameter, the lack of selection makes it revert to its default value.


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...