Text mode for typeahead fields

[JohnO_]

Ahoy,

I met with a coworker who wanted a report. This happens sometimes.

The report was to have columns for values which appear on an Issue and its resolved Project. One of the columns involved the name which is used on a Typeahead field. I know that typeheads are their own thing Object-wise, so I was unsure how to do this.

Here's the text mode of the column:

displayname=Issue: CTEE - ESL Name

linkedname=CTEE - ESL

namekey=view.relatedcolumn

namekeyargkey.0=CTEE - ESL

namekeyargkey.1=name

querysort=DE:CTEE - ESL:name

valuefield=CTEE - ESL:name

valueformat=customReferenceObjectAsString

I tried just appending a "project:" to the appropriate bits, and it didn't work.

Before I beat my brains out of my head, am I missing something simple with this? (I'm assuming the answer is 'yes.')

-j

[SarahNa]

Hey John,

What type of object report is this on and what object is the typeahead field on?

[JohnO_]

I should have mentioned that, duh.

This report is an Issue Report, but we're referring to the Resolved Project Typeahead field.

[SarahNa]

Hey John,

I don't think there is a way to get to that field through text mode, but you can do a workaround. First, add a calculated field to your project custom form to get the typeaheadfield name:

Once you have that, you can add new field to an issue report without using text mode:

Hope that helps!

[JohnJOSullivan]

I just want to say that I asked you this question in 2021 when I worked for a different company. And when I needed this for something entirely different for my current gig, I came upon this post of mine. So, thank you for being helpful--squared.  

-j

[AnthonyIm]

Thank you, Sarah! Was running into this issue and glad I found this :)