Filters enable you to restrict which records a user can search for and open. A filter applied to a CO subsystem determines which records will be returned by a search (and therefore visible in the search results). A filter applied to a BO subsystem determines which of the returned records can be opened (to view the record details).
Once a record is opened, the ways in which the user can interact with it are determined by permissions and attributes. For example, a particular group of users may only be allowed to search for and open customer records whose country is Canada. In this case, a filter would be put in place on the TScustomerBO and TScustomerCO subsystems, restricting the Country field to Canada.
When more than one filter is applied to the same subsystem, you can use operators to specify the type of results you are expecting. For example, filters for First Name = Bob and Last Name = Smith are created for customer searches. You can control whether you want to see any customers with either of these names (First Name = Bob OR Last Name = Smith) or for only those customers with both names (First Name = Bob AND Last Name = Smith).
Information Modifications to permissions will take effect the next time the user logs on to the application. |
Select one of the titles below for more information about:
The following table describes the available filter operators:
Filter Operator |
Definition |
> |
greater than |
>= |
greater than or equal to |
< |
less than |
<= |
less than or equal to |
!= |
not equal to |
= |
equals Equals is case sensitive, so ensure that the 'Value' that you enter exactly matches what you are filtering for. |
Begins with |
begins with the entered value |
Ends with |
ends with the entered value |
contains |
contains the entered value |
The Contains function performs like Equals, but with some additional wildcard options. This operator can only be used for fields that are strings.
•% represents any string of 0 or more characters (%son returns any term that ends in son - Flarson, Carson, Montarson, Son).
The Contains function transparently adds % to the beginning and end of terms, returning results that contain the term within them as well (%son would also return Jacksonville, Samsonite).
•_ represents any single character (_andy returns any term that has a single character before the ending andy - Mandy, Randy, Sandy).
•[ ] represents any single character within a specified range or set ([A-C]son returns terms that end in son and begin with A, B or C - Ason, Bson, Cson; [BCL]son returns terms that end in son and begin with B, C or L - Barson, Carson or Larson).
•[^] represents any single character not within the specified range or set ([^A-C]son returns terms that end in son and do not begin with A, B or C - Larson, Tarson; [^CLT]son returns terms that end in son and do not begin with C, L or T - Barson, Narson).
Select one of the titles below for more information about: