Product: TIBCO Spotfire®
How to fetch Creation Date, Modified Date, Last accessed Date details for all analysis files in the TIBCO Spotfire library
You can find the list of all TIBCO Spotfire analysis files and details from the table "LIB_ITEMS" in the TIBCO Spotfire Server application database. To retrieve Creation Date, Modified Date, and Last Accessed Date details for all analysis files in a Spotfire library, the query mentioned in the "Resolution" below can be used. Here is an example query that can be run on the TIBCO Spotfire Server application database:
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')Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration. It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.