Hi All,
Could you please help me with the below scenario:
In this below example user XXX is part of 10 & 20 Department if user will add department number !=10 as a filter then the result set is 20 - XXX - XXX@ and 20 - ZZZ - ZZZ@.
But user is expecting only 20 - ZZZ - ZZZ@ should be the output as XXX is part of 2 departments
Dept No | Ename | |
---|---|---|
10 | XXX | XXX@ |
10 | YYY | YYY@ |
20 | XXX | XXX@ |
20 | ZZZ | ZZZ@ |
.
User Expected out after applying the filter department number!=10
Dept No | Ename | |
---|---|---|
20 | ZZZ | ZZZ@ |
Hi @mkn23,
For something like this I would double check the where clause in the generated SQL. If we filter out line items where DEPT NO !=10, we are still left with the bottom two line items since the criteria to remove the line items is not satisfied since the DEPT NO for those two equals 20. The user could add a second filter on one of the other columns to remove the other line item e.g. ENAME != XXX.
Please let us know if you have any questions.
Thanks,
Eric