The Order List

Steps:

1.	Create a new page and name it as "Orders"

2.	Place the "Tutorial > OrderTracking > OrderList" element on the page

OrderList

The "Orders" panel is repeated for each order in the "orders" table. The properties of "orderlist" data source element are as follows:

Name

orderlist

Connection Name

SuperStore

Query

SELECT

o.ID, o.ORDER_DATE, o.STATUS,

c.NAME AS CUSTNAME,

e.NAME AS EMPLNAME

FROM

customers c, employees e, orders o

WHERE

o.CUSTOMER_ID = c.ID AND

o.EMPLOYEE_ID = e.ID;

Displaying the details of an order

The "Hyperlink | Value" property of the "ID" element is "display.doms?pg=OrderDetails&ID=$vof(ID)&_rand="

"display.doms" is the Display Page service of the MoreMotion AF. The parameters are:

•

The page to display

•

The ID of the order whose details will be displayed. This parameter will be used by the query that returns the fields of the selected order.

•

_rand

A special parameter to avoid browser caching