How to query Spotfire database to get the item names on which a particular analysis file depends on.

How to query Spotfire database to get the item names on which a particular analysis file depends on.

You may sometimes need to monitor the reports to see what all items (like Information Links, Data Connections) they are using. This article briefly describes how to create such view to import it into a Spotfire. The applicable item types are: query (=information link) folder, SBDF (= TIBCO Spotfire Binary Data Format file), dataconnection, connectiondatasource, datafunction, and colorscheme. Run the following query or similar to it against the Spotfire database.

select  x.DEPENDENT_ID, x.REQUIRED_ID, y.TITLE, z.DISPLAY_NAME from 
LIB_RESOLVED_DEPEND x join LIB_ITEMS y on x.REQUIRED_ID = y.ITEM_ID
join LIB_ITEM_TYPES z on z.TYPE_ID = y.ITEM_TYPE
where DEPENDENT_ID = 'e0e8b108-1fb3-49db-b9a7-8fab34f4afa7'

DEPENDENT_ID is the GUID of the analysis file.

The above query will produce a view as shown in the screenshot below.



REQUIRED_ID is the GUID of the item used in the analysis file.
TITLE is the name given to the item in Spotfire Library.
DISPLAY_NAME is the type name which states whether it is Information Link or Data Connection, etc.

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration.  It is not intended to be used "As Is" in a Production environment. Always test in a Development environment. The key tables used in this particular query are:

• LIB_ITEMS - A row for each object in the library
• LIB_RESOLVED_DEPEND - Each object's dependencies on other objects
• LIB_ITEM_TYPES - A translation of the ITEM_TYPE GUID to an English version (Data Connection, Information Link etc.)