Oracle Primavera P6 Professional – Get Filter Savvy

How to Mix the ‘And’ and the ‘Or’ Options in One Filter

Building a filter where all the conditions are either ‘And’ or ‘Or’ between each row is pretty straight forward. However, if you want to mix them up a little it’s not so obvious how you should do that in Oracle Primavera P6 Professional. This article will show you how.

Example: I want to find all the milestones in the project that have a date variance that is not equal to zero. In other words, I want to see any milestone that is now sitting on a date other than its baseline date.

Because there are two types of milestone in Primavera P6 Professional, Start and Finish milestones, it’s often necessary to use the ‘Or’ parameter to get them all. But if you need some ‘And’ conditions too, you need to do some extra thinking.

Here’s how the filter for the above scenario needs to look. Click to enlarge image.

Above: the first two conditions must both be met (the activity is not completed AND variance is not zero), and either of the second conditions can be met; in this case a start or a finish type milestone will meet the criteria.

To indent the Or condition rows under the And condition rows, we inserted a new row below the last ‘And’ condition and assigned the ‘(Any of the following)’ option to it. All subsequent rows will have an Or option in the first column until we insert another ‘(All of the Following)’ option.

Once you get tuned into this method, you can build very powerful and sophisticated filters in Primavera P6 Professional. You do need to think these through before attempting to build them. I generally try to start with all the ‘And’ conditions first, and then put my ‘Or’ options below to avoid confusion and unnecessary complexity.


For more Primavera P6 articles click here

Market Place

Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher and PMI accredited REP. Teach yourself using on-line or book based learning or run your own in-house or public PMI accredited courses.
For 25+ years, APMX has been providing competency based project management training to Fortune 500 companies around the world, applying the principles of project based learning, designed to produce measurable results, generating a favorable “return on training investment”.
See how the TIME - LOCATION - VIEW brings clearness to your work programmes