i2b2 Web Client
Space shortcuts
Space Tools

Versions Compared

Old Version 30

changes.mady.by.user Heekyong Park

Saved on

compared with

New Version 31

changes.mady.by.user Heekyong Park

Saved on

Key

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


The 'Previous Queries' panel has 2 tabs. 'Previous Queries' tab, which lists all queries run by the user,

Anchor
_GoBack
_GoBack
and 'Find' tab, which allows the user to search for their previous queries.

'Previous Queries' tab

The 'Previous Queries' tab displays queries run by a user, with the most recent ones listed first. Results associated with the query can also be viewed in this tab. Both a standard i2b2 query ( Image Added ) and a Temporal query ( Image Added ) will appear in the 'Previous Queries.' Please see 3. 'Query Tool' for query types.
Image Added

Find tab

The 'Find' tab provides previous query search interface. In the first combo box ( Image Added ), users can select one of the search options; search from the 'Previous Query Name', 'Previous Result Type', 'Patient Number', or any of the above categories. The second combo box ( Image Added ) allows users to set the input keyword match options; 'Containing', 'Exact', 'Starting with', or 'Ending with'. It returns the search results in the same format as 'Previous Queries' tab display.
Image Added

  1. Select a search option ( Image Added )

Image Added

  1. Select a keyword match option ( Image Added )

Image Added

  1. Enter a search keyword in the input box ( Image Added )
  2. Press 'Find' button




Image Added

Anchor
pqIntro
pqIntro

Anchor
pqLayout
pqLayout
Layout of a Previous Query Display

A previous query ( Image Added  /  Image Added ) 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.
Image Added
 
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.

Anchor
pqName
pqName
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.

Image Added
 

Anchor
pqResultsFolder
pqResultsFolder
Results Folder

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

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

Anchor
pqPtSet
pqPtSet
Patient Set

The Patient set ( Image Added ) 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.
 
Image Added
 

Anchor
ptEncSet
ptEncSet
Encounter Set

The Encounter Set ( Image Added ) 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.
 
Image Added
  

Anchor
pqPtCount
pqPtCount
Number of Patients

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

Anchor
pqGender
pqGender
Breakdown

The breakdown ( Image Added ) 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.
 
Image Added  
 
 

Anchor
pqNavigation
pqNavigation
Navigation

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.
Image Added

Anchor
pqRenamePq
pqRenamePq
Display

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.

  1. Using the right mouse button, click on the Previous Query to be renamed.
  2. A pop-up menu will open.
  3. Select Display from the menu.
  4. The rename query dialog box will open.

Image Added

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. Select Rename from the menu.
  4. The rename query dialog box will open.

  Image Added

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

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

       

    Anchor
    pqDeletePq
    pqDeletePq
    Delete / Remove a Previous Query

    Users can rename a previous query from the list by selecting Delete from the pop-up menu. 
  3. Using the right mouse button, click on the Previous Query to be deleted.
  4. A pop-up menu will open.
  5. Select Delete from the menu.
  6. A message box will open asking if you are sure you want to delete the query. 

Image Added
 
 

  1. Click on the OK button to delete the query

    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.

     
     
     

    Anchor
    pqRefresh
    pqRefresh
    Refresh the List

    Users can refresh the list of previous queries from the list by selecting Refresh All from the pop-up menu.
  2. Using the right mouse button, click on any of the previous queries in the list.
  3. A pop-up menu will open.
  4. Select Refresh All from the menu.
  5. The list of previous queries and their status will be refreshed.

 

Anchor
pqOptions
pqOptions
Options

The third right top button panel ( Image Added , 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.
 
Image Added
 
 

Anchor
ptDisplayMax
ptDisplayMax
Maximum to Display

Anchor
pqDisplayMaxQueries
pqDisplayMaxQueries
Queries to Display

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.

 
 
 

Anchor
pqSortQueries
pqSortQueries
Sort Queries

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)

Anchor
pqSortDate
pqSortDate
Sort by Create Date

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:
Renaming a query will not affect the sort order as the date and time is stored with the previous query.

 

Auto Refresh

Anchor
pqSortName
pqSortName
Users can turn off the auto refresh, or select the auto refresh frequency from the combo box.

NOTE:
If the auto refresh option is turned off, users need to use the refresh button ( Image Added ) to see the updated previous queries list.

 

Anchor
pqUsePq
pqUsePq
Using a Previous Query

