Dependent Page Filters

I have a view published with 

        list-1 in rows

        list-2 in columns

        list-3 in pages

        list-4 in pages.

The dropdown for list-4 is dependent on item selection from list-3 and vice versa.

Filters are created for that but when applied, I couldn't see the option of Current context.

 

For Example,

List 3 has A,B items

List 4 has a,b,c items

 

When user selects 'A' from list 3 selector, then the list-4 selector should show 'a', 'b' for selection but not 'c'.

When user selects 'B' from list 3 selector, then the list-4 selector should show 'b', 'c' for selection but not 'a'.

 

Filter is the Boolean input for list 3 * list 4

There is no relationship between list3 and list4 except for the input filter.

 

Is there a way to achieve it without creating a hierarchy list between list3 and list4?

Best Answer

  • Misbah
    Answer ✓

    @Akhilesh9025 

     

    You will have to create Valid Combination List of (List 3 and List 4)

    Once you have that list create a SYS Module based on Valid Combination list and map the items. It can be many to many mapping

    Create two properties in Valid Combination list - one formatted as L3 and another L4. Write the formula and pull the data from SYS module into properties

    Last step would be to enable dependent dropdown in the Filter line item

     

    Misbah

Answers