Restore an earlier version of a saved query

Every time you save an SQL query, DataRow saves it as a new version. As a result, you can browse all versions, activate an earlier version, or restore a query to an earlier version.

Activate, save or open an earlier version

  1. Sign-in to DataRow.
  2. At the left menu, click Saved Queries tab.
  3. Right-click a saved query and choose Versions.
  4. A window that shows the current and previous versions opens. A vertical timeline appears on the left side of the window.
  5. To view earlier versions, click the date that you want to view the query version full size.
    1. Click Activate Selected Version set the default.
    2. Click Save Selected Version As to save an earlier version as a new saved query.
    3. Click Open Selected in Editor to opens an earlier version in the Query Editor, so you can run it or make changes on it.

versioning-1024x763-1

Revert to an earlier version

An activated version replaces the current version. To keep the current version and an earlier one, save a copy of the earlier version.

  1. Sign-in to DataRow.
  2. Open Saved Queries on DataRow and locate the query you want to work on.
  3. Right-click the saved query and open the options menu.
  4. Click Versions to open earlier versions of the saved query.
  5. Select the earlier version that you want your query to be reverted.
  6. Click Activate Selected Version button below.
  7. Close the window and return to your saved queries.

Copy query from previous versions

You can copy queries from previous versions of a saved query and paste them into the current version, or use it elsewhere.

  1. Sign-in to DataRow.
  2. Open Saved Queries on DataRow and locate the query you want to work on.
  3. Right-click the saved query and open the options menu.
  4. Click Versions to open earlier versions of the saved query.
  5. Select the earlier version that you want to work on.
  6. Point the query piece, right click and copy or hit CTRL+S.
  7. Close the window and return to your saved queries.