Value Data Types
The value entered in the Value field must match the data type for the attribute selected.
| Data Type | Description |
|---|---|
| Numeric | Consists of one or more of the numbers 0-9. Used for things like ID and priority. The data entry field for numeric values will not allow you to enter any characters other than numbers. |
| Text | Consists of any number of letters, numbers, or special characters (e.g., #, $).
Filtering on text is case sensitive. Note that text attributes are the only attribute types with which you can use wildcard characters. For more information, see Using Wild Card Characters. If you are filtering on text that contains any of the four special characters (*, ?, ‘, or \), they must be “escaped”. For information, see Filtering on Special Characters. |
| DateTime | Dates can be entered manually or by using the “date picker” on the filter data-entry dialog.
Times, if specified, must be entered manually. If you enter a date, but not a time, it assumes “all times” for the specified date. All times use the 24-hour clock. There is also a special "Today" entry that can be used when filtering on DateTime attributes. This entry always represents the current date. For more information about entering dates and times in the filter data entry dialog, see DateTime Attributes. |
| Enumeration | Some attributes only allow you to select a valid entry. These are called “enumerations”. |