At times, queries are needed to get some specific information contained in a list.
These can be simple queries to quick retrieve some information.
Target Audience
LabVantage Users
LabVantage Administrators
Refer to Generate Ad Hoc Queries solution article for more details on the Ad Hoc Query portion of this solution article.
Show Advanced Search
1. Locate the Show Advanced Search link and select it.
2. A sidebar will show.
a. The options will be different for each applications.
b. The article shows only one of them.
3. Sections
a. Categories
I. A list of categories will show that could be associated with the list record.
II. Selecting one of the categories in the list will filter the main list by that category.
b. Folders
I. If specific records need to be followed, folders can be used to easily find them later.
II. Mark the records that need to be added to a folder.
III. Select the ....to a new folder option
IV. Select the Add button just above ...to a new folder
V. Select the Rename button. Give the new folder a meaningful name.
VI. If additional records need to be added to a folder, mark the records to add. Mark the folder to add it to. Select the Add button.
VII. To remove a folder, select the folder. Select the Delete button
VII. Multiple folders can be saved at any one time.
IX. Folders are user specific
c. Ad Hoc Search
I. Select the Create Adhoc Query
II. Drag fields into the search field area
III. Edit the search fields for your query.
IV. Select Count Results button. This will let you know if you will return any records.
V. If the record count is more than 0, then select Search Now button. The sidebar will go away. The record list will update based on the query.
VI. If the query is done regularly, Use the Save Query. Give the query a name. Select Save Now.
VII. In future queries, the saved queries will be available for selection.