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 |