Text mode to see the request queue name (project name) of where a request was converted to a project...in a task report

[TimothyBr]

Hello, 

This one is tough to explain, sorry and thank you in advance! 

We have a task level report where we are trying to get the name of the request queue (project name) in which a request was submitted and converted to a project that the task resides in. 

So overall, we have the task name and then the project name that the task itself resides in. But all of our projects are converted from a request in a separate request queue. We are trying to get that request queue name inside of the task level report.

I have this makes sense! 

[Alex_Di · Accepted solution]

Add a column to your report with this text

displayname=Request Queue Project

textmode=true

valuefield=project:convertedOpTask:project:name

valueformat=HTML

[TimothyBr]

Worked like a charm, thank you! 

Do you know if there is a way to add a text mode filter as well where we can pick a specific one of those projects names? 

Thanks!

[Alex_Di]

You should be able to get that without text mode by using  Converted request project ID 

[TimothyBr]

Thats what I was thinking, but since it is looking at the task in the task report it is not driving any results. I thought I could tweak to the text to make it look at  the project that the task resides in,