Editing a database query
You can edit the database query when you want to query different data from the database or if you want to query the data from a different database.
Before you begin
- 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 modify any 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.
-
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
to open the project that contains the test assets.
The Overview page of the project is displayed.
-
Click
.
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 and select the database query that you want to delete.
The name of the database query is suffixed with the .dtd.yaml file extension.
The database query is displayed on the Data page. -
Click Edit.
Alternatively, navigate to the logical folder Datasets in the Data navigator panel, right click the database query that you want to edit, and then click Edit.
-
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:
- Select an Edit branch from the Select branch list if Edit branches already exist in the selected branch of the repository.
- Click Ok.
- Perform the following steps to create the Edit branch:
- Select Create new branch.
- Enter a name for the Edit branch.
- Click Save.
- Perform the following steps to select an existing Edit
branch:
-
Perform the following steps on the Data page to select a
different table or query the different data from the same database or different
database:
Results
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.