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: 22.214.171.1242 06 14
"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 ?
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
Can you paste the query of the lookup ?
Also, on what type of portlet have you placed the lookup ?
Portlet is my custom portlet based on query.
I used this lookups for OBS: https://communities.ca.com/message/2285995#2285995
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
UV_PRJ_RSM_OBS_DETAILS OD, UV_OBS_LEVELS OL
OD.OBS_ID = OL.LEVEL1_ID (+)
AND OD.TABLE_NAME = 'SRM_PROJECTS' AND OD.TYPE_UNIQUE_NAME = 'obs_project_locations'
ORDER BY RT_OBS
And we are trying to filter on RT_OBS field.
I found the solution, there is missing WHERE @FILTER@ in the lookup query. After adding this to query it works as I expect.