Using Data Listings


Data listings show the results of CQL (Clinical Query Language) queries in Data Workbench.

In the current release, Vault Data Workbench is only available to specific early adopter customers. Contact your Veeva Services representative for details.

Accessing Listings

First, select your Study from the Studies page. Then, open the Listings page either from the Navigation Drawer () or the Study menu.

Listings from the Navigation Drawer
Listings from the Navigation Drawer
Listings from the Study menu
Listings from the Study menu

The Listings page is divided into two sub-pages, Public Listings and Private Listings. Public Listings shows all listings that you have permission to view in your Study, both Core Listings and custom listings. Private Listings shows any private, custom listings that you’ve created.

Click on a listing’s Title to open it.

Listings page

Viewing Listings

To view the clinical data returned in a listing, click on a listing’s Title to open it.

Listing Header

The Listing page’s header displays the Category and Associated Forms for a listing. The Category is defined on listing creation, and Vault generates the list of Associated Forms based on the Forms referenced in the CQL query’s in the FROM clause.

Listing Header for a Dosing form

Data Sheet

Each listing represents the results of a CQL query or set of queries. Workbench displays those results in the Data Sheet of the listing. Depending on the size of the data set, you may have to scroll horizontally to view all data for a Subject row.

Resizing Columns

To set column widths:

  1. Hover over the line between two columns.
  2. Click and drag the line to resize the columns. Screen recording showing the click and drag to resize listing columns

Pagination

Vault displays up to 50 rows per page in a listing. Use the left and right Arrow buttons to move between pages. To go directly to a page, enter the Page Number and press Enter.

Sorting Results

Edit the listing’s CQL query to add an ORDER BY clause to sort results.

CQL Editor

You can use the CQL Editor to modify the data included in the data sheet. See details below.

Using the CQL Editor

You can use the CQL Editor to edit the CQL query, changing which information is displayed in the listing, renaming columns, and more.

Data Workbench applies this query to the listing by default:

select @HDR, * from EDC.Adverse_Events
where @Form.Status = 'submitted__v' or @HDR.Event.Status IN ('did_not_occur__v')

To edit the CQL query:

  1. Navigate to a Core Listing within your Study.
  2. Click CQL Editor. Vault opens the CQL Editor in the bottom half of your browser window. CQL Editor button

  3. Make your changes to the query. See the CQL Reference for details about creating a CQL query.
  4. Click Apply. If there are no errors in your query, Vault updates the listing to reflect the results of your query. If there are errors, Vault displays them in a banner above the Query field. Resolve them, and then click Apply again. Apply button

  5. Optional: Click Reset to return the saved query. Reset button

  6. Click Close (X) to close the CQL Editor.
You can save your result set as a custom data listing, allowing you to return to these results later and share them with other users in your organization. See details in Creating Custom Data Listings.

Data Listing Categories

Any listings that Workbench creates automatically during import from Vault EDC or 3rd party data import are assigned the Core Listings category. Any custom listings have a category assigned by the user who created the listing. Your organization can create these categories when creating custom listings. See details in Creating Custom Data Listings.