Text mode to see the request queue name (project name) of where a request was converted to a project...in a task report | Community
Skip to main content
TimothyBr
TimothyBr
Level 4
September 23, 2024
Solved

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

  • September 23, 2024
  • 1 reply
  • 1047 views

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! 

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 Alex_Di

Add a column to your report with this text

 

displayname=Request Queue Project

textmode=true

valuefield=project:convertedOpTask:project:name

valueformat=HTML

1 reply

Alex_Di
Alex_DiAccepted solution
Level 3
September 23, 2024

Add a column to your report with this text

 

displayname=Request Queue Project

textmode=true

valuefield=project:convertedOpTask:project:name

valueformat=HTML

TimothyBr
TimothyBrAuthor
Level 4
September 23, 2024

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
Alex_Di
Level 3
September 23, 2024

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

Terms & ConditionsAccessibility statement

Loading footer...