Introduction and Training

Introduction and Training By: Snehil Gupta CBMI, WUSTL

Presentation Outline Introduction to Query Features Live Demo Exercises

General ClinPortal Workflow

QUERY Module

Operations and Activities (role based) NOTE: Currently, by default, NO data is being shared with General Scientist.

Functional Outline

Query Module - View

Query Module – Saved Queries View My Queries filter: Displays all queries created in the system by current user. It also allows user to execute/edit his/her queries listed.

Query Module – Saved Queries View User can select “All Queries” filter to see all the queries present in the system Control to edit the saved query Control to execute the saved query All Queries filter: Displays queries created in the system by all the user. It also allows user to execute/edit the queries listed.

Query Module – Saved Queries View User can select “Shared Queries” filter to see all queries shared with the current user. Control to edit the saved query Control to execute the saved query Shared Queries filter: Displays queries created in the system by other users and shared with current user. It also allows user to execute/edit the queries listed.

Query Module – Exercise 1 • Task – Under each of the following three filters view the queries enlisted: • My Queries • All Queries • Shared Queries

Query Module – Types of Queries Pre-defined constituents of a cheese-burger. CANNED QUERY Pick and choose constituents of a sub. PARAMETERIZEDED QUERY

Query Module – Canned Query Execute a canned query enlisted under saved queries.

Query Module – Canned Query Results Tree-view showing records in a hierarchical manner Grid-view showing records in detail

Query Module – Exercise 2 Task – Under ‘All Queries’ filter execute the following canned query and view the results: “Patients with high blood pressure (Canned Query)”

Query Module – Parameterized Query Execute a parameterized query enlisted under saved queries.

Query Module – Parameterized Query User can specify any limiting value at the time of query execution

Query Module – Parameterized Query Results Tree-view showing records in a hierarchical manner Grid-view showing records in detail

Query Module – Exercise 3 • Task – Under ‘All Queries’ filter execute the following parameterized query with a limiting value of your choice: “Patients with blood pressure (Parameterized Query)”. • Say limiting value is set as: • a. systolic between 150 and 170 • AND/OR • b. Diastolic between 85 and 90 • View the query results.

Query Module – Define Results View

Query Module – Result View

Query Module – Define Result View

Query Module – Exercise 4 • Task – Under any of the three filters, select one query and define it result view. You must perform the following activities at least once: • Remove columns from view • Add columns to view • Arrange columns in view by shifting them up/down in the order

Query Module – Data Export

Query Module – Exercise 5 • Task – Execute a query and export its results in the following distinct ways: • Check all – export • Check all on this page – export • View the exported results in both the cases.

Export Form Data

Export Form Data b. Select form whose data is to be exported a. Select a study d. Enter the upper range of encounter date c. Enter the lower range of encounter date

Export Form Data e. Export data into .csv file

Export Form Data

THANK YOU 

Introduction and Training

Introduction and Training

Presentation Transcript

Training Programme – Introduction

Training Grants: Introduction

Introduction to Training Data

Introduction: Training and UAS?

Introduction and objectives of the training

Introduction to Personal Training

Introduction to Fitness and Training

Basic Introduction Training

Introduction to eziLink Training

IBIS Training: Introduction

ACE Training Introduction

Introduction to Training

An Introduction to Strength and Conditioning Training

R Introduction and Training

Introduction and Training

BEA WebLogic Server Introduction and Training

QA Introduction Training

Sas Introduction Training

AngularJS Introduction Training

Communion Training Introduction

TPM Training - Introduction

Introduction to training