AnsweredAssumed Answered

Date Parameters for Clarity Portlet (Clarity 12.0.5) - NSQL Query

Question asked by FHN on Feb 11, 2011
Latest reply on Feb 14, 2011 by Dave
I have a NSQL Query as follows:

SELECT
@SELECT:DIM:USER_DEF:IMPLIED:CC:DEPARTCODE:COST_CTR@,
@SELECT:METRIC:USER_DEF:IMPLIED:

SUM(CASE PROJECTCLASS WHEN 'ADMIN' THEN QUANTITY ELSE 0 END):ADMIN@,
@SELECT:METRIC:USER_DEF:IMPLIED:

100*SUM(CASE PROJECTCLASS WHEN 'ADMIN' THEN QUANTITY ELSE 0


END)/SUM(QUANTITY):ADMIN_PCT@,
@SELECT:METRIC:USER_DEF:IMPLIED:

SUM(CASE PROJECTCLASS WHEN 'SUPMNT' THEN QUANTITY ELSE 0 END):SUPPT@,
@SELECT:METRIC:USER_DEF:IMPLIED:

100*SUM(CASE PROJECTCLASS WHEN 'SUPMNT' THEN QUANTITY ELSE 0


END)/SUM(QUANTITY):SUPPT_PCT@,
@SELECT:METRIC:USER_DEF:IMPLIED:

SUM(CASE PROJECTCLASS WHEN 'PROJECT' THEN QUANTITY ELSE 0 END):PRJCT@,
@SELECT:METRIC:USER_DEF:IMPLIED:

100*SUM(CASE PROJECTCLASS WHEN 'PROJECT' THEN QUANTITY ELSE 0


END)/SUM(QUANTITY):PRJCT_PCT@,
@SELECT:METRIC:USER_DEF:IMPLIED:SUM(QUANTITY):TOTAL@
FROM
PPA_WIP
WHERE
TRANSCLASS IN ('CONSULT', 'EMPLOYEE')
AND
TRANSDATE BETWEEN TO_DATE(@WHERE:PARAM:USER_DEF:DATE:BEGIN_DATE@, 'mm/dd/yyyy') AND

TO_DATE(@WHERE:PARAM:USER_DEF:DATE:END_DATE@, 'mm/dd/yyyy')
AND
@FILTER@
GROUP BY DEPARTCODE
HAVING @HAVING_FILTER@

When creating a portlet to use this query, I wish to enable a user to use the date parameters as provided in the NSQL query in the porlet's Filter area.
I am able to select the date parameters and move them into the right-side filter area, But as soon as I click “Save”, they automatically move back to the “Available” area !!!

How can I get these parameters to remain in the Filter area so they can be used to parameterize the portlet?

Attachments

Outcomes