How can I create a custom filter to compare two columns in an interactive grid?

carkxg

I am trying to create a custom filter on an interactive grid so that the table only shows rows where the value of column A is equal to the value of column B (COLUMN_A = COLUMN_B).

I've created a button, a dynamic action on that button, and am using the following javascript as a template which currently creates a filter on a column with a specific value:

        apex.region("emp").call("addFilter", 
                       { type       : "column" 
                       , columnType : "column" 
                       , columnName : "COLUMN_A" 
                       , operator   : "EQ" 
                       , value : "King" 
                       }); 

This successfully creates a filter for COLUMN_A = 'King'. What I want to do is change the code so that the filter is COLUMN_A = COLUMN_B. You can easily do this for interactive reports using the row filters but I don't see that this is available for interactive grids.

Any idea if this is possible?

Soukaina IDRISSI

I have same question, is there any tip ?

Egyed József

The solution is to add the column (s) calculated in the IG SQL Query Source statement.

Column expression sample:

case when (Column_A = Colun_B) then 'I' else 'N' end EQ_A_B

New column filter: EQ_A_B eq 'I', or EQ_A_B eq 'N'

If IG Editable, the Query Only property of this column must be set to On.

Christian Osvaldo González

Hi, maybe this can help you, make a DA that execute javascript code on the column from the IG

carkxg

Thanks very much for your replies.

@Christian Osvaldo González Your code looks like it will set the value in columns but it is only a filter on the interactive grid that I would like to add

@Egyed József Your suggestion is a good workaround, thanks