Expand my Community achievements bar.

SOLVED

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

Avatar

Level 4

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! 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 1

Add a column to your report with this text

 

displayname=Request Queue Project

textmode=true

valuefield=project:convertedOpTask:project:name

valueformat=HTML

View solution in original post

4 Replies

Avatar

Correct answer by
Level 1

Add a column to your report with this text

 

displayname=Request Queue Project

textmode=true

valuefield=project:convertedOpTask:project:name

valueformat=HTML

Avatar

Level 4

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!

Avatar

Level 1

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

Avatar

Level 4

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,