1 Reply Latest reply on Jul 22, 2018 12:24 PM by Vasu choudhury

    Pass Different Conditions dynamically

    Vasu choudhury

      Hello,

       

      Need your help to implement the below functionality..I think we can achieve this with some work around, but not sure.

       

      We have aggregated the data with some business rules and populated the value as "All" for Location, Name & Category fields. It's not necessary that the count displayed at month level for "All" should match with Non"All" values.

       

      Default Filter conditions : Category=All Loc=All ; Name=All ;

       

      Scenario 1: Category=All ; Loc=All ; Name=Daniel

      When Name=Daniel is selected then

      1. Location filter should grayed out or user should not allow to select any value from Location filter

       

      Scenario 2: Category=All ; Loc=Columbus ; Name=All

      When Loc=Columbus is selected then

      1. Name filter should grayed out or user should not allow to select any value from Name filter

       

      Scenario 3: Category=All ; Loc=All ; Name=All

      Below is the expected result set. Which should be derived from the where clause as..

      select month, sum(qty)

      where Category=Aland Loc=All  and Name <>All( which is.. Name in (Daniel, Stella))

      group by month

      Scenario 4: Category=All ; Loc=All ; Name=Stella

      Below is the expected result set. Which is derived from the where clause as..

      select month, sum(qty)

      where Category=Aland Loc=All  and Name=Stella

      group by month

      Scenario 4: Category=Coloring ; Loc=All ; Name=All

      Below is the expected result set. Which is derived from the where clause as..

      select month, sum(qty)

      where Category=Coloring and Loc=All  and Name<> All( which is.. Name in (Daniel, Stella))

      group by month

       

      Note: We have approx >100 values in each field.

       

       

      Thanks!

      Vasu.