FILTRE

Description

This action is used to filter the elements in the principal and last read lists. It is executed before the action FILGAUCHE that has the same objective to filter the records but this time for the principal and secondary lists.
Only action available on the object template.

Left list type

Principal,  Last read
single list, hierarchy list, single picking, hierarchy picking

OBJect type

Simple, Grid, Combined

Transaction

No

Use

This filter is expressed in the form of a character string containing a logical condition on one or more several fields in the principal table. For example : 
FILTSUP+= "BPSTYP=2"

The variables to be entered are as follows  :
    FILTSUP     for the standard
    CRITERE    for the specific/custom.

This action is also used to reposition the principal table as the default table (this is necessary for example, in a simple management with detail table).

Example : SUBSOHA   sales orders

The orders proposed in left lists must respond to the flowing criteria :
    this is not a contract order ( SOHCAT < 4)
    its category corresponds to that of the entry transaction ( GORDCAT = 4 | GORDCAT =   SOHCAT )

$FILTRE
Default File [SOH]
# the order must be of the type classic and authorised by transaction
FILTSUP += "SOHCAT < 4 & (GORDCAT = 4 | GORDCAT = SOHCAT)"

---