AnsweredAssumed Answered

Is it possible to use values entered in a Portlet parameter in other parameter condition

Question asked by Nag_cl on Jan 12, 2015

Hi Team,

Is it possible to use values entered in a Portlet parameter in other parameter conditions?

For Example:

In my portlet i would have values entered in param_FinishDateDiff Text field.

Can we use the value entered in param_FinishDateDiff to manipulate other parameter (param_ProjFinshDate)???...

 

When i tired to do so, Below nSQL is thorwing me error in Clarity.

 

AND (@WHERE:PARAM:USER_DEF:INTEGER:param_FinishDateDiff@  IS NULL)

  AND (@WHERE:PARAM:USER_DEF:INTEGER:param_FinishDateType@ IS NULL)

  AND (@WHERE:PARAM:USER_DEF:INTEGER:param_ProjFinshDate@ IS NULL OR ((@WHERE:PARAM:USER_DEF:INTEGER:param_ProjFinshDate@ = I.SCHEDULE_FINISH)

  AND (I.SCHEDULE_FINISH >= Param_ProjectFinish – NVL(param_FinishDateDiff,0)))

 

 

Regards,

Naga

Outcomes