Show 'Requested for' in report

porknan
Kilo Contributor

Hi

 

Is there any way to show Requested for column in TASK table report.

 

That would be useful when make gauges or lists from the TASK table.

I didn't manage to find the proper value from Available choice list.

 

requested.PNG

15 REPLIES 15

SnowDEV2
Kilo Expert

please see the below screenshot



find_real_file.png


DhananjayM
Tera Guru

Did you try adding Request for [Request] from the column list? I believe that should be available to you.


If not you can always create a DB view and add the desired column directly into column. Although I think first approach should work for you.



Thanks,


Dhananjay


Brad Tilton
ServiceNow Employee
ServiceNow Employee

The requested for field is actually on the Reqest table so you would have to dot walk to it. You would need to walk to request item --> request --> requested for



Dot-Walking - ServiceNow Wiki



Edit: Completely misread this question. Doug's method is the right one.


randrews
Tera Guru

Yes and no....



the issue here is you want multiple fields... <caller from incident and requested_for from request)



so first scroll down to incident.. then from it add the caller field


now scroll down to catalog task... then dot walk up to requested item.. then to request.. from there add requested for.