Query by Form in DirectLine

Purpose: This user guides explains how to search on any field in the DirectLine database.

Audience: Any DirectLine user.

This feature is activated from any data input screen.  There is no specific navigation path.  The sample used in this guide illustrates the Equipment Inventory Entry screen.

With your selected data entry screen open:

  1. Select the binoculars icon to initiate the query features.
Equipment entry screen with binocular icon highlighted
  1. Enter text in any field.  This example shows "laptop" in the Description field.
Equipment entry screen with Description highlighted
  1. Select the Refresh icon next to the binoculars.
Equipment entry screen with Refresh icon highlighted

The screen will populate with the first record meeting your search criteria.  A record counter in the title bar will let you know how many records meet this same criteria.

Equipment entry screen with record count result count highlighted
  1. Use the navigation arrows to scroll through the search results.
Tool ribbon with back and forward arrows for record navigation

You can include characters frequently used in data queries to provide more flexibility in your search.  The table below will be helpful.

Description
Character
Equal To No additional characters
Starting With ]
Containing []
Ending With [
Not Equal To #
Greater Than >
Less Than <

In the example below, []Server was typed into the Description field. This will look for any record that contains "Server" anywhere in the Description.

Equipment entry screen with Description field highlighted

There are 112 records that contain the word "Server".

Equipment entry screen with record count results highlighted
Description field with Server highlighted

If you didn't get results you're looking for:

  1. Select the Clear icon to refresh the screen and begin again.
Toolbar with Clear icon highlighted

Procedure complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.