Forum

Filter on DESCRIPTI...
 
Notifications
Retirer tout

Filter on DESCRIPTION behaves incorrectly

4 Posts
2 Utilisateurs
0 Reactions
1,187 Vu
(@dieperie)
Posts: 47
Active Member
Début du sujet
 
[#9522]

Hello,
Using the filter feature, I would like to display only activities with specific Description or ID.
In reality is displays additional activities. The activities that do not belong to the selection have no ID on the Gantt.
Please see all three attachments (Filter selection, result from V11.1.5 and result from V12.1.5)
Behaviour seen on versions starting V11.2.x and V11.3.x
Many thank for your support.


 
Posté : 13 Juil PM 12:077
(@babynus)
Posts: 14952
Membre Admin
 

Hi,
Can you post full definition of your filter.
It ssems you use some OR filters. If you also use AND, result may not be exactly what you expect as there is a priority : AND comes before OR
This means that isf your filter is 
A AND B OR C OR D
you will get sale as 
( A AND B ) OR C OR D
and not
A AND ( B OR C OR D )


 
Posté : 8 Août PM 18:088
(@dieperie)
Posts: 47
Active Member
Début du sujet
 

Hi,
Thank you for asking. I use many different filters including OR and AND clauses. They all work fine, except with the new versions. Attached you will find an example that works fine, but not with new version. In this post I also demonstrated that using OR's on ID's, in the new versions it shows more than it should.


 
Posté : 8 Août PM 23:088
(@babynus)
Posts: 14952
Membre Admin
 

You have
name starts by 'A' OR name contains 'B' OR name contains 'C' OR name contains 'D' OR name contains 'E' AND wbs contains 'X' or wbs contains 'Y'
I thing you expect
(name starts by 'A' OR name contains 'B' OR name contains 'C' OR name contains 'D' OR name contains 'E') AND (wbs contains 'X' or wbs contains 'Y')
but you won't get that as AND has priority to OR (like multiplication has priority to addintion)
You will get
name starts by 'A' OR name contains 'B' OR name contains 'C' OR name contains 'D' OR (name contains 'E' AND wbs contains 'X') or wbs contains 'Y'

We haven't  changes filters management in new version.

We plan to impove Filters feature (under analysis with Users QLUB) to have possibility to add parenthesis, but this is not so easy

Note that in current version, to get 
(A OR B) AND (C OR D)
you must create filter
A AND C OR A AND D OR B AND C OR B AND D
(distributivity)
 


 
Posté : 9 Août AM 11:088
Share:
Retour en haut