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}
What database do you use for your Spotfire Metadata schema?