How to query Spotfire database to get the item names on which a particular analysis file depends on.
Article ID: KB0077286
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.5 and Higher |
Description
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.
Issue/Introduction
How to query Spotfire database to get the item names on which a particular analysis file depends on.
Environment
All Supported Operating Systems
Resolution
Run the following query or similar to it against the Spotfire database.
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.
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.
Additional Information
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.)
Feedback
Yes
No
Powered by
