0 Replies Latest reply: Jun 19, 2018 9:25 AM by Sergii Karandin RSS

    Selection NOT values (using AND logic)

    Sergii Karandin

      Hello everyone, I came across the following task and cant quite figure it out, would appreciate any help

       

      So there's a transaction table like:

       

      ID TransactionOther fiels
      1
      2
      3
      4
      5

       

      Then each transaction has 1 or >1 attributes (stored in another table

      ID TransactionAttribute
      1q1
      1q2
      1q3
      2q1
      2q3
      2q4
      3q1
      3q4
      4q1
      5q5

       

      The task is to create a tool for selection Transactions which does NOT have a certain set of attributes. So to say, if I select "No q1", I see only ID Transaction = 5. Moreover, if I select "No q4" and "No q5", they work on AND logic, so I see only Transactions ID = {1, 4, 5}.

       

      I came across following solution:

      join flags to Transactions table like that, and then made 5 different filters in the interface

      ID TransactionNoQ1FlagNoQ2FlagNoQ3FlagNoQ4FlagNoQ5FlagOther fields
      111
      211
      3111
      41111
      51111

      The only problem is that there could by a LOT of those attributes, and it seems like bad design to make a button for each of them.

       

      Is there any chance I can do this differently?