Base alias is "Customer". Child alias is "Orders". Second child alias (2th level) is Order_Line_Items.
| Info |
|---|
This example is for XFRX 19.1.0 because use data:template element. |
Data preparation
| Code Block |
|---|
m.lcTASTRADE=HOME(2)+"Tastrade\Data\"
OPEN DATA (m.lcTASTRADE+"TASTRADE")
USE Customer ORDER "CUSTOMER_I" IN 0
USE Orders ORDER "CUST_ORD" IN 0
USE Order_Line_Items ORDER "ORDER_ID" IN 0
USE Products ORDER "PRODUCT_ID" IN 0
SELECT order_Id, SUM(UNIT_PRICE*QUANTITY) AS Amount ;
FROM Order_Line_Items;
GROUP BY order_ID;
INTO CURSOR order_amount
SELECT ("order_amount")
INDEX ON order_ID TAG "order_I"
SELECT ("Order_Line_Items")
SET RELATION TO PRODUCT_ID INTO ("Products")
*SET FILTER TO VAL(PRODUCT_ID)<40
SELECT ("Orders")
SET RELATION TO order_ID INTO ("order_amount")
SET RELATION TO order_ID INTO ("Order_Line_Items") ADDITIVE
*SET FILTER TO VAL(order_id)<=644
SELECT ("Customer")
SET RELATION TO Customer_id INTO ("Orders")
SET FILTER TO RECNO()<=4
*SET FILTER TO Customer_id="ANTON"
|
...