Download User Manual

iAdvise
Doxxy
Once you’ve successfully gone through all the above steps, you should get the following result:
5.2.2.4 I TEMS ( TABLE )
We actually need two almost equal sets of data for this report. You only have to select this data from a
single SQL statement, once.
This SQL statement is analogous to the SQL statement for "Items (list)". We only need some additional
columns, such as a BLOB column for the image of the product. We can expand this statement with these
additional columns.
The “Items” SQL statement will look like this:
SELECT p.product_name,
p.product_description,
TRIM(TO_CHAR(i.unit_price, '999G999D00')) unit_price,
i.quantity,
TRIM(TO_CHAR(i.unit_price * i.quantity, '999G999D00')) total_price,
DECODE(p.product_avail, 'Y', 1, 0) product_avail,
bl$dg4o_interface.img(p.product_image,2,2) photo,
SIGN(NVL(dbms_lob.getlength(p.product_image), 0)) check_photo
FROM demo_order_items i
JOIN demo_product_info p ON i.product_id = p.product_id
WHERE i.order_id = :ORDER_ID
ORDER BY p.product_name
A practical example
Doxxy – User Manual
Version: 01.02
38 - 69