The Advanced Find screen allows you to search for information in the database using a variety of criteria. You can use these criteria options to narrow your search.
1.Access the Advanced Find screen from the Main screen by selecting Management > Find > Advanced Find. Below is an example of the Advanced Find screen.
2.The Advanced Find screen consists of seven fields that allow you to select criteria to narrow your search. The Filter Expression panel displays the "filter" as you enter information in the criteria fields. The filter is simply the criteria you have selected. For example, if you select the following information:
Table: Asset
Field: Asset Tag
Operator: =
Value: 100007404
then the Filter Expression field will display this information and the system will search for Assets with the asset tag number 100007404.
Below are descriptions of each of the criteria fields:
Table - used to select the table (information you enter into each field in Rosistem Assets is stored in a database "table" behind the scenes. You can extract this information using the Export Wizard.) you want to search within the database.
Parenthesis - (open and close) used to control the order in which criteria will be processed. The inner most pair of parentheses in any filter expression are evaluated first.
Field - used to select the field you want to search within the specified table.
Operator - a comparison operator used to evaluate an expression.
Comparison Operator |
Meaning |
= |
equal |
<> |
not equal |
>= |
greater than or equal |
> |
greater than |
<= |
less than or equal |
< |
less than |
Like |
is similar to value |
Not Like |
is not similar to value |
Is Null |
no value |
Is Not Null |
any value |
Like and Not Like are used for text pattern matching. They can only be used with plain text fields, not with dates. The following characters, used within the text value, have a special meaning for the Like and Not Like operators:
LIKE Operator |
Meaning |
_ (underscore) |
matches any single character |
% |
matches zero or more characters of any value |
\ |
Escapes the special characters (gives them their normal meaning) |
Value - the information for which you are searching. (This can include special characters for the Like or Not Like operators).
Logical - a Boolean operator that combines one or more filter expressions into a single logical group:
Boolean Operator |
Meaning |
AND |
gives you the intersection of two conditions |
OR |
gives you the union of two conditions |
3.Enter the desired values for the seven Advanced Find fields to construct a filter fragment, or part of the Filter Expression.
4.Click the Add button after building each filter expression to add it to the Filter Expression list.
The Move Up and Move Down buttons allow you to move a filter fragment toward the top or toward the bottom of the list, respectively. To reposition a filter fragment in the Filter Expression panel, click on it, then click either the Move Up or Move Down button.
You can edit a filter fragment by first selecting the fragment in the Filter Expression list. The values of the filter fragment populate the seven input fields. Update any of these fields, then click Replace to update the selected filter fragment in the Filter Expression list.
Click the Check button to check the syntax of the Filter Expression.
5.Click the Find button to start the search process. When complete, a list will be displayed showing all the records that match your criteria.