Duplicating a database query

You can create a new database query by using the existing database query, when you want the same database query with a different name or only slight modification required in the existing database query.

Before you begin

You must have completed the following tasks:

Ensured that you are assigned a role as a Project Owner or Tester in the project. See Managing access to the server projects.
Created at least one database query. See Creating a database query.

About this task

When you want to create a database query by using the existing database query, you must have an Edit branch. You can create the Edit branch during the creation of the database query. All your dataset resides in the Edit branch until you publish or discard the changes.

After you create a database query using the existing database query, you can either publish your changes to a remote Git repository or you can discard the changes made to the database query. The Edit branch automatically disappears from the Branch list as well as from the remote Git repository and sets the global branch to the previously selected branch in the following conditions:

When you publish changes to the remote Git repository.
When you discard the changes made in the dataset.

Procedure

Log in to Test Hub.

The team space that contains your project is displayed.
Click Active projects > My projects > project_name to open the project that contains the test assets.

The Overview page of the project is displayed.
Click Author > Data.

The Data page and the Data navigator panel are displayed.
Select the branch in the project repository from the Branch list.

The assets and resources in the selected branch are displayed in the Data navigator panel.
Navigate to the logical folder Datasets in the Data navigator, right click the database query that you want to save with a different name, and then click Save As.
Select your action to either select an existing Edit branch or create an Edit branch:
- Perform the following steps to select an existing Edit branch:
  1. Select an Edit branch from the Select branch list if Edit branches already exist in the selected branch of the repository.
  2. Click Ok.
- Perform the following steps to create the Edit branch:
  1. Select Create new branch.
  2. Enter a name for the Edit branch.
  3. Click Save.
Enter a different name for the database query in the Name field.
Select a folder in the Location field.
Click Save.

A message is displayed that confirms database query is created.

The database query is displayed on the Data page. The new database query created is listed under the logical folder Datasets under the selected physical folder that you selected. The name of the database query is suffixed with the .dtd.yaml file extension.
Make any required changes to the new database query, and then click Save icon to save the newly duplicated database query.

Results

You have created a database query using the existing database query in your project.

What to do next

You can publish the database query to the Git repository so that other members of the project can use the database query. See Publishing changes in an Edit branch.