AnsweredAssumed Answered

Parameter in a Portlet Filter to Return the Result

Question asked by voliveira on Dec 3, 2013
Latest reply on Dec 4, 2013 by Atul.Kunkulol

Hi,

I want to define in NSQL a parameter by a ID of project that when I filter in a Grid Portlet, show the results of my SQL query. I already define the NSQL parameter, but it's not showing any results when I put the ID of the project in the field ID of the portlet.

NSQL:

SELECT   @SELECT:DIM:USER_DEF:IMPLIED:IDC:ID:ID@
        ,@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDC:CODE:CODE@
        ,@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDC:NAME:NAME@
        ,@SELECT:DIM:USER_DEF:IMPLIED:PERIOD:to_char(MES, 'yyyy-mm'):period_name@
        ,@SELECT:DIM_PROP:USER_DEF:IMPLIED:PERIOD:to_char(MES, 'Mon yy'):period_desc@

................

FROM(
SELECT ID ID
, CODE CODE
, NAME NAME
, MES MES
.............................
GROUP BY INV.ID, INV.CODE, INV.NAME, C.PERIOD_START_DATE
) AMTS

WHERE ID = @WHERE:PARAM:USER_DEF:INTEGER:ID@

GROUP BY ID, CODE, NAME, MES
)
WHERE @WHERE:PARAM:USER_DEF:DATE:MES:MES@
AND @FILTER@

I have include in Filter Layout of a grid portlet the field ID, but when I put a number, there is no result. What can be?

Best Regards,

Outcomes