Equipment Range Filter

 

The equipment range filter used in many reports is designed to allow flexible selection of equipment items.

 

It comprises of 2 fields a ‘start equipment’ and ‘end equipment’. Dependant what is entered into these fields will affect the records returned.

 

 

 

 

An example equipment item list will be used to show how this works.

 

If we have a list of ten equipment items;

 

AC1, AIR1, BELT1, BELT2, CON1, CON2, DRV1, FAN1, MOTOR1, SPR1

 

 

The table below shows example outcomes, in all instances the outcome indicates that records matching the equipment list will be returned, this is in conjunction with any other filter criteria that the report may be using.

 

 

Start Equipment	End Equipment	Outcome
Blank	Blank	Complete list of equipment items
CON2	Blank	Consecutive list of items from CON2 until he end of the list
BELT1	FAN1	Consecutive list of items starting at BELT1 and ending with FAN1
MOTOR1	MOTOR1	The specific equipment item

 

 

Consecutive list are all equipment items that ‘fit’ between the selected start and end alphanumerically. In the above example, the range BELT1 to FAN1 would return;

 

 

BELT1, BELT2, CON1, CON2, DRV1, FAN1.