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 v...

@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 c...

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 orig...

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 ca...

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.

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 challeng...

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

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...

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 presenta...