Hi,
any ideas why generate nested json doest not support Pagination?
It was already so in old version. Now I use ords 17.4. Still the same issues.
I think nested json with Pagination work im Spring boot. Why not in ords?
I use ORDS 17.4
Oracle database 12c
How can i paginate that nested json https://apexea.oracle.com/pls/apex/paul/hr/empinfo/
That is the statement behind the Service
SELECT
c.cust_first_name,
c.cust_last_name,
c.cust_city,
CURSOR (
SELECT
o.order_total,
CURSOR (
SELECT
p.product_name,
i.quantity,
i.unit_price
FROM
demo_order_items i,
demo_product_info p
WHERE
o.order_id = i.order_id
AND
i.product_id = p.product_id
) product
FROM
demo_orders o
WHERE
c.customer_id = o.customer_id
) orders
FROM
demo_customers c