AnsweredAssumed Answered

NSQL Parameter Usage

Question asked by rkljr on Apr 22, 2009
Latest reply on Apr 29, 2009 by rkljr
Is it possible to use a NSQL Parameter as a parameter to an Oracle function? For example,  SELECT     @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:v.rscId:rscId@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.rscCode:rscCode@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.rscLastName:rscLastName@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.rscFirstName:rscFirstName@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.mgrId:mgrId@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.mgrLastName:mgrLastName@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.mgrFirstName:mgrFirstName@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.rscDept:rscDept@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.rscAllocation:rscAllocation@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:v.rscAllcMnthPrb:rscAllcMnthPrb@,                 @SELECT:DIM:USER_DEF:IMPLIED:PROJECT:v.prjId:prjId@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:v.prjCode:prjCode@,                 @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:v.prjName:prjName@,                 @SELECT:METRIC:USER_DEF:IMPLIED:v.prjRscHrs:prjRscHrs:AGG@ FROM         rsc_allc_prtlt01 v WHERE       resourceReport(@WHERE:PARAM:USER_ID@, v.rscId) > 0 AND           @FILTER@ HAVING        @HAVING_FILTER@   This does not seem to work. How can I pass the "user_id" to such a function. In this case, the function returns if the resource reports into the "user". Thus, the resource could directly or indirectly report to the user. We are not using a resourceOBS at this time and thus need a means to implement some security.

Outcomes