Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Section
Column
width40%
Panel
borderColor#A40000
bgColor#F8F8F8
titleBGColor#E8E8E8
borderStyledashed
titleContentsborderStyledashed
Table of Contents
maxLevel4
minLevel3
outlinefalse
Column

This material was adapted from , documentation for the KFS 4.x releases.

Note
titleWork in Progress

This information will continue to be updated.

...

Using special characters in search

Anchor
specialCharacters
specialCharacters

Character(s)

Function

Use with

Example (Account Number field)

Or

All types of data

1111500

1123400
Matches on either of these two account numbers:
1111500
1123400

&&

And

All types of data

1111500&&1123400
Matches on records that contain both of these account numbers:
1111500
1123400

!

Not equal to

Alphanumeric characters

!1031490
Matches on all account number except 1031490

?

Match on any single character

Alphanumeric characters

103?490
Matches on all seven-digit account numbers that start with 103 and end with 490 (1030490, 1031490, etc.)

*

Match on any character or characters

Alphanumeric characters

103*
Matches on all account numbers that start with 103 (1030000, 1039765, etc.)

>

Greater than

Alphanumeric characters

>1031490
Matches on all account numbers greater than 1031490

<

Less than

Alphanumeric characters, numbers, dates

<1031490
Matches on all account numbers less than 1031490

>=

Greater than or equal to

Alphanumeric characters, numbers, dates

>=1031490
Matches on all account numbers greater than or equal to 1031490

<=

Less than or equal to

Alphanumeric characters, numbers, dates

<=1031490
Matches on all account numbers less than or equal to 1031490

..

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

...