i2b2 Web Client
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

4. Press 'Find' button


Anchor
pqIntro
pqIntro

...


...

6.3 Layout of a Previous Query Display

Anchor
pqLayout
pqLayout

previous query (  /  ) is created when a query is run from the 'Query Tool'. These previous queries can be used to run new queries or to easily populate other panels.

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

...

6.3.1 Previous Query Name

Anchor
pqName
pqName

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.

Image Modified

...

6.3.2 Results Folder

Anchor
pqResultsFolder
pqResultsFolder

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

Anchor
pqResults
pqResults

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'. 

...

6.3.2.1.1 Patient Set

Anchor
pqPtSet
pqPtSet

The Patient set ( ) appears if Patient set or Timeline was checked at the time the query was run. The set contains all the patients who met the defined search criteria.
 

 

...

6.3.2.1.2 Encounter Set

Anchor
ptEncSet
ptEncSet

The Encounter Set ( ) appears if Encounter set was checked at the time the query was run. The set contains all the patients whose encounters met the defined search criteria.
 

  

...

6.3.2.1.3 Number of Patients

Anchor
pqPtCount
pqPtCount

The Number of Patients ( ) 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.
 

 

...

6.3.2.1.4 Breakdown

Anchor
pqGender
pqGender

The breakdown ( ) appears if Gender / Vital Status / Race / Age patient breakdown was checked at the time the query was run. The results are a breakdown by gender / vital status / race /age for those patients who met the defined criteria.
 
 
  

6.4 Navigation

Anchor
pqNavigation
pqNavigation

6.4

...

6.4.1 Menu

Using the mouse right click on the 'Previous Queries' panel, users can open the Previous Queries Menu. 'Display,' 'Rename,' 'Delete' options act on the selected, or mouse hovered previous query. When the menu is called from a blank space, those menu options are applied to the previous target query.

...

6.4.1.1 Display

Anchor
pqRenamePq
pqRenamePq

Users can see a previous query information by selecting Display from the popup menu. It loads its query name, the query design, and the results in the 'Query Tool' panel.

...

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

...

6.4.1.3 Delete / Remove a Previous Query

Anchor
pqDeletePq
pqDeletePq

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

...

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.

...

6.4.1.4 Refresh the List

Anchor
pqRefresh
pqRefresh

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

...

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

...

6.4.2 Options

Anchor
pqOptions
pqOptions

The third right top button panel ( , the red circle in the following image) in the 'Previous Queries' prompts an Options window. Users can define how many previous queries to display, the order in which they will appear in the list, and auto refresh setting.
 

...

6.4.2.1 Maximum to Display

...

6.4.2.1.1 Queries to Display

Anchor
ptDisplayMax
ptDisplayMax
Anchor
pqDisplayMaxQueries
pqDisplayMaxQueries

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

TIP:
Recommendation: Use the 'Workplace' panel 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.

...

6.4.2.2 Sort Queries

Anchor
pqSortQueries
pqSortQueries

6.4.2.2.1 Sort by Name

Selecting to sort By Query Name will sort the queries in the 'Previous Queries' 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)

...

6.4.2.2.2 Sort by Create Date

Anchor
pqSortDate
pqSortDate

Selecting to sort By Create Date will sort the queries in the 'Previous Queries' 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:
If the auto refresh option is turned off, users need to use the refresh button ( ) to see the updated previous queries list.

...


...

6.5 Using a Previous Query

...

6.5.1 Draggable Items


Anchor
pqUsePq
pqUsePq
Anchor
pqDragItems
pqDragItems

Different parts of the previous query can be dragged and dropped (copied) from the 'Previous Queries' to other views in the i2b2 Web Client.

...

    • 'Query Tool';drop in the panel.
    • 'Workplace' panel; drop in a user or shared folder

...

6.5.2 Add to 'Query Tool'

Anchor
pqAddToQt
pqAddToQt

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

 
 
Within the 'Previous Queries' there are several items that can be used in the 'Query Tool' to run a query. The following sections explain how to add the previous query, patient set and encounter set to the 'Query Tool'.

...

6.5.2.1 Add Previous Query to 'Query Tool'

Anchor
pqAddPqToQt
pqAddPqToQt

 
Within the 'Query Tool', 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.

...


...

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

Anchor
pqAddPqToQtNew
pqAddPqToQtNew

1. Highlight the previous query (  /  ) by clicking on the name of the query.

...

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

...


6.5.2.1.2 Add Previous Query to the Query Name (Query-in-Query) 

Anchor
pqAddPqToQtPanel
pqAddPqToQtPanel

1. Highlight the previous query (  /  ) by clicking on the name of the query.

...

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

...

6.5.2.2 Add Patient Set to the 'Query Tool'

Anchor
pqAddPtSetToQt
pqAddPtSetToQt

1. Click on the plus sign ( ) next to the name of the previous query that contains the patient set.

...

5. The item will now display in the panel for Group 1. 

...

6.5.2.3 Add Encounter Set to the 'Query Tool' 

Anchor
pqAddEncSetToQt
pqAddEncSetToQt

1. Click on the plus sign ( ) next to the name of the previous query that contains the encounter set.

...


 
5. The item will now display in the panel for Group 1. 


 

...

6.5.3 Add to 'Workplace' panel

Anchor
pqAddToWp
pqAddToWp

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

  

...

6.5.3.1 Add Previous Query to 'Workplace' Panel

Anchor
pqAddPqToWp
pqAddPqToWp

1. Highlight the previous query (  /  ) by clicking on the name of the query.

...

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


 

...

6.5.3.2 Add Patient Set to 'Workplace' panel

Anchor
pqAddPtSetToWp
pqAddPtSetToWp

1. Click on the plus sign ( ) next to the name of the previous query that contains the patient set.

...