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?