Does JPAContainer support a query which has a join and a group using the QueryModifierDelegate methods? The sql query is below.
select oh.seq_customer_id,od.seq_sku_id,max(oh.order_date),min(oh.order_date),
sum(od.order_quantity) as Qty,sum(od.price_amount) as Total_Paid from customer_order_header oh,
customer_order_detail od where oh.seq_customer_order_header_id = od.seq_customer_order_header_id
group by oh.seq_customer_id, od.seq_sku_id