<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: EXISTS filter on a project report in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486454#M19112</link>
    <description>&lt;P&gt;Hi - If you want an OR with an EXISIT Filter, you add the OR:1: in front like you would with other filters.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;For an example: Here is one for an assignment report. Show all assignments for people in the Creative Services Team or Creative Executive Team whether it is their home team or not.  You will see the second team has the OR:1: in front of it. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=USER&lt;/P&gt;&lt;P&gt;EXISTS:1:ID=FIELD:assignedToID&lt;/P&gt;&lt;P&gt;EXISTS:1:teams:name=Creative Services Team&lt;/P&gt;&lt;P&gt;OR:1:EXISTS:1:$$OBJCODE=USER&lt;/P&gt;&lt;P&gt;OR:1:EXISTS:1:ID=FIELD:assignedToID&lt;/P&gt;&lt;P&gt;OR:1:EXISTS:1:teams:name=Creative Executive Team&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
    <pubDate>Mon, 18 Jul 2022 13:36:29 GMT</pubDate>
    <dc:creator>AnthonyIm</dc:creator>
    <dc:date>2022-07-18T13:36:29Z</dc:date>
    <item>
      <title>EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486446#M19104</link>
      <description>&lt;P&gt;Hi WF Community,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;My attempt at this request pretzeled my brain, so I'm reaching out to the big guns (here) to see if assistance can be provided?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I have a project report, whereby I want to apply an EXISTS filter that will look  the tasks within a project, and if a task name contains "QA", "Proof", or "Quality Assurance" it pulls in that project to the report.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I know going up object levels is usually easier, but wondering if going down (Project down to tasks) will work?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks much.&lt;/P&gt;&lt;P&gt;Nick&lt;/P&gt;</description>
      <pubDate>Thu, 03 Dec 2020 20:06:22 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486446#M19104</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2020-12-03T20:06:22Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486447#M19105</link>
      <description>&lt;P&gt;Hi - so below is the info from my "cheat sheet" when it comes to EXIST filters. (You'll want the moving down the Hierarchy) &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;However, I'm not sure you can do multiple Contains filters. I think I remember reading in a post on Community once, that it doesn't work. But try it. You will just repeat the EXIST filter but change the 1's to 2's (and then to 3's for the third one).&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;Moving Up The Hierarchy&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This is for reports where you want to jump up more than one level. (Like show me projects where the portfolio owner is no longer active)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=[Insert the Object Code for Reference]&lt;/P&gt;&lt;P&gt;EXISTS:1:[Reference Object Type's field that matches current object]=FIELD:[Current Object Type's field that matches reference object]&lt;/P&gt;&lt;P&gt;EXISTS:1:[Field on Reference being filtered]=[Condition]&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Based on my Example:&lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=PORT&lt;/P&gt;&lt;P&gt;EXISTS:1:ID=FIELD:portfolioID&lt;/P&gt;&lt;P&gt;EXISTS:1:owner:isActive=False&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;Showing Items Not Selected&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This is for reports where you want to show items where a multiple-select option is NOT selected (Like projects that are not Digital)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=[Current Object Code]&lt;/P&gt;&lt;P&gt;EXISTS:1:ID=FIELD=ID&lt;/P&gt;&lt;P&gt;EXISTS:1:[Custom Field You Are Filtering On]=[What the TRUE expression would be]&lt;/P&gt;&lt;P&gt;EXISTS:1:$$EXISTSMOD=NOTEXISTS&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Based on my Example:&lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=PROJ&lt;/P&gt;&lt;P&gt;EXISTS:1:ID=FIELD=ID&lt;/P&gt;&lt;P&gt;EXISTS:1:DE:Type of Project=Digital&lt;/P&gt;&lt;P&gt;EXISTS:1:$$EXISTSMOD=NOTEXISTS&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;Moving Down The Hierarchy&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This is for reports where you want to apply a filter based on a many-to-one relationship (Like portfolios that have projects Anthony owns)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=[Insert Object Code for the Collection]&lt;/P&gt;&lt;P&gt;EXISTS:1:[Collection Object Type's field that matches current object]=FIELD:[Current Object Type's field that matches collection object]&lt;/P&gt;&lt;P&gt;EXISTS:1:[Field on Collection being filtered]=[Condition]&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Based on my Example:&lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=PROJ&lt;/P&gt;&lt;P&gt;EXISITS:1:portfolioID=FIELD:ID&lt;/P&gt;&lt;P&gt;EXISTS:1:ownerID=532376910024d8443277c3e46ed5330a&lt;/P&gt;</description>
      <pubDate>Thu, 03 Dec 2020 20:22:28 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486447#M19105</guid>
      <dc:creator>AnthonyIm</dc:creator>
      <dc:date>2020-12-03T20:22:28Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486448#M19106</link>
      <description>&lt;P&gt;Thanks for this, Anthony!  While I was waiting to see if anyone would answer this, it looks like I came up with something similar to what you have listed at the end of your response....&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:1:$$EXISTSMOD=CICONTAINS&lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=TASK&lt;/P&gt;&lt;P&gt;EXISTS:1:name=QA&lt;/P&gt;&lt;P&gt;EXISTS:1:projectID=FIELD:ID&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks for the info, and the note about adding 1, 2, 3 for multiple contains.  I'll let you know if it works.  So far, the above, single-contains, filter works.&lt;/P&gt;</description>
      <pubDate>Thu, 03 Dec 2020 20:37:56 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486448#M19106</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2020-12-03T20:37:56Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486449#M19107</link>
      <description>&lt;P&gt;Hmmm, @Kyna Baker - inactive‚ , do you think Tony Messam might know if I can do multiple contains in an EXISTS filter?  I tried the following and it doesn't seem to be working:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:1:$$EXISTSMOD=CICONTAINS&lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=TASK&lt;/P&gt;&lt;P&gt;EXISTS:1:name=QA&lt;/P&gt;&lt;P&gt;EXISTS:1:projectID=FIELD:ID&lt;/P&gt;&lt;P&gt;EXISTS:2:$$EXISTSMOD=CICONTAINS&lt;/P&gt;&lt;P&gt;EXISTS:2:$$OBJCODE=TASK&lt;/P&gt;&lt;P&gt;EXISTS:2:name=Quality Assurance&lt;/P&gt;&lt;P&gt;EXISTS:2:projectID=FIELD:ID&lt;/P&gt;&lt;P&gt;EXISTS:3:$$EXISTSMOD=CICONTAINS&lt;/P&gt;&lt;P&gt;EXISTS:3:$$OBJCODE=TASK&lt;/P&gt;&lt;P&gt;EXISTS:3:name=Proof&lt;/P&gt;&lt;P&gt;EXISTS:3:projectID=FIELD:ID&lt;/P&gt;</description>
      <pubDate>Thu, 03 Dec 2020 20:45:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486449#M19107</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2020-12-03T20:45:29Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486450#M19108</link>
      <description>&lt;P&gt;That's a good question! @Anthony Messam‚ have you ever run across something like this and can share your EXISTS expertise?? &lt;/P&gt;</description>
      <pubDate>Thu, 03 Dec 2020 21:03:44 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486450#M19108</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2020-12-03T21:03:44Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486451#M19109</link>
      <description>&lt;P&gt;@Nick Valeriote‚ &lt;/P&gt;&lt;P&gt;If I understand the need correctly, I think this can be done without EXISTS. Here's the filter I would use:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;tasks:name=QA&lt;/P&gt;&lt;P&gt;tasks:name_Mod=cicontains&lt;/P&gt;&lt;P&gt;OR:1:tasks:name=Proof&lt;/P&gt;&lt;P&gt;OR:1:tasks:name_Mod=cicontains&lt;/P&gt;&lt;P&gt;OR:2:tasks:name=Quality Assurance&lt;/P&gt;&lt;P&gt;OR:2:tasks:name_Mod=cicontains&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;@Anthony Imgrund‚ 's cheat sheet is great. In the "Moving Down in the Hierarchy" section, I'd add that EXISTS is only needed if you're moving more than one level down or if you're trying to build an "exclusive" report rather than an "inclusive" one.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I would consider this report "inclusive" because you're trying to find all projects that &lt;I&gt;do include&lt;/I&gt; tasks containing those words in the name.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;An "exclusive" report would be one where you're trying to find any projects that have zero tasks with those words in the name. In other words, you want to exclude all projects that do have those tasks.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I hope this helps!&lt;/P&gt;</description>
      <pubDate>Thu, 03 Dec 2020 22:59:10 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486451#M19109</guid>
      <dc:creator>AnthonyMe1</dc:creator>
      <dc:date>2020-12-03T22:59:10Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486452#M19110</link>
      <description>&lt;P&gt;Yes!  That's the money, Tony!!  Thanks for explaining, too.&lt;/P&gt;</description>
      <pubDate>Fri, 04 Dec 2020 19:41:50 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486452#M19110</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2020-12-04T19:41:50Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486453#M19111</link>
      <description>&lt;P&gt;Please forgive me for resurrecting an old thread, but I am trying to find an answer (or a resource to teach me) and this had the best example to use.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If Nick HAD needed to use the EXISTS, what does the structure look like with the OR statement? I am trying to modify a filter on our Projects tab which currently uses exists to list Projects assigned with specific criteria to a user, but I'd like it to include (as an OR) as separate scenario where the next Task AFTER the assigned Task is still not complete (it's assigned to someone else). Trying to catch any that are missing the last step specifically in the user's Project list.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Is it EXISTS:OR:B:_________? (The first set is A). Not sure how this should properly be laid out.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;</description>
      <pubDate>Fri, 15 Jul 2022 21:54:44 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486453#M19111</guid>
      <dc:creator>angielawrence</dc:creator>
      <dc:date>2022-07-15T21:54:44Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486454#M19112</link>
      <description>&lt;P&gt;Hi - If you want an OR with an EXISIT Filter, you add the OR:1: in front like you would with other filters.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;For an example: Here is one for an assignment report. Show all assignments for people in the Creative Services Team or Creative Executive Team whether it is their home team or not.  You will see the second team has the OR:1: in front of it. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:1:$$OBJCODE=USER&lt;/P&gt;&lt;P&gt;EXISTS:1:ID=FIELD:assignedToID&lt;/P&gt;&lt;P&gt;EXISTS:1:teams:name=Creative Services Team&lt;/P&gt;&lt;P&gt;OR:1:EXISTS:1:$$OBJCODE=USER&lt;/P&gt;&lt;P&gt;OR:1:EXISTS:1:ID=FIELD:assignedToID&lt;/P&gt;&lt;P&gt;OR:1:EXISTS:1:teams:name=Creative Executive Team&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Mon, 18 Jul 2022 13:36:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486454#M19112</guid>
      <dc:creator>AnthonyIm</dc:creator>
      <dc:date>2022-07-18T13:36:29Z</dc:date>
    </item>
    <item>
      <title>Re: EXISTS filter on a project report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486455#M19113</link>
      <description>&lt;P&gt;Thank you!&lt;/P&gt;</description>
      <pubDate>Wed, 20 Jul 2022 16:22:47 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exists-filter-on-a-project-report/m-p/486455#M19113</guid>
      <dc:creator>angielawrence</dc:creator>
      <dc:date>2022-07-20T16:22:47Z</dc:date>
    </item>
  </channel>
</rss>

