Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

AnthonyMe1
AnthonyMe1
Offline

Badges

Badges
0

Accepted Solutions

Accepted Solutions
2

Likes Received

Likes Received
11

Posts

Posts
9

Discussions

Discussions
0

Questions

Questions
9

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by AnthonyMe1
Customize the badges you want to showcase on your profile
Re: Project Subscription Report - Workfront 12-03-2021
Hi Kasey, This is something that can be done without EXISTS. In the unsupported version of the API Explorer, you’ll find a project-level collection called Subscribes, within which you’ll find a Subscriber ID field. That’s what is referenced in the text mode below. Things found in the unsupported version of the API are safe to use and reference, but they are subject to change or removal. For now, this one seems to work well. Below is the text mode for a filter on a project report. You can add the...

Views

19

Like

1

Replies

0
Re: EXISTS filter on a project report - Workfront 03-12-2020
@Nick Valeriote‚ If I understand the need correctly, I think this can be done without EXISTS. Here's the filter I would use: tasks:name=QAtasks:name_Mod=cicontainsOR:1:tasks:name=ProofOR:1:tasks:name_Mod=cicontainsOR:2:tasks:name=Quality AssuranceOR:2:tasks:name_Mod=cicontains @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 rath...

Views

94

Likes

0

Replies

0
Re: Project Report based on Other Teams List - Workfront 09-09-2020
I've come up with two examples of code that don't cause a "Whoops" error, which is usually a good sign when using EXISTS, but they also don't return any results. I think the problem is the second line in each example. It seems that linking based on a field in a collection (project users) of the originating object (project) just doesn't work. I can't think of any way to write this without having to rely on the Project Users collection. In case anyone is curious and wants to see if they can wrestl...

Views

29

Like

1

Replies

0
Re: Leap Session Q&A - EXISTS Filters - Workfront 11-08-2020
This session specifically applies to filters. However, there was a separate session presented by my colleague Jason Webre that covers a concept known as Collections. His session focuses on columns in a report. The title of his session is Collections: A Whole New World of Advanced Reporting and it can be found on the business track on the Leap site.

Views

54

Likes

0

Replies

1
Re: Leap Session Q&A - EXISTS Filters - Workfront 09-07-2020
It works for me exactly as written. In the past, I've had experiences where existing reports are almost "corrupted" and adding text mode filters to them doesn't work. I'd try creating a brand new report from scratch and paste this text in to see if that works.

Views

54

Like

1

Replies

0
Re: Leap Session Q&A - EXISTS Filters - Workfront 09-07-2020
Michelle,‚To answer your first question, I use EXISTS only when faced with one of the three limitations mentioned in the presentation. I'll list the three limitations and try to help clarify each one. I find it a little difficult to put it into writing, so I am actually thankful that you're challenging me to do so.‚Jumping multiple object tablesWithout EXISTS, filters in reports can only make one jump away from the object your report is based on. For example, in a task report it is one jump to g...

Views

54

Like

1

Replies

0
Re: Leap Session Q&A - EXISTS Filters - Workfront 09-07-2020
Nick, This one can actually be done without an EXISTS filter. It still requires text mode, though. Here's what it would look like: hours:actualCost=0hours:actualCost_Mod=cieq

Views

54

Likes

0

Replies

4
Re: Leap Session Q&A - EXISTS Filters - Workfront 02-07-2020
Hi Skye,‚Good to hear from you.‚In the two scenarios you laid out, you're correct in mentioning that there is a custom form collection to tap into. However, only one of the two requires and EXISTS statement. In order to find all projects that use a certain custom form, you will have to use text mode to filter on the objectCategories collection. Here's what that would look like, just replace the sample category ID with your real one:‚objectCategories:categoryID=abc123objectCategories:categoryID_M...

Views

54

Likes

2

Replies

0
Leap Session Q&A - EXISTS Filters - Workfront 02-07-2020
For this year's leap, my session was about using EXISTS filters in reports. For those of you that have had the chance to watch, I hope it was informative. For anyone who hasn't had the chance to watch yet, you can find it at this link. If you have any questions about anything I shared in my presentation, let's discuss them here. I'm looking forward to hearing from you!

Views

54

Likes

5

Replies

13