Please note that the screenshots provided are generic. While they may not match the exact color scheme of your Research & Analytics Platform, the content and functionality are correct.

 

Previous Query View

The Previous Query view is designed to display the most recent queries run by a user. The results associated to the query are also available for viewing.

 

Introduction

This section describes the layout and contents of the Previous Query view.

 

NOTE:

There are two types of queries that can be run in the Web Client;

  1. A standard query (previousQuery)
  2. A Temporal query (temporalQuery)

 

Both of these types of queries will appear in the Previous Query view and throughout this document they will both be referred to as a "Previous query".

 

For more detailed information on the distinction of these two types of queries please see the Query Tool help.

 

 

 

Layout of the Previous Query View

A previous query (previousQuery / temporalQuery) is created when a query is run from the Query Tool. The query is stored and displayed in the Previous Query view. These previous queries can be used to run new queries or to easily populate other views.

 

 

pqView

 

 

The query in the previous query view is comprised of multiple hierarchical levels that can be seen by expanding each level of the tree. These levels are outlined below.

 

Previous Query Name

The name of the previous query is the top level of the hierarchal tree and is comprised of these three components.

 

 

  1. Query Name - the name given at the time the query was created. The default name contains an abbreviated description and the time the query was run.
  2. Date - the date the query was created.
  3. User Id - the user who created (ran) the query.

 

pqNameLayout

 

 

Results Folder

The Results folder (pqResultsFolder) contains the results of the query. To see the query results simply expand the folder by clicking on the plus sign (plusSign) located next to the result name.

 

Results

The results associated with a previous query are determined by the query result type(s) that are selected when the query is run in the Query Tool view.

NOTE:

The following is the query result type(s) available in a Run Query popup box:

qtRunQueryWindow


  1. Number of patients is always selected by default, and its result will be part of the display.
  2. If the Demographics breakdowns is selected, then the following results will be part of the display:
    • Age Patient Breakdown.
    • Gender Patient Breakdown.
    • Race Patient Breakdown.
    • Vital Status Patient Breakdown.
  3. If the Hospital of Service breakdown is selected, then that result will also be part of the display.

 

Number of Patients

The Number of Patients (ptCount) appears if Number of Patients was checked at the time the query was run. The results are a total count for those patients who met the defined criteria.

 

pqPtCount

 

Gender Patient Breakdown

The Gender patient breakdown (ptBreakdowns) appears if Demographics breakdowns was checked at the time the query was run. The results are a breakdown by gender for those patients who met the defined criteria.

 

pqGender

 

Vital Status Patient Breakdown

The Vital Status patient breakdown (ptBreakdowns) appears if Demographics breakdowns was checked at the time the query was run. The results are a breakdown by vital status for those patients who met the defined criteria.

 

pqVitalStatus

 

Race Patient Breakdown

The Race patient breakdown (ptBreakdowns) appears if Demographics breakdowns was checked at the time the query was run. The results are a breakdown by race for those patients who met the defined criteria.

 

pqRace

 

Age Patient Breakdown

The Age patient breakdown (ptBreakdowns) appears if Demographics breakdowns was checked at the time the query was run. The results are a breakdown by age for those patients who met the defined criteria.

 

pqAge

 

Hospital of Service Patient Breakdown

The Hospital of Service patient breakdown (ptBreakdowns) appears if Hospital of Service breakdowns was checked at the time the query was run. The results are a breakdown by hospital of Service for those patients who met the defined criteria.

 

pqHospitalSvc

 

 

 

Navigation With Popup Action Menu

Each of the Previous Queries listed is equipped with a set of popup action menu that can be accessed by right-clicking the name of each:

 

     pqMenus

 

Display or Re-render a Previous Query

In place of dragging a previous query from the list and dropping it at the Query Name field inside the Query Tool view, to re-render it, users can "display" it by selecting Display from the popup menu.

 

  1. Using the right mouse button, click on the Previous Query to be displayed.
  2. A popup action menu will open.

    3.  

    pqMenus

     

  3. Select Display from the list.

    4.  

    pqMenuDisplay

     

  4. The previous query will be re-rendered, with its definitions and results displayed, at the Query Tool and Query Status views accordingly.

    5.  

    pqMenuDisplayed

     

 

Rename a Previous Query

Users can rename a previous query from the list by selecting Rename from the popup menu.

 

  1. Using the right mouse button, click on the Previous Query to be renamed.
  2. A pop-up menu will open.

    3.  

    pqMenu

     

     

  3. Select Rename from the list.

    4.  

    pqMenuRename

     

  4. The rename query dialog box will open.

    5.  

    pqRenameQuery

     

     

  5. Enter the new name of the previous query and click on the OK button.
  6. The previous query will now display in the view with the new name.

    7.  

 

 

NOTE:

When dragging a previous query to another view the new name will appear when it is dropped.

 

 

 

Delete / Remove a Previous Query

