Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Library
Created by Guest
Created on Jan 29, 2018

Spotfire Repository: Add column to LIB_ITEMS table with the full library path of direct parent item

Add a column to the LIB_ITEMS table that has the full library path of the direct parent of the item (i.e. “/Folder 1/Folder 2/Folder 3”)

  • Attach files
  • Guest
    Reply
    |
    Feb 2, 2018

    Hi Andrew, it wouldn't make sense to add a column with this data since it will duplicating data it already exists somewhere else. You can get this information yourself by queries the Spotfire metadata database. I have shared some queries on the Spotfire Wiki, have a look:

    https://community.tibco.com/wiki/tibco-spotfire-metadata-queries

    You want to use the Library Items query. The ITEM_PATH column will give you the full path of the item. We have used custom queries on the Spotfire metadata database since version 4.5 and we are currently on version 7.11. While unsupported we never found any issues with our queries. The Spotfire metadata schema is relatively simple to understand.