Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Library
Created by Guest
Created on Feb 6, 2016
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit SPF-I-149 Find dependencies within an analysis.

Search and export information related to analysis file like the folder path to the information links ,data sources ,column elements as a batch Merged

I want to be able to list all the Information links used by Analysis file.

The below query only doesn't help much
depends_on(type::query) and item_type:dxp

I want something similar to the data returned from the below query.
But as the DB format could change in the next release, I want to know some supported way to achieve the same

select

LI.ITEM_ID AS "ANALYSIS ITEM_ID", LI.TITLE AS "ANALYSIS TITLE",
LI.DESCRIPTION AS "ANALYSIS DESC", LI2.ITEM_ID AS "IL ITEM_ID",LI2.TITLE
AS "IL TITLE", LI2.DESCRIPTION AS "IL DESC"

from

LIB_ITEMS LI, LIB_RESOLVED_DEPEND LR, (select LI3.TITLE,
LI3.DESCRIPTION, LI3.ITEM_ID FROM LIB_ITEMS LI3 WHERE
ITEM_TYPE='783545a2-514f-4c90-acee-649e2df362f0') LI2

where

LI.ITEM_ID = LR.DEPENDENT_ID

and

LI2.ITEM_ID = LR.REQUIRED_ID

and

LI.ITEM_TYPE='4f83cd47-71b5-11dd-050e-00100a64217d'

{noformat}