Text Mode Task Report - Too many table jumps? | Community
Skip to main content
C
ChristianSi6
New Participant
May 17, 2024
Solved

Text Mode Task Report - Too many table jumps?

  • May 17, 2024
  • 1 reply
  • 520 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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

1 reply

skyehansen
skyehansenAccepted solution
New Participant
May 19, 2024

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

    Terms & ConditionsAccessibility statement

    Loading footer...