Previous Topic: Special StatementsNext Topic: Union, Intersect, and Exclude


Inclusions

The following classes have been defined for the examples that follow:

Class name: BUSPROJECT

FILE ["*.DOC","*.XLS","*.MDB", "*.HTM"]

Class name: FUNPROJECT

FILE ["*.AVI","*.WAV","*.HTM"]

Class name: NETW1

COMPUTER WHERE COMPUTER_OPERATING_SYSTEM IN ["SUNOS","SOLARIS",”LINUX”]

Class name: NETW2

COMPUTER WHERE COMPUTER_OPERATING_SYSTEM IN ["WINDOWS","NETWARE4",”LINUX”]

The IN operator expresses an inclusion. The object selected as a result of the inclusion is based on the object being a member of a group of objects. For example:

Class name: JASBPROJECT

FILE WHERE FILE_OWNER_NAME="JASON"
AND FILE IN BUSPROJECT

This selects the files that belong to user Jason and that are included in the class BUSPROJECT. You can replace the class definition (BUSPROJECT) in the statement with the list of files that constitute the class.

Class name: MAINETW2

COMPUTER WHERE COMPUTER_SIZE > 15 GB AND 
COMPUTER IN NETW2

The previous statement selects the computers that have more than 15 GB of space and run Windows or NetWare4. You can replace the class definition (NETW2) in the statement with the list of operating systems that constitute the class.