I'm getting a parsing error when trying to port a datawindow to our Web API using the C# Model Generator. The database is Oracle and the error is Error: ORA-00952: missing GROUP keyword. Below is the select statement being used. It seems like the model generator does not like the Oracle LISTAGG function. Is there a workaround or fix for this? The datawindow previews fine in PB.
Thanks, Tom
SELECT x_partial.item_number as line_item,
(SELECT LISTAGG(rtrim(obs_code_id), '/') WITHIN GROUP (ORDER BY obs_code_id)
FROM l1_partial_codes WHERE partial_id = x_partial.partial_id) as hold
FROM
l1_claim_item,
x_partial
WHERE
l1_claim_item.claim_id = :claim_id AND
x_partial.partial_id = l1_claim_item.partial_id ;