01-10-2020 12:41 AM
If I use the logical operator OR to filter my entities in the Shell it dose not work correctly.
<Entity.Filters> <Filter Id="EntidadesApp" Sql="ent_enable=1 OR ent_enable=0 " IsDefault="True" /> </Entity.Filters>
Instead If I use the operator AND it works well.
Why is that happening?
Solved! Go to Solution.
01-15-2020 02:22 AM - edited 01-15-2020 02:24 AM
I've just tested filter queries like this and all of them worked fine:
Sql="sacc = 'IN' AND source = 'PP'"
(4 rows returned)
Sql="sacc = 'IN' OR sacc = 'AC'"
(8 rows returned)
Sql="(sacc = 'IN' OR sacc = 'AC') AND source = 'AMP'"
(2 rows returned)
I would recommend tracing the database queries and see what query makes it into the database. Then test this qurey for results.
01-21-2020 05:36 AM
My problem solves with parenthesis
Sql="(sacc = 'IN' OR sacc = 'AC')
It's because I also are using working areas. This needs the parenthesis to get the correct filter.