Lookup value incorrect in common grid
search cancel

Lookup value incorrect in common grid

book

Article ID: 263744

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We have some custom lookups and since the upgrade to 16.1.0 the value displayed on the grid is incorrect.

Query behind the lookup

SELECT
    @SELECT:0:ID@,
    @SELECT:X.INDICADOR:INDICADOR@  
FROM(SELECT
        T.ORDEN ORDEN,
        T.INDICADOR INDICADOR
    FROM(SELECT CASE WHEN (Z_EXAMPLE(NVL(@WHERE:PARAM:USER_DEF:INTEGER:ID_CARTERA@,0),'CARTERA','BLOQUEANTE') = 0) THEN 'Blocking Alerts'
                ELSE 'NO Blocking Alerts'
                END INDICADOR,
                1 ORDEN
        FROM DUAL
        UNION
        SELECT
            ' ' INDICADOR,
            2 ORDEN
        FROM DUAL
    )T
    ORDER BY T.ORDEN
)X
    WHERE @FILTER@
    AND ROWNUM = 1

The query states if VALUE 0 then display 'Blocking Alerts'

The DB shows a value of 0

The object instance details show the appropriate message

The Details Flyout on the grid show also the appropriate message

But the column on the grid view shows the wrong message: 'NO Blocking Alerts'

In 16.0.1 this was not an issue

Cause

Few changes related to lookup performance improvement (caching) went into 16.0.3.

There is a feature toggle 'PARAMETERIZED_LOOKUP_OPTIMIZATION' to enable/disable Performance related changes. 

Resolution

SELECT * FROM cmn_features WHERE code = 'PARAMETERIZED_LOOKUP_OPTIMIZATION'

Value is set to 1. Update it to 0

update cmn_features set enabled = 0 where code = 'PARAMETERIZED_LOOKUP_OPTIMIZATION'

Restart the services afterwards