AutoCommand 20036 Guia de Instalação descarregar pdf (Página 60)

Common fields include first_name, operator, salespoint,date_time and orig_dt. Autorecall

does not work for Reservations module when using shared data.

If one of the following tags is found in the query string, it will be replaced with its corresponding value when the

query is executed:

Note: The tags are case sensitive, and must be upper case.

To filter on a date field, use the DATETIME function: DATETIME( Year, Month, Day [,Hour[,

Minute [, Second ] ] ] ).

• To query for all records where the DateTime field (called ORIG_DT) falls between noon and two o'clock

on December 31, 2001, use the following: "ORIG_DT >= DATETIME(2001, 12, 31, 12) .AND.

ORIG_DT < DATETIME(2001, 12, 31, 13, 59, 59)"

• DATETIME(YEAR(DATE()), MONTH(DATE()), DAY(DATE())) will retrieve today’s date (with a

default time of midnight)

• DATETIME(YEAR(DATE()), MONTH(DATE()), DAY(DATE())-1) will retrieve yesterday’s date.

For example, to automatically generate a list of all open non-reservation sales for a given operator and group within

the last 24 hours, specify the following in the Sales32c.INI file:

AutoRecall = first_name, descrip1, orig_dt FROM SH_SAVE where date_time >

DATETIME(YEAR(DATE()), MONTH(DATE()), DAY(DATE())-1) .AND. '<GROUP>' $

RECALL1 .AND. operator = '<OPERATOR>' .AND. finalized = .F. .AND. reserv_no =

This will expand to select first_name, descrip1, orig_dt FROM SH_SAVE where date_time

> DATETIME(9/30/2010) .AND. 'FOODTS' $ RECALL1 .AND. operator = 'BOB' .AND.

finalized = .F. .AND. reserv_no = 0 when the query is executed.

To add the additional restriction of the salespoint name and su/jointfilesconvert/487301/bgroup, add .AND. ‘<SUBGROUP>’ $

RECALL2 .AND. salespoint = '<SALESPOINT>':

AutoRecall = first_name, descrip1, orig_dt FROM SH_SAVE where date_time >

DATETIME(YEAR(DATE()), MONTH(DATE()), DAY(DATE())-1) .AND. '<GROUP>' $

RECALL1 .AND. '<SUBGROUP>' $ RECALL2 .AND.

operator = '<OPERATOR>' .AND. finalized = .F. .AND. reserv_no = 0 .AND.

salepoint = ‘<SALESPOINT>’

1 2 ... 55 56 57 58 59 60 61 62 63 64 65 ... 182 183

Sem comentários

AutoCommand 20036 Guia de Instalação Página 60