<< Click to Display Table of Contents >> Navigation:  Best Practices > Tip: Finding and Filtering Data

Grid Behavior

Within Laguna, you can make the process of viewing and sorting data very easy especially when data is presented in a grid format. Typically, this is done when displaying controllers, stations, Advanced ET parameters and AIM parameters.

 

Sorting and Filtering Columns

Right-clicking on the heading row of a grid will reveal a menu that allows columns to be resized, position modified, column data sorted and columns sorted into groups.

Grouping the controller Online column is one of many useful groupings.

Moving or Re-ordering Columns

You can drag and drop a column to a new position to make viewing more useful.

Hiding and Revealing less used columns

You can drag and drop a column of the header row and hide it from view. To add a column, right-click the header and select Column Chooser.

 

Finding Data Within a Grid

•First, select the grid using the mouse

•Press Ctrl + F together to reveal the Find text entry field, Find and Clear buttons. If the menu does not show, right-click the header row and select Show Find Panel.

•Type some text that you want to search, all items in all columns matching the text will automatically be revealed with the text highlighted.

•Sample started means show all rows that contain started

•Sample turf spray means all rows that contain turf or spray

•Sample turf spray -shrubs means all rows that contain turf or spray but exclude all rows that contain shrubs

•Sample online:yes -riv means in the Online column, only show yes and don't show rows that contain riv

 

Filter Grid Data via Find Panel

The Find Panel provides an easy way of searching against visible columns/card fields. Displayed above the grid, the panel contains a search box where you can type a search string.

 

Invoke the Find Panel

•Ensure that no cell editor is active and press Ctrl+F.

or

•In Grid Views, choose the Show Find Panel command from a column menu.

•Enter a search string in the search box. In most cases, rows are filtered automatically after a short while.

•In some cases (mostly when the grid is bound to a large amount of data), you need to press the Find button to manually start the search.

The search syntax is described below.

Clear the Search Box

Press ESC or click the Clear button.

Close the Find Panel

Click the 'x' button to the left of the search box or:

•If the search box is empty, press ESC (the shortcut is in effect if the search box has focus);

•If the search box is not empty, press ESC twice (the shortcut is in effect if the search box has focus).

Search Syntax

In its simplest form, a search criterion consists of a single word. If you want to search for a string containing a space character, specify this string in quotation marks. Without quotation marks, words separated by the space character are treated as individual conditions.

You can search against a specific column by preceding a search string with the column's display name plus a colon character.

column name:Search String

Instead of the complete name, it is possible to partially specify the display name, using the initial characters of a column's display name. A search will be performed against the first column whose display name starts with the specified subsisting. If you want to search against a column whose display caption contains space characters, specify the column's display caption in quotation marks.

If the search string contains multiple conditions separated by space characters, and at least one condition defines a search against a specific column, only records that match all of these conditions are shown (i.e., the conditions are combined by the AND logical operator). If there is no column specification, records that match at least one of these conditions are shown (i.e., the conditions are combined by the OR logical operator).

Precede a condition with "+" to display only records that match this condition. The "+" specifier allows you to implement the logical AND operator. There should be no space character between the "+" sign and the condition.

Precede a condition with "-" to exclude records that match this condition from the result set. There should be no space between the "-" sign and the condition.

Examples

 

*DevExpress User Guide.