FILter command

Edit online

The FILter command is used to selectively tailor the display of members in the member selection list (or to remove all filtering).

Syntax

Operands

column

An MSL display column heading abbreviation.

value

A valid attribute value for parameter column.

relation

An applicable relation operator. If this parameter is omitted, the default value is the equal sign (=). The following operators are acceptable:

Table 1. Applicable relation operators
Definition	Operator
Begin with	.BW
Begin with	{
Contain	.CO
Contain	{}
End with	.EW
End with	}
Equal	-NE
	.EQ
	=
Greater	.GT
Greater or equal	.GE
Higher	-LE
	.HI
	>
Higher or equal	.HE
	=>
	>=
Less	.LT
Lower	-HE
	.LO
	<
Lower or equal	.LE
Lower or equal	<=
Not	-
Not contain	-{}
Not contain	}{
Not equal	-EQ
	-=
	.NE
	<>
	=-
	><
Not higher	-HI
Not lower	-LO

Usage notes

When using command FILter, the member names that do not match the filtering criteria are stored in Filtered List. Filter List is logically separated from Excluded List. Both filtered and excluded members are hidden from display. When using command FILter with no parameters, all members in Filtered List are revealed.

If the first parameter is not a column title abbreviation, it is interpreted as the value of the member name column.

A negative number in the Date field indicates the recent number of days. An incomplete value in the Date field is converted to the nearest day of the year. Other special Date field values that are listed in the following figure are also acceptable:

TODAY YESTER WEEK RECENT MONTH QUARTER YEAR same as ...
TOD   DAY    WEE  REC    MON   QUA     YEA  same as ...
T     D      W    R      M     Q       Y    same as ...
-0    -1     -7   -15    -31   -92     -365 .

The FLIP command deactivates all active filters. For more information about deactivating filters, see the UNFilter command.

Examples

FIL *ABC* -: Displays all the members with a name that does not contain ABC.
FIL CHA -10: Displays all the members that are modified in the last 10 days.
FIL SIZ 100 .LE TAG ? }: Displays all the members with more than 100 records whose tag names end with a question mark (?).
FIL TIT ACC .CO KEY 123: Displays all the members with a name whose title contains ACC and user key equals 123.
FIL ID MR { CRE Y CHA W: Displays all the members that are created last year and modified last week by any user ID that starts with MR.
FIL CRE 12/ <: Displays all the members that are created after 1 January 2012.
FIL CHA 2013/04 <: Displays all the members that are modified after 1 April 2013.
FIL RGEN 2 >=: Displays member generations 0, -1, and -2.
FIL: Removes all filters.