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 Transaction | Other fiels |
|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
Then each transaction has 1 or >1 attributes (stored in another table
| ID Transaction | Attribute |
|---|
| 1 | q1 |
| 1 | q2 |
| 1 | q3 |
| 2 | q1 |
| 2 | q3 |
| 2 | q4 |
| 3 | q1 |
| 3 | q4 |
| 4 | q1 |
| 5 | q5 |
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 Transaction | NoQ1Flag | NoQ2Flag | NoQ3Flag | NoQ4Flag | NoQ5Flag | Other fields |
|---|
| 1 | | | | 1 | 1 | |
| 2 | | 1 | | | 1 | |
| 3 | | 1 | 1 | | 1 | |
| 4 | | 1 | 1 | 1 | 1 | |
| 5 | 1 | 1 | 1 | 1 | | |
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?
