<p>The <b>Previous Query view</b> is designed to display the most recent queries run by a user. The results associated to the query are also available for viewing.
<p>This section describes the layout and contents of the <b>Previous Query view</b>.</p>
<p> </p>
<tableid=note>
<tr>
<td>
<pclass=NoteHeading>NOTE: </p>
<pclass=NoteParagraph>
There are two types of queries that can be run in the i2b2 Web Client;
</p>
<ol>
<liclass=NoteParagraph>
A standard i2b2 query <spanstyle="color:#CCCCCC">(<imgsrc="images/prevQuery.png"alt="previousQuery"/>)</span>
</li>
<liclass=NoteParagraph>
A Temporal query <spanstyle="color:#CCCCCC">(<imgsrc="images/iconTemporalQry.png"alt="temporalQuery"/>)</span>
</li>
</ol>
<pclass=NoteParagraph> </p>
<pclass=NoteParagraph>
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".
</p>
<pclass=NoteParagraph> </p>
<pclass=NoteParagraph>
For more detailed information on the distinction of these two types of queries please see the Query Tool help.
</p>
</td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<h3><aname="pqLayout"id="pqLayout"></a>Layout of the Previous Query View</h3>
<p>A <b>previous query</b><spanstyle="color:#CCCCCC">(<imgsrc="images/prevQuery.png"alt="previousQuery"/> / <imgsrc="images/iconTemporalQry.png"alt="temporalQuery"/>)</span> is created when a query is run from the <i>Query Tool</i>.
The query is stored and displayed in the <b>Previous Query view</b>. These previous queries can be used to run new queries or to easily populate other views.
</p>
<p> </p>
<p> </p>
<p><imgsrc="images/pqView.png"alt="pqView"/></p>
<p> </p>
<p> </p>
<p>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.
<p>The name of the previous query is the top level of the hierarchal tree and is comprised of these three components.
</p>
<p> </p>
<p> </p>
<ol>
<li><b>Query Name</b> - the name given at the time the query was created. The default name contains an abbreviated description and the time the query was run.
</li>
<li><b>Date</b> - the date the query was created.</li>
<li><b>User Id</b> - the user who created (ran) the query.</li>
<p>The <b>Results folder</b><spanstyle="color:#CCCCCC">(<imgsrc="images/pqResultsFolder.png"alt="pqResultsFolder"width="16"height="16"/>)</span> contains the results of the query. To see the query results simply expand the folder by clicking on the <i>plus sign</i><spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> located next to the result name.
<p>The results associated with a <b>previous query</b> are determined by the <b>query result type(s)</b> that are selected when the query is run in the <b>Query Tool view</b>.
<p>The <b>Patient set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> appears if <i>Patient set</i> or <i>Timeline</i> was checked at the time the query was run. The set contains all the patients who met the defined search criteria.
<p>The <b>Encounter Set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> appears if <i>Encounter set</i> was checked at the time the query was run. The set contains all the patients whose encounters met the defined search criteria.
<h5><aname="pqPtCount"id="pqPtCount"></a>Number of Patients</h5>
<p>The <b>Number of Patients</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptCount.png"alt="ptCount"/>)</span> appears if <i>Number of Patients</i> was checked at the time the query was run. The results are a total count for those patients who met the defined criteria.
<p>The <b>Gender patient breakdown</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptBreakdowns.png"alt="ptBreakdowns"/>)</span> appears if <i>Gender patient breakdown</i> was checked at the time the query was run. The results are a breakdown by gender for those patient who met the defined criteria.
<h5><aname="pqVitals"id="pqVitals"></a>Vital Status Patient Breakdown</h5>
<p>The <b>Vital Status patient breakdown</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptBreakdowns.png"alt="ptBreakdowns"/>)</span> appears if <i>Vital Status patient breakdown</i> was checked at the time the query was run. The results are a breakdown by vital status for those patient who met the defined criteria.
<p>The <b>Race patient breakdown</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptBreakdowns.png"alt="ptBreakdowns"/>)</span> appears if <i>Race patient breakdown</i> was checked at the time the query was run. The results are a breakdown by race for those patient who met the defined criteria.
<p>The <b>Age patient breakdown</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptBreakdowns.png"alt="ptBreakdowns"/>)</span> appears if <i>Age patient breakdown</i> was checked at the time the query was run. The results are a breakdown by age for those patient who met the defined criteria.
<li>Click on the <b>OK button</b> to delete the query</li>
<p> </p>
</ol>
<p> </p>
<p> </p>
<tableid=warning>
<tr>
<td>
<pclass=WarningHeading>WARNING: </p>
<pclass=WarningParagraph>
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.
</p>
</td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<h3><aname="pqRefresh"id="pqRefresh"></a>Refresh the List</h3>
<p>Users can refresh the list of previous queries from the list by selecting <b>Refresh All</b> from the <i>pop-up menu</i>.
</p>
<p> </p>
<ol>
<li>Using the <i>right mouse button</i>, click on any of the previous queries in the list.</li>
<p>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 <b>Show Options button</b><spanstyle="color:#CCCCCC">(<imgsrc="images/options.png"alt="options"/>)</span>.
<h4><aname="ptDisplayMax"id="ptDisplayMax"></a>Maximum to Display</h4>
<h5><aname="pqDisplayMaxQueries"id="pqDisplayMaxQueries"></a>Queries to Display</h5>
<p>The <b>Maximum number of queries to display</b> defines how many previous queries will be visible in the <b>Previous Query view</b>. Once the maximum number is reached the oldest query will no longer appear in the view.
</p>
<p> </p>
<p> </p>
<tableid=tip>
<tr>
<td>
<pclass=TipHeading>TIP: </p>
<pclass=TipParagraph>
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.
<h5><aname="pqSortDate"id="pqSortDate"></a>Sort by Create Date</h5>
<p>Selecting to sort <b>By Create Date</b> will sort the queries in the <b>Previous Query view</b> 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.
</p>
<p> </p>
<p><b>Ascending:</b> displays the <i>oldest</i> query <i>first</i>.</p>
<p> </p>
<p><b>Descending:</b> displays the <i>newest</i> query <i>first</i>.</p>
<p> </p>
<p> </p>
<tableid=note>
<tr>
<td>
<pclass=NoteHeading>NOTE: </p>
<pclass=NoteParagraph>
Renaming a query will not affect the sort order as the date and time is stored with the previous query.
</p>
</td>
</tr>
</table>
<p> </p>
<p> </p>
<h5><aname="pqSortName"id="pqSortName"></a>Sort by Name</h5>
<p>Selecting to sort <b>By Query Name</b> will sort the queries in the <b>Previous Query view</b> 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.
</p>
<p> </p>
<p><b>Ascending:</b> queries are displayed in alphabetical order with the <i>beginning</i> of the <i>alphabet</i> at the <i>beginning</i> of the list. (A to Z)
</p>
<p> </p>
<p><b>Descending: </b>queries are displayed in alphabetical order with the <i>beginning</i> of the <i>alphabet</i> at the <i>end</i> of the list. (Z to A)
</p>
<p> </p>
<h2><aname="pqUsePq"id="pqUsePq"></a>Using a Previous Query</h2>
<p>This section describes how to use a previous query.</p>
<p>Different parts of the previous query can be dragged and dropped (copied) from the <b>Previous Query view</b> to other views in the i2b2 Web Client.
</p>
<p> </p>
<p> </p>
<ol>
<li>Previous Query</li>
<p>Associated with each <b>previous query</b><spanstyle="color:#CCCCCC">(<imgsrc="images/prevQuery.png"alt="previousQuery"/> / <imgsrc="images/iconTemporalQry.png"alt="temporalQuery"/>)</span> 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 <b>Previous Query view</b> to one of the following views.
</p>
<p> </p>
<ul>
<li><b>Query Tool view;</b> drop in the <i>panel</i> or <i>Query Name</i>.</li>
<li><b>Workplace view;</b> drop in a <i>user</i> or <i>shared folder</i></li>
</ul>
<p> </p>
<p> </p>
<li>Patient Set</li>
<p> A specific set of patients can be added to other views by dragging the <b>Patient set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> from <b>Previous Query view</b> to one of the following views.
</p>
<p> </p>
<ul>
<li><b>Query Tool view;</b> drop in the <i>panel</i>.</li>
<li><b>Workplace view;</b> drop in a <i>user</i> or <i>shared folder</i></li>
</ul>
<p> </p>
<p> </p>
<li>Encounter Set</li>
<p> A specific set of encounters (visit list) can be added to other views by dragging the <b>Encounter Set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> from <b>Previous Query view</b> to one of the following views.
</p>
<p> </p>
<ul>
<li><b>Query Tool view;</b> drop in the <i>panel</i>.</li>
<li><b>Workplace view;</b> drop in a <i>user</i> or <i>shared folder</i></li>
</ul>
</ol>
<p> </p>
<p> </p>
<h3><aname="pqAddToQt"id="pqAddToQt"></a>Add to Query Tool View</h3>
<p>The Query Tool view is designed to simplify the process of retrieving information from the database associated to the i2b2 Web Client.
<p>Within the <b>Previous Query view</b> there are several items that can be used in the Query Tool view to run a query. The following sections explain how to add the previous query, patient set and encounter set to the Query Tool view.
</p>
<p> </p>
<p> </p>
<h4><aname="pqAddPqToQt"id="pqAddPqToQt"></a>Add Previous Query to Query Tool View</h4>
<p> </p>
<p>Within the Query Tool view, a previous query can be added to one of the following two locations.</p>
<td>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.
</td>
</tr>
<tr>
<td><b>Panel (Group)</b></td>
<td>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.
</td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<h4><aname="pqAddPqToQtNew"id="pqAddPqToQtNew"></a>Add Previous Query to the Query Name (New Query)</h4>
<p> </p>
<ol>
<li>Highlight the <b>previous query</b><spanstyle="color:#CCCCCC">(<imgsrc="images/prevQuery.png"alt="previousQuery"/> / <imgsrc="images/iconTemporalQry.png"alt="temporalQuery"/>)</span> by clicking on the name of the query.
</li>
<li>While holding the <i>left mouse button</i> down, drag the item to the <b>Query Tool view</b>.</li>
<li>Drop the item into the <b>Query Name field</b>.</li>
<li>The item(s) associated with the previous query will display in the appropriate group(s), the name of the query will appear at <b>Query Name</b>, and any constraints that were defined when the original query was run will now default with the new query.
When you run the query it will receive a new name. This is to distinguish the first previous query from the second.
</p>
</td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<h4><aname="pqAddPqToQtPanel"id="pqAddPqToQtPanel"></a>Add Previous Query to the Query Name (Query-in-Query)</h4>
<p> </p>
<ol>
<li>Highlight the <b>previous query</b><spanstyle="color:#CCCCCC">(<imgsrc="images/prevQuery.png"alt="previousQuery"/> / <imgsrc="images/iconTemporalQry.png"alt="temporalQuery"/>)</span> by clicking on the name of the query.
</li>
<li>While holding the <i>left mouse button</i> down, drag the item to the <b>Query Tool view</b>.</li>
<li>Drop the item into the <b>Query Name field</b>.</li>
<h4><aname="pqAddPtSetToQt"id="pqAddPtSetToQt"></a>Add Patient Set to the Query Tool View</h4>
<p> </p>
<ol>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the name of the previous query that contains the patient set.
</li>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the results folder.
</li>
<li>Highlight the <b>Patient set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> by clicking on its name.
</li>
<li>While holding the <i>left mouse button</i> down, drag the item over to the <b>Query Tool view</b></li>
<li>Drop the item into the<strong></strong><b>panel</b> labeled <b>Group 1</b>.</li>
<h4><aname="pqAddEncSetToQt"id="pqAddEncSetToQt"></a>Add Encounter Set to the Query Tool View</h4>
<p> </p>
<ol>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the name of the previous query that contains the encounter set.
</li>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the results folder.
</li>
<li>Highlight the <b>Encounter set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> by clicking on its name.
</li>
<li>While holding the <i>left mouse button</i> down, drag the item over to the <b>Query Tool view</b></li>
<li>Drop the item into the<strong></strong><b>panel</b> labeled <b>Group 1</b>.</li>
<h3><aname="pqAddToWp"id="pqAddToWp"></a>Add to Workplace View</h3>
<p>Information in the workplace is related to the most common concepts and queries that an individual uses and in essence becomes their personal workplace.
<h4><aname="pqAddPqToWp"id="pqAddPqToWp"></a>Add Previous Query to Workplace View</h4>
<ol>
<li>Highlight the <b>previous query</b><spanstyle="color:#CCCCCC">(<imgsrc="images/prevQuery.png"alt="previousQuery"/> / <imgsrc="images/iconTemporalQry.png"alt="temporalQuery"/>)</span> by clicking on the name of the query.
</li>
<li>While holding the <i>left mouse button</i> down, drag the previous query name to the <b>Workplace view</b>.
</li>
<li>Drop the previous query into either your workplace folder or the shared folder.</li>
<h4><aname="pqAddPtSetToWp"id="pqAddPtSetToWp"></a>Add Patient Set to Workplace View</h4>
<ol>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the name of the previous query that contains the patient set.
</li>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the results folder.
</li>
<li>Highlight the <b>Patient set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> by clicking on its name.
</li>
<li>While holding the <i>left mouse button</i> down, drag the <b>Patient set</b> to the <b>Workplace view</b>.
</li>
<li>Drop the Patient set into either your workplace folder or the shared folder.</li>
<h4><aname="pqAddPtSetToWp"id="pqAddPtSetToWp2"></a>Add Encounter Set to Workplace View</h4>
<ol>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the name of the previous query that contains the encounter set.
</li>
<li>Click on the plus sign <spanstyle="color:#CCCCCC">(<imgsrc="images/plusSign.png"alt="plusSign"/>)</span> next to the results folder.
</li>
<li>Highlight the <b>Encounter Set</b><spanstyle="color:#CCCCCC">(<imgsrc="images/ptSet.png"alt="ptSet"/>)</span> by clicking on its name.
</li>
<li>While holding the <i>left mouse button</i> down, drag the <b>Encounter set</b> to the <b>Workplace view</b>.
</li>
<li>Drop the encounter set into either your workplace folder or the shared folder.</li>