How to list all dataconnections which are saved in Spotfire library?
Article ID: KB0079187
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Supported Versions |
Description
All content which you save to Spotfire library is stored in a Spotfire database.You can find list of all "dataconnections" saved to Spotfire library by querying "LIB_ITEMS" joined with table "LIB_ITEM_TYPES" or via search expression in Library Administration Tool.
Issue/Introduction
How-to-list-all-dataconnections-which-are-saved-in-Spotfire-library?
Environment
All Supported Environments
Resolution
Solution#1: Run the following query on the Spotfire Database
---------------------------
select a.* from dbo.LIB_ITEMS a,dbo.LIB_ITEM_TYPES b where a.ITEM_TYPE=b.TYPE_ID and b.LABEL='dataconnection'
---------------------------
Note: The above query was tested on MSSQL Server Spotfire database.
Solution#2: Search for "type:dataconnection" in Spotfire Library Administration tool as mentioned in the attached screenshot.
---------------------------
select a.* from dbo.LIB_ITEMS a,dbo.LIB_ITEM_TYPES b where a.ITEM_TYPE=b.TYPE_ID and b.LABEL='dataconnection'
---------------------------
Note: The above query was tested on MSSQL Server Spotfire database.
Solution#2: Search for "type:dataconnection" in Spotfire Library Administration tool as mentioned in the attached screenshot.
Attachments
Feedback
Yes
No
Powered by
