Text Mode snippet for resolving HomeTeamID column to Home Team > Team Name in Report View | Community
Skip to main content
M
Mylah_D
Level 4
November 11, 2020
Solved

Text Mode snippet for resolving HomeTeamID column to Home Team > Team Name in Report View

  • November 11, 2020
  • 4 replies
  • 2461 views

Hello -

Could someone please guide me in converting a column that currently looks up Owner: Home Team ID so that the value it displays the name of the home team rather than the ID?

Owner Home Team ID is a natural field for Views but not the name of that Home team.

I've tried searching the Advanced Reporting documentation and references in the API Explorer and am not sure there is a relationship that can be established, but tbh I'm still wrapping my head around how to work in Text mode.

Naively, I tried (unsuccessfully):

valuefield=owner:homeTeamID:team:name

querysort=owner:homeTeamID

valueformat=HTML

displayname=Home Team Name

linkedname=owner

namekey=view.relatedcolumn

namekeyargkey.0=owner

namekeyargkey.1=homeTeamID

Is it possible to display the Home team name values in the column as desired?

Thanks,

M.

    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 Richard_Le_

    Hi Mylah,

    The below text mode code should do it:

    displayname= Home Team Name

    linkedname=owner

    namekey=view.relatedcolumn

    namekeyargkey.0=owner

    namekeyargkey.1=homeTeam

    namekeyargkey.2=name

    querysort=owner:homeTeam:name

    textmode=true

    valuefield=owner:homeTeam:name

    valueformat=HTML

    Best Regards,

    Rich.

    4 replies

    R
    Community Advisor
    Richard_Le_Community AdvisorAccepted solution
    Community Advisor
    November 11, 2020

    Hi Mylah,

    The below text mode code should do it:

    displayname= Home Team Name

    linkedname=owner

    namekey=view.relatedcolumn

    namekeyargkey.0=owner

    namekeyargkey.1=homeTeam

    namekeyargkey.2=name

    querysort=owner:homeTeam:name

    textmode=true

    valuefield=owner:homeTeam:name

    valueformat=HTML

    Best Regards,

    Rich.

      M
      Mylah_DAuthor
      Level 4
      November 11, 2020

      That worked! Thanks!

      kynabaker16
      Adobe Employee
      kynabaker16Adobe Employee
      Adobe Employee
      November 11, 2020

      @Richard Leek‚ - wow! That might win for fastest answer of the week! That was amazing!

        S
        SandyGr
        Level 2
        December 9, 2021

        Hello - I am trying to do this as well using the answer above but it is not returning any values. I want to display the 'Name' that is tied to the Home Team ID. When I do that though the value returned is null. ANY help is appreciated.

        displayname= Home Team Name

        linkedname=owner

        namekey=view.relatedcolumn

        namekeyargkey.0=owner

        namekeyargkey.1=homeTeam

        namekeyargkey.2=name

        querysort=owner:homeTeam:name

        textmode=true

        valuefield=owner:homeTeam:name

        valueformat=HTML

        C
        ChloeRo
        Level 4
        December 9, 2021

        Hi Sandy!

        The codes can differ depending on the type of report you're using. I've cleaned up the code to only 4 lines in all of these examples.

        In the task report, we have to specify that we're jumping a level to see the project owner (tasks don't have owners - only primary assignees). The task report code would be:

        displayname=Home Team Name

        textmode=true

        valuefield=project:owner:homeTeam:name

        valueformat=HTML

        --------------

        The project report code would be:

        displayname=Home Team Name

        textmode=true

        valuefield=owner:homeTeam:name

        valueformat=HTML

        --------------

        To add a third possibility into here - if you're using a task report and actually want to grab the task's primary assignee's home team, this would be the code:

        displayname=Home Team Name

        textmode=true

        valuefield=assignedTo:homeTeam:name

        valueformat=HTML

        --------------

        If you're not seeing results with these codes, it's also possible that the user doesn't have a Home Team ID.

          S
          SandyGr
          Level 2
          December 9, 2021

          How do I heart this!!! Your last example was exactly what I needed. Thank you😊 so much!

            kynabaker16
            Adobe Employee
            kynabaker16Adobe Employee
            Adobe Employee
            December 9, 2021

            AH. My bad. Sorry, Sandy. But now you know for future questions that you post. :) Huge props to Chloe for sharing all her knowledge!

              Terms & ConditionsAccessibility statement

              Loading footer...