Product: TIBCO Spotfire®
How to fetch Creation Date, Modified Date, Last accessed Date details for all visualizations in Spotfire library
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.
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');