{"id":7905,"date":"2012-11-27t10:06:36","date_gmt":"2012-11-27t15:06:36","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=1555"},"modified":"2019-04-05t13:05:54","modified_gmt":"2019-04-05t17:05:54","slug":"mixing-and-and-or-options-in-primavera-p6-filters","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/","title":{"rendered":"quick tip: mixing and and or options in primavera p6 filters"},"content":{"rendered":"<p>building a filter where all the conditions are either &#8216;and&#8217; or \u2018or\u2019 between each row is pretty straightforward. however, if you want to mix them up a little its not so obvious how you should do that in oracle primavera p6 professional. this quick tip will show you how.<\/p>\n<p>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.<\/p>\n<p>because there are two types of milestone in primavera p6 professional, start and finish milestones, it\u2019s often necessary to use the \u2018or\u2019 parameter to get them all. but if you need some \u2018and\u2019 conditions too, you need to do some extra thinking.<\/p>\n<p>here\u2019s how the filter for the above scenario needs to look.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"variance milestone filter\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/variance-milestone-filter.png\" alt=\"variance milestone filter\" width=\"657\" height=\"349\" \/><\/p>\n<p>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.<\/p>\n<p>to indent the or condition rows under the and condition rows, we inserted a new row below the last \u2018and\u2019 condition and assigned the \u2018(any of the following)\u2019 option to it. all subsequent rows will have an or option in the first column until we insert another \u2018(all of the following)\u2019 option.<\/p>\n<p>once you get tuned into this method, you can build very powerful and sophisticated filters. you do need to think these through before attempting to build them. i generally try to start with all the \u2018and\u2019 conditions first, and then put my \u2018or\u2019 options below to avoid confusion and unnecessary complexity.<\/p>\n<p><span class=\"hs-cta-wrapper\" id=\"hs-cta-wrapper-f294820d-ec99-42ac-be87-191d1afde26b\"><span class=\"hs-cta-node hs-cta-f294820d-ec99-42ac-be87-191d1afde26b\" id=\"hs-cta-f294820d-ec99-42ac-be87-191d1afde26b\"><!--[if lte ie 8]>\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n<![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/297539\/f294820d-ec99-42ac-be87-191d1afde26b\" ><img decoding=\"async\" class=\"hs-cta-img\" id=\"hs-cta-img-f294820d-ec99-42ac-be87-191d1afde26b\" style=\"border-width:0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/297539\/f294820d-ec99-42ac-be87-191d1afde26b.png\"  alt=\"new call-to-action\"\/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(297539, 'f294820d-ec99-42ac-be87-191d1afde26b', {}); <\/script><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>building a filter where all the conditions are either &#8216;and&#8217; or \u2018or\u2019 between each row is pretty straightforward. however, if&#8230;<\/p>\n","protected":false},"author":22,"featured_media":6948,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[55],"tags":[183,25,184],"content-topics":[],"class_list":["post-7905","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-primavera-p6-tutorials","tag-filters","tag-layouts-gantt","tag-primavera-p6-quick-tips"],"acf":[],"yoast_head":"<!-- this site is optimized with the yoast seo premium plugin v24.0 (yoast seo v24.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>quick tip: mixing and and or options in primavera p6 filters<\/title>\n<meta name=\"description\" content=\"&quot;i want to find all the milestones in the project that have a date variance that is not equal to zero.&quot; here&#039;s a quick tip on how to do that.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/\" \/>\n<meta property=\"og:locale\" content=\"en_us\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"quick tip: mixing and and or options in primavera p6 filters\" \/>\n<meta property=\"og:description\" content=\"&quot;i want to find all the milestones in the project that have a date variance that is not equal to zero.&quot; here&#039;s a quick tip on how to do that.\" \/>\n<meta property=\"og:url\" content=\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/\" \/>\n<meta property=\"og:site_name\" content=\"世界杯2022亚洲比赛时间
\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/planacademy\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-27t15:06:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-05t17:05:54+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"neil smith\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@planacademy\" \/>\n<meta name=\"twitter:site\" content=\"@planacademy\" \/>\n<meta name=\"twitter:label1\" content=\"written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"neil smith\" \/>\n\t<meta name=\"twitter:label2\" content=\"est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"article\",\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#article\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/\"},\"author\":{\"name\":\"neil smith\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/1bf70bdcbefb3ecaa29a2f46737419d2\"},\"headline\":\"quick tip: mixing and and or options in primavera p6 filters\",\"datepublished\":\"2012-11-27t15:06:36+00:00\",\"datemodified\":\"2019-04-05t17:05:54+00:00\",\"mainentityofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/\"},\"wordcount\":303,\"commentcount\":10,\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg\",\"keywords\":[\"filters\",\"layouts &amp; gantt\",\"quick tips\"],\"articlesection\":[\"primavera p6 tutorials\"],\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"commentaction\",\"name\":\"comment\",\"target\":[\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#respond\"]}]},{\"@type\":\"webpage\",\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/\",\"url\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/\",\"name\":\"quick tip: mixing and and or options in primavera p6 filters\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/#website\"},\"primaryimageofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg\",\"datepublished\":\"2012-11-27t15:06:36+00:00\",\"datemodified\":\"2019-04-05t17:05:54+00:00\",\"description\":\"\\\"i want to find all the milestones in the project that have a date variance that is not equal to zero.\\\" here's a quick tip on how to do that.\",\"breadcrumb\":{\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#breadcrumb\"},\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"readaction\",\"target\":[\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/\"]}]},{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg\",\"width\":350,\"height\":350,\"caption\":\"quick tip: mixing and and or options in primavera p6 filters\"},{\"@type\":\"breadcrumblist\",\"@id\":\"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#breadcrumb\",\"itemlistelement\":[{\"@type\":\"listitem\",\"position\":1,\"name\":\"blog\",\"item\":\"\/\/www.deco-dalles.com\/\"},{\"@type\":\"listitem\",\"position\":2,\"name\":\"quick tip: mixing and and or options in primavera p6 filters\"}]},{\"@type\":\"website\",\"@id\":\"\/\/www.deco-dalles.com\/#website\",\"url\":\"\/\/www.deco-dalles.com\/\",\"name\":\"世界杯2022亚洲比赛时间
\",\"description\":\"project controls training &amp; courses\",\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"potentialaction\":[{\"@type\":\"searchaction\",\"target\":{\"@type\":\"entrypoint\",\"urltemplate\":\"\/\/www.deco-dalles.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"propertyvaluespecification\",\"valuerequired\":true,\"valuename\":\"search_term_string\"}}],\"inlanguage\":\"en-ca\"},{\"@type\":\"organization\",\"@id\":\"\/\/www.deco-dalles.com\/#organization\",\"name\":\"世界杯2022亚洲比赛时间
\",\"url\":\"\/\/www.deco-dalles.com\/\",\"logo\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"width\":500,\"height\":159,\"caption\":\"世界杯2022亚洲比赛时间
\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\"},\"sameas\":[\"https:\/\/www.facebook.com\/planacademy\",\"https:\/\/x.com\/planacademy\",\"https:\/\/www.linkedin.com\/company\/plan-academy\",\"https:\/\/www.youtube.com\/planacademy\"]},{\"@type\":\"person\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/1bf70bdcbefb3ecaa29a2f46737419d2\",\"name\":\"neil smith\",\"image\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4c08fd4e8106bb810bba938053f58001?s=96&d=mm&r=pg\",\"contenturl\":\"https:\/\/secure.gravatar.com\/avatar\/4c08fd4e8106bb810bba938053f58001?s=96&d=mm&r=pg\",\"caption\":\"neil smith\"},\"description\":\"neil, a senior consultant at ten six consulting, has over 21 years experience in the earned value management and project management field working across many industries including aerospace and defense, biotech, software development and government agencies. he is an expert in in implementing oracle primavera p6, deltek cobra and winisght and has developed and delivered training in all three products. neil has worked with various evm software products and project management tools since the early 1990\u2019s. he has done extensive work on enterprise tool implementation, program setup, process development and training development for evms.\",\"url\":\"\/\/www.deco-dalles.com\/author\/nsmith\/\"}]}<\/script>\n<!-- \/ yoast seo premium plugin. -->","yoast_head_json":{"title":"quick tip: mixing and and or options in primavera p6 filters","description":"\"i want to find all the milestones in the project that have a date variance that is not equal to zero.\" here's a quick tip on how to do that.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/","og_locale":"en_us","og_type":"article","og_title":"quick tip: mixing and and or options in primavera p6 filters","og_description":"\"i want to find all the milestones in the project that have a date variance that is not equal to zero.\" here's a quick tip on how to do that.","og_url":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/","og_site_name":"世界杯2022亚洲比赛时间
","article_publisher":"https:\/\/www.facebook.com\/planacademy","article_published_time":"2012-11-27t15:06:36+00:00","article_modified_time":"2019-04-05t17:05:54+00:00","og_image":[{"width":350,"height":350,"url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg","type":"image\/jpeg"}],"author":"neil smith","twitter_card":"summary_large_image","twitter_creator":"@planacademy","twitter_site":"@planacademy","twitter_misc":{"written by":"neil smith","est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"article","@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#article","ispartof":{"@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/"},"author":{"name":"neil smith","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/1bf70bdcbefb3ecaa29a2f46737419d2"},"headline":"quick tip: mixing and and or options in primavera p6 filters","datepublished":"2012-11-27t15:06:36+00:00","datemodified":"2019-04-05t17:05:54+00:00","mainentityofpage":{"@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/"},"wordcount":303,"commentcount":10,"publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"image":{"@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg","keywords":["filters","layouts &amp; gantt","quick tips"],"articlesection":["primavera p6 tutorials"],"inlanguage":"en-ca","potentialaction":[{"@type":"commentaction","name":"comment","target":["\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#respond"]}]},{"@type":"webpage","@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/","url":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/","name":"quick tip: mixing and and or options in primavera p6 filters","ispartof":{"@id":"\/\/www.deco-dalles.com\/#website"},"primaryimageofpage":{"@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage"},"image":{"@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg","datepublished":"2012-11-27t15:06:36+00:00","datemodified":"2019-04-05t17:05:54+00:00","description":"\"i want to find all the milestones in the project that have a date variance that is not equal to zero.\" here's a quick tip on how to do that.","breadcrumb":{"@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#breadcrumb"},"inlanguage":"en-ca","potentialaction":[{"@type":"readaction","target":["\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/"]}]},{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#primaryimage","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/11\/complex-funnel1.jpg","width":350,"height":350,"caption":"quick tip: mixing and and or options in primavera p6 filters"},{"@type":"breadcrumblist","@id":"\/\/www.deco-dalles.com\/mixing-and-and-or-options-in-primavera-p6-filters\/#breadcrumb","itemlistelement":[{"@type":"listitem","position":1,"name":"blog","item":"\/\/www.deco-dalles.com\/"},{"@type":"listitem","position":2,"name":"quick tip: mixing and and or options in primavera p6 filters"}]},{"@type":"website","@id":"\/\/www.deco-dalles.com\/#website","url":"\/\/www.deco-dalles.com\/","name":"世界杯2022亚洲比赛时间
","description":"project controls training &amp; courses","publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"potentialaction":[{"@type":"searchaction","target":{"@type":"entrypoint","urltemplate":"\/\/www.deco-dalles.com\/?s={search_term_string}"},"query-input":{"@type":"propertyvaluespecification","valuerequired":true,"valuename":"search_term_string"}}],"inlanguage":"en-ca"},{"@type":"organization","@id":"\/\/www.deco-dalles.com\/#organization","name":"世界杯2022亚洲比赛时间
","url":"\/\/www.deco-dalles.com\/","logo":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","width":500,"height":159,"caption":"世界杯2022亚洲比赛时间
"},"image":{"@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/"},"sameas":["https:\/\/www.facebook.com\/planacademy","https:\/\/x.com\/planacademy","https:\/\/www.linkedin.com\/company\/plan-academy","https:\/\/www.youtube.com\/planacademy"]},{"@type":"person","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/1bf70bdcbefb3ecaa29a2f46737419d2","name":"neil smith","image":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4c08fd4e8106bb810bba938053f58001?s=96&d=mm&r=pg","contenturl":"https:\/\/secure.gravatar.com\/avatar\/4c08fd4e8106bb810bba938053f58001?s=96&d=mm&r=pg","caption":"neil smith"},"description":"neil, a senior consultant at ten six consulting, has over 21 years experience in the earned value management and project management field working across many industries including aerospace and defense, biotech, software development and government agencies. he is an expert in in implementing oracle primavera p6, deltek cobra and winisght and has developed and delivered training in all three products. neil has worked with various evm software products and project management tools since the early 1990\u2019s. he has done extensive work on enterprise tool implementation, program setup, process development and training development for evms.","url":"\/\/www.deco-dalles.com\/author\/nsmith\/"}]}},"_links":{"self":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7905","targethints":{"allow":["get"]}}],"collection":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/comments?post=7905"}],"version-history":[{"count":0,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7905\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media\/6948"}],"wp:attachment":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media?parent=7905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/categories?post=7905"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/tags?post=7905"},{"taxonomy":"content-topics","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/content-topics?post=7905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}