Jump to content
We've recently updated our Privacy Statement, available here ×
  • RESTv2 - creating Input Control resource using XML format '<visibleColumns>' does not create visible columns


    vchiem
    • Features: Web Services Version: v6.4 Product: JasperReports® Server

    Issue:

    The TIBCO JasperReports® Server REST API Reference guide section "5.12 Input Control" provides an example notation of XML format resource descriptor for Input Control :

    [toc]
    <visibleColumns>
        <column>{column1}</column>
        <column>{column2}</column>
        <column>...</column>
    </visibleColumns>
    

    After creating the Input Control resource (section 6.4 Creating a Resource) the input control was successfully created with all the defined attributes except for the visible column/s.

    Both POST and PUT method were used but resulted in the same problem.


    Solution:

    The issue was reported as a defect (JS-33951). The workaround is to use JSON format as the content type.

    JSON Format example:

    This example creates a single-select query (type=4) Input Control resource named 'TestInputControlJSON' in the repository path '/public/Input_Controls'.It requires a pre-defined sql query resource 'JIUSERQuery' created under '/public/Queries'. In this example, the sql behind JIUserQuery is "select fullname from JIUSER;"

    Header: 
    Content-Type: application/repository.inputControl+json
    
    Body:
    {
        "label":          "TestInputControlJSON",
        "uri"  :          "/public/Input_Controls/TestInputControlJSON",
        "mandatory":      false,
        "readOnly":       false,
        "visible":        true,
        "type":           4,
        "valueColumn":    "fullname",
        "visibleColumns": ["fullname"],
        "query": {
            "queryReference": {
                "uri":    "/public/Queries/JIUSERQuery"
            }
        }
    }

     

    Related Article:

    JS-33951: RESTv2: creating Input Control resource using XML format <visibleColumns> does not create visible columns


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...