Deleting Dashboard Versions from a Specific Folder in Spotfire Server

Product	Version
Spotfire Server	12 or Above Versions

Keywords:
delete-library-versions, folder GUID, parent_id, item_type:dxp, CLI, library cleanup

Introduction: Administrators may need to delete dashboard (DXP) versions from a specific folder in the TIBCO Spotfire library. This article explains how to use the delete-library-versions CLI command with search queries to target versions in a specific folder.

Scenario: The following command structure is used to delete versions, but specifying a folder requires a search query (-q):

ERROR: No versions deleted. Ensure the search query targets the correct folder.

This error occurs when the parent_id (folder GUID) is missing or incorrect in the search query.

The Solution:

To delete dashboard versions from a specific folder:

Obtain the Folder GUID

Find the folder’s GUID via the Library Administration tool:
- Navigate to the folder Right-click Properties Copy GUID.
- Or search using:
```
title:"Folder Name" AND item_type:folder
```

Construct the Search Query

Use parent_id::<GUID> and item_type:dxp:

parent_id::dac3cd8c-47ec-454a-a8f2-691c60ece052 AND item_type:dxp

Run the delete-library-versions Command

delete-library-versions 
  --bootstrap-config=/path/to/bootstrap.xml 
  --user=admin 
  --tool-password=******** 
  --search-query="parent_id::dac3cd8c-47ec-454a-a8f2-691c60ece052 AND item_type:dxp" 
  --keep-named-versions=true 
  --keep-current-version=true 
  --verbose=true

Flags:

--keep-named-versions=true : Retain versions with custom names.
--keep-current-version=true : Preserve the latest version.

Important Notes:

Test with --verbose=true before using --force.
Ensure the user has DELETE_VERSIONS permissions on the folder.

Conclusion:

By using parent_id::<GUID> in the search query, you can safely delete dashboard versions from a specific folder. Adjust retention flags (--keep-at-least, --keep-at-most) as needed for compliance.

Documentation for Reference:

Obtain the Folder GUID

Construct the Search Query

Run the delete-library-versions Command

Related articles