Quick Filter which enables a select with an "AND" Condition (as opposed to the traditional 'OR')
Hello,
I am looking for some functionality, which i envison being a type or class of 'Quick Filter'. This quick filter would enable an AND as opposed to the 'OR' which is the standard functionality (within that particular quick filters own values).
Here is an example of my requirement which illustrates what i'm asking for:
I have some sales document data
[Sales Doc] [Line No] [Product]
1000 10 X
1000 20 Y
1000 30 Z
2000 10 A
2000 20 B
2000 30 Z
3000 10 X
3000 20 A
3000 30 Z
etc....
My requirement is to have a user be able to select products (A user could select any combination of products), so in our example the pool of products is [A,B,X,Y,Z], however there are hundreds of products in reality (which means innumerable combinations).
When the User selects Product X AND Z, i expect the results to be Sales Lines that include X AND Z, so in this case
[Sales Doc] [Line No] [Product]
1000 10 X
1000 30 Z
3000 10 X
3000 30 Z
Notice that Sales Doc 2000 is not listed as it doesn't contain BOTH products.
I haven't figured out how to solve this problem with standard Card functionality, hence the ask.
Thank you!
