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.