Anchor
pqDragItems
pqDragItems
Draggable Items

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

Previous Query

Associated with each previous query ( Image Added  /  Image Added ) 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 Queries' to one of the following views.
 
'Query Tool'; drop in the panel or Query Name.

    • 'Workplace' panel; drop in a user or shared folder

 
 

Patient Set

A specific set of patients can be added to other views by dragging the Patient set ( Image Added ) from 'Previous Queries' to one of the following views.
 
'Query Tool'; drop in the panel.

    • 'Workplace' panel; drop in a user or shared folder

 
 

Encounter Set

A specific set of encounters (visit list) can be added to other views by dragging the Encounter Set ( Image Added ) from 'Previous Queries' to one of the following views.
 
'Query Tool'; drop in the panel.

    • 'Workplace' panel; drop in a user or shared folder

 
 

Anchor
pqAddToQt
pqAddToQt
Add to 'Query Tool'

The 'Query Tool' is designed to simplify the process of retrieving information from the database associated to the i2b2 Web Client.
 
Image Added
 
 
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'.
 
 

Anchor
pqAddPqToQt
pqAddPqToQt
Add Previous Query to 'Query Tool'

 
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.

 
 
 

Anchor
pqAddPqToQtNew
pqAddPqToQtNew
Add Previous Query to the Query Name (New Query)

 

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

While holding the left mouse button down, drag the item to the 'Query Tool'.

  1. Drop the item into the Query Name field.

 
Image Added
 
 

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

 
Image Added
 
 

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

 
 
 

Anchor
pqAddPqToQtPanel
pqAddPqToQtPanel
Add Previous Query to the Query Name (Query-in-Query)

 

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

While holding the left mouse button down, drag the item to the 'Query Tool'.

  1. Drop the item into the Query Name field.

 
Image Added
 
 

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

 
Image Added
 
 

Anchor
pqAddPtSetToQt
pqAddPtSetToQt
Add Patient Set to the 'Query Tool'

 

  1. Click on the plus sign ( Image Added ) next to the name of the previous query that contains the patient set.
  2. Click on the plus sign ( Image Added ) next to the results folder.
  3. Highlight the Patient set ( Image Added ) by clicking on its name.

While holding the left mouse button down, drag the item over to the 'Query Tool'

  1. Drop the item into the panel labeled Group 1.

 
Image Added
 
 

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

 
Image Added
 
 
 

Anchor
pqAddEncSetToQt
pqAddEncSetToQt
Add Encounter Set to the 'Query Tool'

 

  1. Click on the plus sign ( Image Added ) next to the name of the previous query that contains the encounter set.
  2. Click on the plus sign ( Image Added ) next to the results folder.
  3. Highlight the Encounter set ( Image Added ) by clicking on its name.

While holding the left mouse button down, drag the item over to the 'Query Tool'

  1. Drop the item into the panel labeled Group 1.

 
Image Added
 
 

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

 
Image Added
 
 
 

Anchor
pqAddToWp
pqAddToWp
Add to 'Workplace' panel

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

Anchor
pqAddPqToWp
pqAddPqToWp
Add Previous Query to 'Workplace' Panel

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

 
Image Added
 
 

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

 
Image Added
 

Anchor
pqAddPtSetToWp
pqAddPtSetToWp
Add Patient Set to 'Workplace' panel

  1. Click on the plus sign ( Image Added ) next to the name of the previous query that contains the patient set.
  2. Click on the plus sign ( Image Added ) next to the results folder.
  3. Highlight the Patient set ( Image Added ) by clicking on its name.
  4. While holding the left mouse button down, drag the Patient set to the 'Workplace' panel.
  5. Drop the Patient set into either your workplace folder or the shared folder.

 
Image Added
 
 

  1. The Patient set will now appear in the workplace.

 
Image Added
 
 

Add Encounter Set to 'Workplace' panel

  1. Click on the plus sign ( Image Added ) next to the name of the previous query that contains the encounter set.
  2. Click on the plus sign ( Image Added ) next to the results folder.
  3. Highlight the Encounter Set ( Image Added ) by clicking on its name.
  4. While holding the left mouse button down, drag the Encounter set to the 'Workplace' panel.
  5. Drop the encounter set into either your workplace folder or the shared folder.

 
Image Added
 
 

  1. The encounter set will now appear in the workplace.

 
Image Added