Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
How to fetch Creation Date, Modified Date, Last accessed Date details for all visualizations in Spotfire library
Solution:
You can find the list of all Spotfire library visualizations details from the table "LIB_ITEMS" in the Spotfire database. To retrieve Creation Date, Modified Date, and Last Accessed Date details for all visualizations in a Spotfire library, the query mentioned in the "Resolution" below is to be used.
Resolution.
Query:
SELECT TITLE, ITEM_ID, PARENT_ID, CREATED,MODIFIED,ACCESSED
FROM LIB_ITEMS
WHERE ITEM_TYPE IN (
SELECT TYPE_ID
FROM LIB_ITEM_TYPES
WHERE FILE_SUFFIX='dxp');
Comments
0 comments
Article is closed for comments.