topic Re: NPrinting Repository Database Report Table in Qlik NPrinting

NPrinting Repository Database Report Table

TheLazyDevelopr — Fri, 08 Dec 2023 16:40:00 GMT

In the NPrinting Repository Database, I am trying to find where I associate which data connections a NPrinting report is utilizing.

The entities_xml field looks to have the data connection inside but it is not for all my reports.

Wondering if it is in another table besides report,task,data conneciton.

Re: NPrinting Repository Database Report Table

Lech_Miszkiewicz — Sat, 09 Dec 2023 01:45:16 GMT

Hi,

the field you are pointing to ("entities_xml") is definitelly the correct one for objects used in template based reports. In single report you may have 1 or many connections so connection is not really part of the report structure, but object used within the template.

Then you also can have entity reports which dont have templates and they need to be looked at separately:

EntityReports: LOAD upper(id) as ReportID, upper(qlik_view_entity_id) as qlik_view_entity_id; SELECT "id", "report_type_id", "qlik_view_entity_id" FROM "public"."report" where "report_type_id"='QlikEntity'; left join (EntityReports) LOAD upper(id) as qlik_view_entity_id, upper(data_connection_id) as [EntityReportConnectionID]; SELECT "id", "data_connection_id" FROM "public"."qlik_view_entity";

the whole thing is already worked out in NPrinting GovernanceDashboard app so just have a look there:

https://community.qlik.com/t5/Official-Support-Articles/Qlik-NPrinting-Governance-Dashboard-Version-3-Now-Available/ta-p/1744538

cheers

Re: NPrinting Repository Database Report Table

David_Friend — Mon, 11 Dec 2023 15:42:56 GMT

@TheLazyDevelopr yeah just use the Np Governance Dashboard (like Lech mentioned)

Re: NPrinting Repository Database Report Table

TheLazyDevelopr — Tue, 12 Dec 2023 16:13:00 GMT

Thank you! I was originally pulling the scripts from our NP Gov app but realized it was modified by a prior dev on our team which resulted in the connections being incorrect. Uploaded the latest version of the NP Governance dashboard and its providing me with the information I need.