Text Mode Task Report - Too many table jumps?

[ChristianSi6]

I'm trying to build a task report with the filter below.  The Home Team in bold is causing the filter to fail but the api explorer shows that the references are valid.  Am I trying to go across too many tables?

DE:Key Date=Yes
DE:Key Date_Mod=in
project:convertedOpTaskOriginator:homeTeamID=61006659003b57bb36ef697d14262125
project:convertedOpTaskOriginator:homeTeamID_Mod=in
project:status=CUR
project:status_Mod=in

[skyehansen · Accepted solution]

yes, you are (trying to go across too many tables). Try an exists statement where the project's convertedOpTaskOriginatorID is the same as the user ID and then get to the home team ID from there. Your non-working part of the filter above would translate to:

EXISTS:a:$$OBJCODE=USER

EXISTS:a:ID=FIELD:convertedOpTaskOriginatorID

EXISTS:a:homeTeamID=61006659003b57bb36ef697d14262125