Document number: 11527

 

 

When searching for existing records in Customer1, use operators (in an Advanced Search) to search for records that fit a very specific set of criteria or to narrow your search and eliminate irrelevant search results. Note that operators aren't available on all pages. The % symbol can be used with most operators ("=" and "in" excluded) as a wildcard to match one or more characters. A value is what you enter into a search field. A field value is the value of a particular field in an existing record.

Operator	Function
=	Field Value EQUAL TO Value
not=	Field Value NOT EQUAL TO Value
<	Field Value LESS THAN Value
<=	Field Value LESS THAN OR EQUAL TO Value
>	Field Value GREATER THAN Value
>=	Field Value GREATER THAN OR EQUAL TO Value
begins with	Field Value EQUAL TO Value %
between	Field Value >= Value #1 AND Field Value <= Value #2 Sample Input: "100 and 200" Returns: All records between 100 and 200
in	Field Value IN List of Values (separated by commas) Sample Input: "100, 218, 365" Returns: All records with any of those values
contains	Field Value EQUAL TO %Value %

 

 

 

 

 

 

 

 

Created by the PeopleSoft Knowledge Management Team.
Copyright © 2001 All rights reserved.
Created: amq 11/01/02