Moteurs Baudouin

Function

Description

Syntax

Example

The date is based on the user format

20160101

*

Starts with

x*

STE*

*

Ends with

*x

*UP

*

Contains

*x*

*TEP*

:

Specify a field

FIELD: x

CUNM: STEP*

AND

AND operator

x AND y

STEP AND INFOR

OR

OR operator

x OR x

STEP OR INFOR

NOT

NOT operator

x NOT x

STEP NOT INFOR

?

Replace a character

xx?x

STE?-UP

?*

Searching for fields that have a value

FIELD: ?*

SUNO: ?*

TO

Terminal included

STAT:[x TO y]

STAT:[20 TO 90]

TO

Terminal excluded / included

STAT:{x TO y]

STAT:{20 TO 90]

TO

Terminal included / excluded

STAT:[x TO y}

STAT:[20 TO 90}

\

Escape special characters

+ - & || ! ( ) { } [ ] ^ " ~ * ? : \

Pour rechercher : (1+1):2

Syntaxe : \(1\+1\)\:2

<> 

<USID>   User login

<CONO>  Company

<DIVI>   Division

<CurrentDivison> Current Division

<FACI>   Facility (MNS150)

<CUNO>  Customer number (MNS150)

<LNCD>   Langage (MNS150)

<CurrentLanguage> Session language

<TIZO>   Time zone (MNS150)

<WHLO>  Warehouse (MNS150)

<DEPT>   Department (MNS150)

<MNVR>  Menu version (MNS150)

<DFMN>  Menu (MNS150)

LMDT : Change Date

CHID : Changed by

RESP:<USID>

CONO:<CONO>

SortBy:

Sort in ascending order

SortBy:x,y,z

CONO:100 SortBy: LMDT,CHID

SortBy:!

Sort in descending order

SortBy:!x

CONO:100 SortBy: !LMDT

Stock négatif :               STQT:[* TO 0}

:

Négatif = STQT:[* TO 0}, positif = STQT:{0 TO *]

YEAR()

Year

-1 = Last year

0 = Current year

1 = Next year

YEAR(valeur)

YEA4: YEAR(-1)

MONTH()

Month

0 = Current month

MONTH()

MONTH(0)

WEEK()

Week

0 = Current week

WEEK()

WEEK(-2)

DATE()

Day

0 = Current day

DATE()

LMDT: [DATE(-10) TO DATE(0)]

~

Similar to

x~

STO~

SearchFields:

Multi column search

SearchFields:x;y

SearchFields:ITDS;FUDS STEP-UP