There are several tabs that provide access to your records, including:
And several menu options in the Navigation tab as well:
When you select any of these options, you are presented with a list of your records from that section of the system. The list is displayed in columns and rows. The columns are fields that are found on the detail view. The rows are the available records in this section.
From the list view, you are able to:
Located at the bottom left corner of the list is a Form Options link. Click this link to access the Form Options screen and make adjustments to the following options:
When you have completed all of your Form Option modifications, click Save and a message window will appear stating 'Settings Have Been Saved'. Click Close Window and the screen will refresh with your Form Option changes in place. Remember, your Form Option selections will be saved for future display until they are changed. The columns that are selected for display in your list views are set universally for the system, regardless of which user logs into the account.
When you access a list for the first time, all of the records contained in the list are displayed. The default sort for a list is in ID order.
The list may be sorted in order by any of the field headers, or the identification that appears at the top of each column. Clicking a field header will sort the list in order based on that field. The first click on the field header will sort the list in ascending order, clicking on the arrow graphic will sort the list in descending order and change the graphic to a arrow pointing down.
The sort setting that you apply to a list is saved and used the next time the list is opened based on your user login.
Directly below the column headers in the list is a filter row with red Set and Clear links on the left. You can apply single or multiple filters to view a subset of the records contained in the list. This is a useful tool if you have many records in the list and want to quickly get to a particular record or group of records.
To apply a filter, type a value into one of the filter boxes and click the Set link. Once a filter or group of filters is applied, the list will redisplay based on that criteria, and will indicate in the upper left corner the number of records that matched the filter criteria.
For example, if you just want to view parts that begin with the letter 'A', type an 'a' (capitalization is not required) in the filter box below the Description column in the Parts List and then click the Set link. Or, as another example, if you want to view assets located in the main Building on the first floor, you would type 'main' in the filter box below the Building column and 'first' in the filter box below the floor column and then click the Set link. The list will display only those records that have 'main' as the building and 'first' as the floor.
To remove any filters, simply click the Clear link. The filters will be removed and the list will be reloaded.
There are many operators that you can utilize in conjunction with the filters to aid you in locating your records:
This is a wild card operator, meaning it can be used as a placeholder to represent all values. Place the % in front of a filter value to look for all examples of values that end with your entry. Place the % at the end of a filter value to look for all examples of values that start with your entry.
Place the % in front of and at the end of a filter value to look for all examples of values that contain your entry.
%myvalue - looks for all data that ends with 'myvalue'.
myvalue% - looks for all data that starts with 'myvalue'.
%myvalue% - looks for all data that contains 'myvalue'.
This is a "not equal to" filter. Entering
this into the filter criteria will return all results other than the
value you enter after it. Examples:
- looks for all data that does not include 'myvalue'. For instance, if
you put #PM into the WO Type column, it will return all work orders
that were not PM type work orders
These are relational operators. A relational operator compares two values and determines the relationship between them. In this situation the first value is the data contained in your data field and the second value is what you enter in the filter text box. Place one of these operators in front of the filter value to compare the data that exists to that of your filter value.
>01/01/2002 - looks for all dates that are greater than Jan. 1st 2002.
>=01/01/2002 - looks for all dates that are greater than or equal to Jan. 1st 2002.
<Z<U>- looks for all values that start with a letter less than Z (A-Y).
>B - looks for all values that start with a letter greater than B (C-Z).
>=C - looks for all values that start with the letter C or greater (C-Z).
Remember that the filter settings that you apply to a list are saved and used the next time the list is opened based on your user login.