Work Orders with Status between 10 and 40:

f4801 (doco,dl01,srst) all(srst bw "10","45")

Note: Literals can optionally be enclosed in quotation marks which is useful when it contains special characters.

Work Order for Pizza Operation

/* Pizzas */
#pizzas =
/* Open Business View V4101JC */
v41021jb
/* Sum Qtys */
[group(f41021.mcu,f4101.litm)
 sum(f41021.pqoh,f41021.hcom,f41021.pcom)]
/* Pizzas */
all(f41021.mcu=30 f4101.srtx=PIZZA);

/* Pizza Ingredience */
#pi =
/* Open Business View V4101JC */
v41021jb
/* Sum Qtys */
[group(f41021.mcu,f4101.litm)
 sum(f41021.pqoh,f41021.hcom,f41021.pcom)]
/* Pizzas in Branch M30 */
all(f41021.mcu=M30 f4101.srtx=PIZZA);

/* Pending Work Orders */
#wos =
/* Open table F4801 */
f4801
/* Select the fields */
(doco,litm,drqj,uorg)
/* Pizzas at Status 10 */
all(litm in HPIZZA,PPIZZA srst=40);