Users can rename a previous query from the list by selecting Delete from the pop-up menu.

 

  1. Using the right mouse button, click on the Previous Query to be deleted.
  2. A pop-up menu will open.

    3.  

    pqMenu

     

     

  3. Select Delete from the list.

    4.  

    pqMenuDelete

     

     

  4. A message box will open asking if you are sure you want to delete the query.

    5.  

    pqDeleteQueryMsg

     

     

  5. Click on the OK button to delete the query

    6.  

 

 

WARNING:

Once you click on Delete, the previous query will be removed from the view and there is no way to restore it. Therefore you need to make sure you want to remove it from the list.

 

 

 

Refresh the List

Users can refresh the list of previous queries from the list by selecting Refresh All from the pop-up menu.

 

  1. Using the right mouse button, click on any of the previous queries in the list.
  2. A pop-up menu will open.

    3.  

    pqMenu

     

     

  3. Select Refresh All from the list.

    4.  

    pqMenuRefresh

     

  4. The list of previous queries and their status will be refreshed.

 

 

 

Options

Users can define how many previous queries to display and the order in which they will appear in the list. The display options are set in the Options for Previous Queries window, which can be accessed by clicking on the Show Options button (options).

 

pqOptions

 

 

Maximum to Display

Queries to Display

The Maximum number of queries to display defines how many previous queries will be visible in the Previous Query view. Once the maximum number is reached the oldest query will no longer appear in the view.

 

 

TIP:

Recommendation: Use the Workplace view to save those previous queries that will be used often. In addition to being more convenient it will also prevent you from loosing a common query if the maximum number to display has been reached.

 

 

 

Sort Queries

Sort by Create Date

Selecting to sort By Create Date will sort the queries in the Previous Query view by the date and time the query was created. Once you select to sort by the creation date, you need to define whether or not it will be in ascending or descending order.

 

Ascending: displays the oldest query first.

 

Descending: displays the newest query first.

 

 

NOTE:

Renaming a query will not affect the sort order as the date and time is stored with the previous query.

 

 

Sort by Name

Selecting to sort By Query Name will sort the queries in the Previous Query view alphabetically by the name of the query. Once you select to sort by name, you need to define whether or not it will be in ascending or descending order.

 

Ascending: queries are displayed in alphabetical order with the beginning of the alphabet at the beginning of the list. (A to Z)

 

Descending: queries are displayed in alphabetical order with the beginning of the alphabet at the end of the list. (Z to A)

 

Using a Previous Query

This section describes how to use a previous query.

Draggable Items

Only the previous query itself should be dragged and dropped (copied) from the Previous Query view to other views in the Web Client.

 

Previous Query

Associated with each previous query (previousQuery / temporalQuery) are the items used to run the query, any constraints that were defined, and the results. A previous query can be added to other views by dragging the previous query name from Previous Query view to one of the following views.

 

 

 

Add to Query Tool View

The Query Tool view is designed to simplify the process of retrieving information from the database associated to the Web Client.

 

qtDragPqIschemicHrt

 

 

Add Previous Query to Query Tool View

 

Within the Query Tool view, a previous query can be added to one of the following two locations.

 

Query Name field The items and constraints from the original query will be used to create a new query. This information can be edited to make a new query or can be used as is to run the query again.
Panel (Group) Used within a new query (query-in-query). The information associated with the previous query can not be edited. Add additional search criteria (items) to be used in the new query.

 

 

Add Previous Query to the Query Name field (New Query)

  1. Highlight the previous query (previousQuery / temporalQuery) by clicking on the name of the query.
  2. While holding the left mouse button down, drag the item to the Query Tool view.
  3. Drop the item into the Query Name field.

    4.  

    dragPq

     

  4. The item(s) associated with the previous query will display in the appropriate group(s), the name of the query will appear at Query Name, and any constraints that were defined when the original query was run will now default with the new query.

    5.  

    dropPq

 

NOTE:

You can also use the short cut (right-click the previous query) "Display" action menu (discussed in previous sub-section) to achieve this.

pqMenuDisplay

 

NOTE:

When you run the query it will receive a new name. This is to distinguish the first previous query from the second.

 

Add Previous Query to the Panel (Group) (Query-in-Query)

  1. Highlight the previous query (previousQuery / temporalQuery) by clicking on the name of the query.
  2. While holding the left mouse button down, drag the item to the Query Tool view.
  3. Drop the item into the Query Name field.

    4.  

    qtDragPqIschemicHrtPanel

     

  4. The previous query will now display in the panel for Group 1.

    5.  

    qtDropPqIschemicHrtPanel

 

 

Add to Workplace View

Information in the workplace is related to the most common concepts and queries that an individual uses and in essence becomes their personal workplace.

 

wpView

Add Previous Query to Workplace View

  1. Highlight the previous query (previousQuery / temporalQuery) by clicking on the name of the query.
  2. While holding the left mouse button down, drag the previous query name to the Workplace view.
  3. Drop the previous query into either your workplace folder or the shared folder.

    4.  

    dragPqToWp

     

  4. The previous query will now appear in the workplace with the same name.

    5.  

    dropPqInWp