Filter on lookup does not work

[Martin Snizek]

Hello,

 

we have got a lookup based on query, there is not any parameter or dependency. But the filter on lookup does not work - in browse window of the lookup. Please have you got any idea what can cause this problem?

 

Our Clarity version is: 13.2.0.472 06 14

 

Regards,

Martin

[navzjoshi00]

"But the filter on lookup does not work - in browse window of the lookup" - can you explain a bit more on what does not work ?

Is the query project specific ?

 

NJ

[Martin Snizek]

Hello,

 

lookup is not project specific.

 

Filtering is what does not work, we fill one of fields in filter and click on filter and we get all values as results everytime - they are not limited by the filter

 

Regards,

Martin

[navzjoshi00]

Can you paste the query of the lookup ?

 

Also, on  what type of portlet have you placed the lookup ?

 

NJ

[Martin Snizek]

Portlet is my custom portlet based on query.

 

I used this lookups for OBS: https://communities.ca.com/message/2285995#2285995

 

SELECT @SELECT:obs.obs_id:obs_id@,
@SELECT:obs.obs_name:obs_name@,
@SELECT:obs.RT_OBS:RT_OBS@
FROM
(
SELECT OBS_ID, 
DECODE(RT_OBS,NULL, 'Group/Business/Business Unit/Function/Team/Sub-Team/Sub-SubTeam','Group/Business/Business Unit/Function/Team/Sub-Team/Sub-SubTeam') obs_name
,RT_OBS 
FROM
(
SELECT
  DISTINCT OBS_ID,SUBSTR(OL.OBS_PATH,1,LENGTH(OL.OBS_PATH)-1)RT_OBS,depth
    FROM
     UV_PRJ_RSM_OBS_DETAILS OD,  UV_OBS_LEVELS OL
    WHERE
     OD.OBS_ID = OL.LEVEL1_ID (+)
  AND OD.TABLE_NAME = 'SRM_PROJECTS' AND  OD.TYPE_UNIQUE_NAME = 'obs_project_locations'
)
ORDER BY RT_OBS
)obs

 

And we are trying to filter on RT_OBS field.

 

Regards,

Martin

[Martin Snizek]

Hello,

 

I found the solution, there is missing WHERE @FILTER@ in the lookup query. After adding this to query it works as I expect.

 

Regards,

Martin