0 Replies Latest reply: Dec 6, 2017 7:40 AM by Jakub Holasek RSS

    Extensions usage in Repository DB - which tables?

    Jakub Holasek

      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!