Where are bookmarks stored?

Where are bookmarks stored?

book

Article ID: KB0081554

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

There is an internal bookmark service which runs within the client applications, in both the installed client and the Web Player, that regularly syncs the bookmarks to the database via the TIBCO Spotfire Server. A local version of bookmarks are maintained within the local dxp session (for use offline, and during periods of connectivity issues with the Spotfire Server) and when a new bookmark is created it is maintained in that local session until the next bookmark synchronization occurs.

Bookmarks are permanently stored in the TIBCO Spotfire application database in the LIB_ITEMS table, which includes the unique bookmark ID and a CONTENT_SIZE column. The LIB_DATA tables contain the actual data for each bookmark (where LIB_ITEMS.ITEM_ID = LIB_DATA.ITEM_ID). The LIB_PROPERTIES table contains properties about the bookmarks (where LIB_ITEMS.ITEM_ID = LIB_PROPERTIES.ITEM_ID) like PROPERTY_NAME "Visibility" which will be either "Public" or "Private".

You can find them with the following queries:

 - To list all bookmarks from LIB_ITEMS (Reference: You can find the IDs of all library item types in the LIB_ITEM_TYPES data table).
select * from LIB_ITEMS where ITEM_TYPE='debd56cd-50bb-47b0-a458-84a2fccf3ca0'
 - To list the actual hashed (and inaccessible) data for all bookmarks from LIB_DATA, as referenced in LIB_ITEMS:
select * from LIB_DATA where ITEM_ID in (select ITEM_ID from LIB_ITEMS where ITEM_TYPE='debd56cd-50bb-47b0-a458-84a2fccf3ca0')

 - To view the properties of bookmarks from LIB_PROPERTIES, as referenced in LIB_ITEMS:
select * from LIB_PROPERTIES where ITEM_ID in (select ITEM_ID from LIB_ITEMS where ITEM_TYPE='debd56cd-50bb-47b0-a458-84a2fccf3ca0')

Issue/Introduction

Where are bookmarks stored?

Additional Information

KB 000028817: List all bookmarks in the Spotfire database for a specific analysis: