Queries

Queries in BDMS

• Query Overview
• How to Create and Run a New BDMS Query
• Methods of Entering Query Search Criteria Values
• Query Results Window
• Printing a Document from the Query Results Window

Query Overview

The query tool enables you to do the following:

• create a new query
• edit an existing query
• run an already created query

BDMS provides a variety of document search and retrieval methods. Documents can be searched by index, wildcard, a list of values, and a combination search. You can search a single application or across multiple applications at the same time. After a query is created, it can be saved for later use and edited as needed. Saved queries appear under the application to which they belong.

After you retrieve a document from a query, you can view, print, add, and delete pages or documents and modify index and document properties.

NOTE: These functions are based on permissions assigned to your account, so you may not have all these functions.

^ back to top

How to Create and Run a New BDMS Query

1. From the list of applications, click the required application, and click New Query.
   
   


2. In the New Search page, use the index fields to specify the search criteria.
   
   Queries can be created by entering one or move values in any of the search fields. The more index values you enter for a query, the narrower the search will be. This will limit the amount of documents returned.
   
   


3. After all Query Selection Criteria has been entered, perform one of the following actions:
   
   
    
   • To run the query without saving it for future use, click RUN.
   • To save the query, and be able to run it at a future time, click SAVE.
     
     NOTE: If the query is saved, give the query a name and optionally check the "Available to all Users" checkbox if you want to share the query with other BDMS users. If you do not check the checkbox, your query is saved as a private query that only you can access.
     
     
      
   • To exit out of the query and return to the main BDMS page, click CANCEL.

^ back to top

​​Methods for Entering Query Search Criteria Values

BDMS offers several options for selecting search Criteria. The search criteria can be as simple as one field value, such as a BannerID, or a complex combination of multiple values. 

See these four methods for entering Query Searches:

• Single Value Search Criteria
• Multiple Select / Input and Enter Search Criteria
• Search Range Search Criteria
• Search List Search Criteria

Single Value Search Criteria

1. In the applicable text fields, enter search terms.
2. Click the Search icon.
   Example: Next to ID, enter a specific student's BannerID to see all documents in an application for a specific student.
   
   

TIP: Using Wildcard Characters in Search Fields. In the New Search page, index search criteria can be specified by using the asterisk (wildcard) character (*). For example, specify '2018*' to search for documents with a term code that begins with the characters '2018'

Multiple Select / Input and Enter Search Criteria

1. For search fields that are tied to a predefined list of values, like Document Type, click in the field and choose a value from the drop-down list.
   
   
    
2. To enter multiple values, choose a value from the drop-down, then click in the search criteria white space to choose an additional value.
   
   The search criteria for that field displays the selected list of values.
   
   

Search Range Search Criteria

1. To search based on a range of values, click the Search Range icon.
   
   
    
2. Enter your beginning and ending values.
   
   The Type of Comparison can use a number of relational operations.
   
   
    
3. Click OK.
   
   
   
   You are now presented with a written expression for the Search Range in the index field.
   
   

Search List Search Criteria

This search criteria allows you to enter multiple select values for a query. 

1. To query on two or more Banner IDs (or other values), click the List search icon.
2. One-by-one, enter the Banner ID's.
3. After each Banner ID entered, click Add.
4. Click the Search List icon.

^ back to top

Query Results Window

When you submit a query, one or more rows of query results will display in the BDMS Query Results window. There are a variety of actions that can be performed on any document shown in the Query Results window.

1. To open a document, click the down-arrow ▼.
2. Click Open.

^ back to top

Printing a Document from the Query Results Window

Once you have displayed a document from the Query Results window you can print it to your local or network printer.

1. To print a query result, click PRINT.
   
   
    
2. Click a print option (all pages, current page, or specific page ranges), and click PRINT.
   
   

^ back to top