Using Data Listings
Data listings show the results of CQL (Clinical Query Language) queries in Data Workbench.
First, select your Study from the Studies page. Then, open the Listings page either from the Navigation Drawer () or 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.
To view the clinical data returned in a listing, click on a listing’s Title to open it.
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
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.
To set column widths:
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.
Edit the listing’s CQL query to add an
ORDER BY clause to sort results.
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:
- Navigate to a Core Listing within your Study.
- Make your changes to the query. See the CQL Reference for details about creating a CQL query.
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.
- Click Close (X) to close the CQL Editor.
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.