Extensions usage in Repository DB - which tables?

analienx — Mon, 27 Nov 2017 13:02:18 GMT

Hello Experts,

how can one find relation between application/sheets which use specific Extension? I tried to dig in AppObjects table yet it seems the only available object types are following:

'measure','hiddenbookmark','snapshot','masterobject','sheet','dimension','story','listbox','LoadModel','bookmark','GenericVariableEntry','app_appscript','embeddedsnapshot','appprops'

I also tried to investigate AppContents,AppObjects,AppInternals tables yet no success.

We tried following path: Apps (App_ID) -> AppContents (AppContentID) -> AppContentStaticContentReferences(StaticContentReference_ID) -> ExtensionStaticContentReferences (Extensions_ID) -> Extensions

Yet when performing following query no results where shown :

SELECT "AppContent_ID"

FROM public."StaticContentReferenceAppContents"

where "StaticContentReference_ID" in (

SELECT "StaticContentReference_ID"

FROM public."ExtensionStaticContentReferences"

where "Extension_ID" in (

SELECT "ID" FROM public."Extensions"

where "Name"= 'anychart-qlik'

)

There must be a way how to find the relation because there is a Sense-Extension-Governance extension that can retrieve it (yet it does not work on the platform).

Thanks!

Re: Extensions usage in Repository DB - which tables?

Anonymous — Sun, 02 Sep 2018 08:28:39 GMT

Hi Jakub,

Facing the same challenge, did you ever find a solution ?

Thanks

Eric

Re: Extensions usage in Repository DB - which tables?

ErikWetterberg — Sun, 02 Sep 2018 12:57:29 GMT

‌Hi,

you can’t find that information in the repository DB, you need to use the QIX engine API to fetch object properties.

Erik Wetterberg

https://extendingqlik.upper88.com/

topic Re: Extensions usage in Repository DB - which tables? in Management & Governance

Extensions usage in Repository DB - which tables?

Re: Extensions usage in Repository DB - which tables?

Re: Extensions usage in Repository DB - which tables?