Editing a database query

Edit online

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

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.
Created an application in your project. See Creating an application.

Procedure

Log in to Test Hub.
The Projects page of the initial team space is displayed.
Click 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 Database Queries container, then right-click the database query you want to edit and select Edit.

The Edit Branch dialog is displayed.

If the Edit branch dialog is not displayed, then go to step 7.
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 Use an existing edit branch.
  2. Select an Edit branch from the Select branch list if Edit branches already exist for your repository.
    
    Note: A warning message is displayed if the Edit branch, which you selected, is behind the source branch. To update the selected edit branch and maintain synchronization with the source branch, you can select the Update branch option when switching checkbox.
  3. Click Ok.
- Perform the following steps to create the Edit branch:
  1. Select Create new edit branch.
  2. Enter a name for the Edit branch in the Branch Name field.
  3. Click Save.
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:
1. Select a different table, modify the query, or different connection.
2. Click View to switch between the Visual and Code view.
  
  Note: The default view is Visual view. In the Code view you can type the query to get data from the database.
3. Click the Preview icon to view the queried data from the database in tabular format in the bottom window.
4. Click the Save icon to save the queried data from the database.

Results

You have edited a 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 all changes in an Edit branch.