Create Table Using Plain JSON

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Hi there,

Im new using JasperReports, and Im trying to create a Table entity from a JSON like this: 

[
    {
        "id": 770,
        "reference_code": "R00075",
        "name": "PAREJA DE ÁNGELES PORTANDO SENDOS RELOJES",
        "long_name": "",
        "bar_code": "",
        "qr_code": "",
        "id_author": null,
        "serial_number": "",
        "classification_code": "122200",
        "author_name": "",
        "author_born_place": "",
        "year": null,
        "equipment_type": "Obras de arte",
        "level_name": "",
        "id_level": null,
        "id_status_artwork": null,
        "status_arkwork_name": "",
        "id_entity": 146,
        "point": {
            "geometry": {
                "type": "Point",
                "coordinates": []
            }
        },
        "lot": false,
        "current_headquarter_center_polygon": {
            "geometry": {
                "type": "Point",
                "coordinates": [
                    -3.69112761317592231,
                    40.4213306754636506
                ]
            }
        },
        "equipment_subtype": "",
        "currency_name": "",
        "subclassification_code": "",
        "id_type": null,
        "art_type_name": "",
        "id_subtype": 670,
        "art_subtype_name": "RELOJES",
        "parent_name": "COL/RELOJES",
        "parent_code": "",
        "id_collection": 1,
        "sub_number_sap": null,
        "id_equipment_status": 108,
        "id_fixed_asset_sap": "122100001083",
        "collection_name": "BBVA España",
        "item_name": "",
        "equipment_status": "Activado",
        "change_status": "",
        "author_level": null,
        "author_level_name": "",
        "author_born_year": null,
        "is_retain": false,
        "author_death_year": null,
        "author_death_place": "",
        "web_link": "",
        "is_bic": false,
        "id_trained_in": null,
        "trained_in_name": ""
    }

]

I create the DataSet and the DataConnection as Jsonql, and im able to see the data on the dialog, but not when I generate the report

More over, the report detect the number of registers on my JSON. What could I do? I need this data to display on table so I can use DynamicJasper to hide columns based on conditions.

 

Thank in advance

Attachments: 
mmolinasa's picture
Joined: Oct 18 2021 - 2:23am
Last seen: 4 months 2 weeks ago

0 Answers:

No answers yet
Feedback
randomness