How do I restore a deleted dashboard, document, report, or filter?

Version 1

    When a user deletes a dashboard, document, report, or filter, they are not really deleted from the database.  Instead, their record in the database is marked inactive and no longer show up in the web interface.

    Currently, the only way to restore one of these is to manually update the appropriate record in the Xtraction database.  The following sections indicate how to restore these files.

    BACK UP YOUR DATABASE

    Any time you attempt to directly modify the Xtraction database, it is strongly advised that you back up the database before making your changes.

     

     

    Identify the ID of the deleted item

    Through whatever means, identify the ID of the dashboard, document, report, or filter that you wish to undelete.

    1. If you have the Xtraction adapter, you can use the Dashboard, Document, Report, Filter, and/or Audit views to identify the ID of the object to undelete.  Depending on your version of the Xtraction adapter, you may need to modify it to show the IDs in the various views.
    2. If you do not have the Xtraction adapter, you can view/query the tables using SQL tools.
    Example queries are:
    • SELECT * FROM dbo.Dashboard WHERE Active = 0
    • SELECT * FROM dbo.Document WHERE Active = 0
    • SELECT * FROM dbo.Report WHERE Active = 0
    • SELECT * FROM dbo.Filter WHERE Active = 0

     

     

    Undelete a Dashboard

    To undelete a dashboard, run the following SQL query against the Xtraction database (updating the query with the ID of the dashboard to undelete):

    UPDATE Dashboard

    SET Active = 1

    WHERE DashboardId = <ID Here>

     

     

    Undelete a Document

    To undelete a document, run the following SQL query against the Xtraction database (updating the query with the ID of the document to undelete):

    UPDATE Document

    SET Active = 1

    WHERE DocumentId = <ID Here>

     

     

    Undelete a Report

    To undelete a report, run the following SQL query against the Xtraction database (updating the query with the ID of the report to undelete):

    UPDATE Report

    SET Active = 1

    WHERE ReportId = <ID Here>

     

     

    Undelete a Filter

    To undelete a report, run the following SQL query against the Xtraction database (updating the query with the ID of the report to undelete):

    UPDATE Filter

    SET Active = 1

    WHERE FilterId = <ID Here>

     

     

    IMPORTANT - RESTART XTRACTION

    After updating the Active flags for one or more objects, they will not appear in the web interface until the Xtraction application pool is restarted on the Xtraction server.