AnsweredAssumed Answered

CA PPM Portlet Filter - Filters all after selecting distinct values

Question asked by Greg.baker.1 on Jul 20, 2017
Latest reply on Jul 25, 2017 by Greg.baker.1

Hi - I am having issues within my portlet filter. I have created a filter (that will pull in distinct quarters). When I go to filter within the portlet, instead of using the filter choices I selected, it defaults to all and pulls in all values instead of what I want.

Screenshots are below:

Here is how it looks when I browse

Here is how it looks when I select multiple items:

After I hit add it only displays 1 item

But after I hit Filter it will display everything

 

Lookup code:

SELECT DISTINCT  @Select:ODF_OBJECT_CODE:OBJ_CODE@,       
        @SELECT:Case when(C_SLOTTED_DATE is not null)
       then Concat(Concat(TO_CHAR(C_SLOTTED_DATE,'YYYY'),' Q'), TO_CHAR(C_SLOTTED_DATE,'Q')) else null end:Quarter_Display@
From ODF_CA_INV
Where ODF_Object_Code = 'project'
     AND @FILTER@

 

Initially I had it as follows, but because the ID field is unique it pulled back in numerous entries for the same quarter.

SELECT DISTINCT  @Select:ID:OBJ_CODE@,       
        @SELECT:Case when(C_SLOTTED_DATE is not null)
       then Concat(Concat(TO_CHAR(C_SLOTTED_DATE,'YYYY'),' Q'), TO_CHAR(C_SLOTTED_DATE,'Q')) else null end:Quarter_Display@
From ODF_CA_INV
Where ODF_Object_Code = 'project'
     AND @FILTER@

 

Would someone be able to provide some guidance?

 

Thanks!

Greg

Outcomes