Can I Delete a Trace or Data from a Citadel Database?

Updated Jun 21, 2019

Reported In

Software

  • LabVIEW Datalogging and Supervisory Control Module

Issue Details

I have some data in a Citadel database that I want to remove. Is there a way to delete data from Citadel?

Solution

You can remove the data from a Citadel database using LabVIEW, Lookout or Measurement & Automation Explorer. This is a two step process:
  1. First you archive the data that you want to delete. When archiving, choose to delete this data from the original database. The archiving operation will move the data from your database to new database.
  2. The second step is to delete the new archived database. This removes the extra database that was created by the archive operation. Once the data has been archived you can remove the archived data by either deleting the database manually or by using file VIs from LabVIEW.
The document elaborates this process for Measurement & Automation Explorer, LabVIEW and Lookout separately
  • Measurement & Automation Explorer: You must have Historical Data Viewer installed. It comes with Lookout 5.0 and LabVIEW DSC 6.1 and later. 
    To remove the historical data in Measurement & Automation Explorer, follow these steps:
    1. Under the Historical Data folder in Measurement & Automation Explorer, select the database that you want to remove data from.
    2. Right-click the database and select New View»Trace. This creates a trace view with the default name of New View under the database folder.
    3. On the Trace Attributes page, click on Add new traces. Select the traces you want to archive.
    4. Select a starting and stopping time.
    5. Right-click New View and select Archive.
    6. Enter a directory path to store the archived data.
    7. Check the Delete data from source database checkbox to delete the data from the source database.
    8. Click Start.
    9. Once it is complete, click Close.
    10. Right-click in the Trace Attributes window and choose Refresh. You will see that the data has been removed from the current database.
  • LabVIEW Datalogging and Supervisor Control (LabVIEW DSC 6.1 and later) 
Use the Archive Traces VI, Delete Traces VI, and Delete Database VI from the Historical Data palette to remove data from the data base. Be aware that deleting traces will permanently remove the data and it will be lost if it is not previously archived. If you delete traces and you find that the database size does not decrease, you may need to compact your database. Before deleting a database, make sure that it is detached from your Citadel Univers.
  • Lookout (4.5 or later)
Use the CitadelControl object in the Logging category. The data member DeleteEnabled controls whether the data is deleted when it is archived.