Download
1 / 37
370 likes | 459 Views
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).
E N D
Introduction and Training By: Snehil Gupta CBMI, WUSTL
Presentation Outline Introduction to Query Features Live Demo Exercises
Operations and Activities (role based) NOTE: Currently, by default, NO data is being shared with General Scientist.
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 – 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 – 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 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
