AnsweredAssumed Answered

USE PARAMETER IN NSQL AND PORTLETS

Question asked by Saulex on Dec 5, 2018
Latest reply on Dec 5, 2018 by Dave_3.0

Hello guys,

In my work I have been required to generate a customized dashboard which details the ideas with their costs and which in turn show internal graphics. Create a dashboard, however one of the portlets is not performing the action I want. The portlet called "Effort of the project" when clicking on the name should send me a summary table (eye I need to customize, since I will generate graphics among others), but it does not. the steps I did were the following:

 

#1: Create portlet pageand link parameter

 

 

#2: Create linkin in principal portlet

#3: Create query and agree

 

SELECT
@SELECT:DIM:USER_DEF:IMPLIED:IDEA:INV_IDA.ID:ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:INV_IDA.CODE:CODE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:INV_IDA.NAME:NAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:LKP_CATEGORY.NAME:CATEGORY@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:NVL(LKP_CCTYPE.NAME,'No Registrado'):CCTYPE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:NVL(LKP_MOTIVE.NAME,'No Registrado'):MOTIVO@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:NVL(LKP_VALLA.NAME,' - '):VALLA_IDEA@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:INV_IDA.DESCRIPTION:DESCRIPTION@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:IDA.PAC_FECHA_PRIO:F_PRIO@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:IDA.PAC_SUPERA_PRES:FILTER_VALLA_IDEA@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:PLAN.TOTAL_COST:COSTO@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:PLAN.TOTAL_UNITS:HOURS@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:IDA.OBJ_OBJECTIVE:OBJECTIVE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:AUTOR.FULL_NAME:AUTOR@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:EDN.FULL_NAME:EDN@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:IDA.PAC_SUPERA_10:MAY_DIEZ@
FROM
INV_INVESTMENTS INV_IDA
JOIN ODF_CA_IDEA IDA ON IDA.ID = INV_IDA.ID
JOIN INV_IDEAS ODF_IDA ON ODF_IDA.ID = INV_IDA.ID
JOIN FIN_PLANS PLAN ON PLAN.OBJECT_ID = INV_IDA.ID
LEFT OUTER JOIN SRM_RESOURCES AUTOR ON INV_IDA.CREATED_BY = AUTOR.USER_ID
LEFT OUTER JOIN SRM_RESOURCES EDN ON ODF_IDA.INITIATOR_ID = EDN.USER_ID
LEFT JOIN CMN_LOOKUPS_V LKP_CATEGORY ON LKP_CATEGORY.LOOKUP_CODE = IDA.OBJ_REQUEST_CATEGORY
AND LKP_CATEGORY.LOOKUP_TYPE = 'OBJ_IDEA_PROJECT_CATEGORY'
AND LKP_CATEGORY.language_code = @WHERE:PARAM:LANGUAGE@
LEFT JOIN CMN_LOOKUPS_V LKP_CCTYPE ON LKP_CCTYPE.LOOKUP_CODE = IDA.PAC_TIPO_CC_TI
AND LKP_CCTYPE.LOOKUP_TYPE = 'PAC_TIPO_CC_TECNOLOGIA'
AND LKP_CCTYPE.language_code = @WHERE:PARAM:LANGUAGE@
LEFT JOIN CMN_LOOKUPS_V LKP_MOTIVE ON LKP_MOTIVE.LOOKUP_CODE = IDA.PAC_MOTIVO_CC
AND LKP_MOTIVE.LOOKUP_TYPE = 'OBJ_IDEA_CHANGE_MOTIV'
AND LKP_MOTIVE.language_code = @WHERE:PARAM:LANGUAGE@
LEFT JOIN CMN_LOOKUPS_V LKP_VALLA ON LKP_VALLA.LOOKUP_CODE = IDA.PAC_SUPERA_PRES
AND LKP_VALLA.LOOKUP_TYPE = 'PAC_VALLA_CC'
AND LKP_VALLA.language_code = @WHERE:PARAM:LANGUAGE@
WHERE
1=1
AND INV_IDA.ID = @WHERE:PARAM:XML:INTEGER:/data/code/@value@
AND @FILTER@

 

#4: Create link in principal portlet

 

After that, when I try to click, the secondary portlet returns empty and I can not
find the error. I would greatly appreciate your support in being able to give me
recommendations to resolve this inconsistency

Thanks,

Regards Saulo

Outcomes