The NSQL construction SUM(DECODE(R.ID,4,0,NVL(R.ID,0)/ .. causes Error 500 on a portlet when used as a power filter.
Steps to Reproduce:
- Create a Clarity Query
R.ID <> 0 THEN 1 ELSE 3600 END))):AGG@
FROM INV_INVESTMENTS I,
WHERE I.CREATED_BY = U.ID
AND U.ID = R.USER_ID
AND R.MANAGER_ID = MR.USER_ID
GROUP BY R.FULL_NAME,
- Create a Clarity portlet where the AGG attribute is in the filter section
- Use the portlet
Expected: The user should be able to filter according to AGG attribute.
Actual: Error 500 - Internal Server Error.
Error from app-niku.log file:
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00934: group function is not allowed here
This issue has been documented as CLRT-43004 and is assigned to development for review.
Keywords: CLARITYKB, error, power, filter, NSQL, clarity8open, clarity12open.