Searching in KFS
Keep in mind:
- Users may enter data in any or all fields on a search screen. You may also leave all fields blank in some cases.
- For cases where a field is required, you may enter a percentage ‘%’ or an asterisk ‘*’ as a wildcard.
- Below is a list of special characters you may use:
| Character(s) | Function | Use with | Example (Account Number field) |
|---|---|---|---|
| | | Or | All types of data |
GF11500|GF23400 Matches on either of these two account numbers: GF11500 GF23400 |
| && | And | All types of data |
GF11500&&GF23400 Matches on records that contain both of these account numbers: GF11500 GF23400 |
| ! | Not equal to | Alphanumeric characters |
!GF31490 Matches on all account number except GF31490 |
| ? | Match on any single character | Alphanumeric characters |
GF3?490 Matches on all seven-digit account numbers that start with GF3 and end with 490 (GF30490, GF31490, etc.) |
| * or % | Match on any character or characters | Alphanumeric characters |
GF3* Matches on all account numbers that start with GF3 (GF30000, GF39765, etc.) |
| > | Greater than | Alphanumeric characters |
>GF31490 Matches on all account numbers greater than GF31490 |
| < | Less than | Alphanumeric characters, numbers, dates |
<GF31490 Matches on all account numbers less than GF31490 |
| >= | Greater than or equal to | Alphanumeric characters, numbers, dates |
>=GF31490 Matches on all account numbers greater than or equal to GF31490 |
| <= | Less than or equal to | Alphanumeric characters, numbers, dates |
<=GF31490 Matches on all account numbers less than or equal to GF31490 |
| .. | Between (inclusive range) | Alphanumeric characters, numbers, dates |
1031490..1111500 Matches on account numbers equal to or greater than 1031490 and on account numbers less than or equal to 1111500 |