Clarity

Expand all | Collapse all

Filter on lookup does not work

Jump to Best Answer
  • 1.  Filter on lookup does not work

    Posted 05-04-2015 02:59 AM

    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



  • 2.  Re: Filter on lookup does not work

    Posted 05-04-2015 06:00 AM

    "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



  • 3.  Re: Filter on lookup does not work

    Posted 05-04-2015 06:58 AM

    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



  • 4.  Re: Filter on lookup does not work

    Posted 05-04-2015 09:38 AM

    Can you paste the query of the lookup ?

     

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

     

    NJ



  • 5.  Re: Filter on lookup does not work

    Posted 05-04-2015 10:07 AM

    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



  • 6.  Re: Filter on lookup does not work
    Best Answer

    Posted 05-05-2015 03:18 AM

    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