How to filter out the users by adding department number filter/by writing calculation?

[mkn23]

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	Email
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	Email
20	ZZZ	ZZZ@

[Eric_Lyons]

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