Clarity: Creating a power filter for an NSQL portlet generates the generic Error 500.
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.
Expected: The user should be able to filter according to AGG attribute.
Actual: Error 500 - Internal Server Error.
This issue has been documented as CLRT-43004 and is assigned to development for review.
Keywords: CLARITYKB, error, power, filter, NSQL, clarity8open, clarity12open.