question Show 'Requested for' in report in SPM forum

Show 'Requested for' in report

porknan — Wed, 17 Sep 2014 12:47:48 GMT

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.

Re: Show 'Requested for' in report

SnowDEV2 — Wed, 17 Sep 2014 13:01:49 GMT

please see the below screenshot

Re: Show 'Requested for' in report

DhananjayM — Wed, 17 Sep 2014 13:01:57 GMT

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

Re: Show 'Requested for' in report

Brad Tilton — Wed, 17 Sep 2014 13:02:55 GMT

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.

Re: Show 'Requested for' in report

randrews — Wed, 17 Sep 2014 13:59:43 GMT

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.

Re: Show 'Requested for' in report

porknan — Mon, 22 Sep 2014 13:31:38 GMT

Hi Doug,

Thanks for this. I must apologise as I am a noob to ServiceNow. Could you offer some more detail please? sorry for being so thick

Re: Show 'Requested for' in report

randrews — Mon, 22 Sep 2014 14:48:57 GMT

not sure what else you need a lot depends on the report you are running... but assuming you are starting from the task table <the only way to get change, request, and incident in one report> you will need to add the fields from the individual tables...

please provide a little more detail on where you are starting your list view/report and i can provide more details on how to get what you need.

Re: Show 'Requested for' in report

porknan — Tue, 23 Sep 2014 09:04:13 GMT

Hi Doug,

E.g. if you open UAM -
Access Request TASKs list.

Re: Show 'Requested for' in report

randrews — Tue, 23 Sep 2014 13:23:28 GMT

Dohhh sorry i was answering how to add them to the filter not the report.. in a list view.. just right click and personalize the list layout

now scroll down until you see "Requested For [Request]" in red and add that

then scroll up to caller[Incident] in red and add that.

Re: Show 'Requested for' in report

porknan — Thu, 25 Sep 2014 08:12:51 GMT

Hi Doug,

I dont see those fields that you mentioned (Requested For [Request]):

Heres what I see:

Re: Show 'Requested for' in report

randrews — Thu, 25 Sep 2014 13:48:36 GMT

ok so this is a list view not a report slightly different...

right click and personalize the list layout

now at the very bottom you should have fields in red.. these are fields from a different table

on the list you should see Caller (incident) in red add this

you should also see reqeusted for (Request) in red add this.

Re: Show 'Requested for' in report

porknan — Thu, 25 Sep 2014 14:07:07 GMT

Cheers Doug.

for some reason, when I look at the list it is blank?..

Re: Show 'Requested for' in report

randrews — Thu, 25 Sep 2014 14:20:32 GMT

ya know i am having all kinds of troubles getting that to work from the task table also...

would you be willing to do it off the catalog task table instead.. if this is JUST for catalog tasks that will work better and MUCH easier...

just create the filters you have on the task table... then

click item and hit the + sign in the middle

click on request and hit the + sign

scroll down to requested for and move it over.

Re: Show 'Requested for' in report

porknan — Fri, 26 Sep 2014 09:26:44 GMT

Hi Doug,

Are you able to provide some screens so I can do this?

Apologies for noob questions! Trying to learn still

Thanks

Stuart

Re: Show 'Requested for' in report

Deepak Ingale1 — Fri, 26 Sep 2014 10:15:02 GMT

Task table does not contain requested for field by default.

Porknan, what reporting you want to do on task table?

all the extended tables like incident, change , request etc has this field "requested for" added with them.

Re: Show 'Requested for' in report

funkjunkie — Fri, 03 Feb 2017 21:17:04 GMT

Check out the response from Rodrigo in this thread:

Reports on Task_SLA table not retrieving custom fields of Incident

there is a sys_property that blocks/allows this.

glide.ui.list.allow_extended_fields

glide.ui.list.allow_extended_fields