Show Service Catalog Variables in a Task View

[ajlabate]

I want to be able to let my itil users see the variables related to the task they have been assigned when they view "My Work" or "My Groups Work".   If they have many tasks assigned and need to find a particular one, there's no easy method because the data is not in the task table.   What can be done to get these visible in their views?

[gyedwab]

Hi Anthony,

I'm not aware of a way to do that using ServiceNow's native reporting. In recent releases (can't remember if it's introduced in Dublin or Eureka), you can pull *fields* from extended tables, but it doesn't look like variables are available.

There is a way to do this with a third party reporting tool called Explore Analytics (full disclosure: it's where I work now).

Here's a sample list showing the first 1500 rows (I've published it "public", normally it would require a login):

Test Task List

To generate that list, I just selected that I wanted to add a column called "variables":

and specified the variable I wanted (in this case, short description):

What this does allow you to do is to report on variables as well... here's an example with reporting on Catalog variables:

https://my.exploreanalytics.com/pub/view/cb3e82cfbdd14911b8b8e5a5f0dc0204

And can then publish to ServiceNow dashboards.

[Wade Clairmont]

Anthony,   I am guessing from your question that this is the same issue that we had a while ago.

To ensure your request variables are passed through RITM to TASK, open the associated workflow to that CI, checkout the workflow, double click to open the catalog task and add the variables on task form.   Update, publish and there you go!

And make sure that in your variable you have Visible on bundles, guides, elsewhere and summaries on.

Hope that helps.

[ajlabate]

Thank you for the response. I have done this already and the variables do appear on the Task form. What I'm trying to figure out is if there is a way I can make those variables visible when they select "My Work" or "My Groups Work" main view, and be able to search under a specific variable as a column in the view.

>>> Wade Clairmont <community-no-reply@servicenow.com> 7/24/2014 11:18 AM >>>

( https://community.servicenow.com/?et=watches.email.thread )

Show Service Catalog Variables in a Task View

reply from Wade Clairmont ( https://community.servicenow.com/people/wclairmont?et=watches.email.thread ) in Support - View the full discussion ( https://community.servicenow.com/message/713150?et=watches.email.thread#713150 )

Anthony, I am guessing from your question that this is the same issue that we had a while ago.

To ensure your request variables are passed through RITM to TASK, open the associated workflow to that CI, checkout the workflow, double click to open the catalog task and add the variables on task form. Update, publish and there you go!

Hope that helps.

Reply to this message by going to ServiceNow ( https://community.servicenow.com/message/713150?et=watches.email.thread#713150 )

Start a new discussion in Support at ServiceNow ( https://community.servicenow.com/choose-container.jspa?contentType=1&containerType=14&container=2008&et=watches.email.thread )

Following Show Service Catalog Variables in a Task View ( https://community.servicenow.com/message/713150?et=watches.email.thread#713150 ) in these streams: Inbox

( https://www.facebook.com/servicenow ) ( https://twitter.com/servicenow ) ( http://www.linkedin.com/company/servicenow ) ( http://www.servicenow.com )

"This electronic mail message contains information which may be confidential, privileged and protected from further disclosure. Such information relates to and is used for all purposes outlined in the statutes below, including Peer Review, Performance Improvement, Quality Assurance and Claims Management and Handling functions and/or Attorney-Client Communications. It is being produced within the scope of all Georgia and Federal laws governing record confidentiality, including (but not limited to) Official Code of Georgia Annotated Sections 31-7-15; 31-7-130; 31-7-131; 31-7-132; 31-7-133; 31-7-140; 31-7-143.

If you are not the intended recipient, please be aware that any disclosure, photocopying, distribution or use of the contents of the received information is prohibited. If you have received this e-mail in error, please reply to the sender immediately and permanently delete this message and all copies of it. Thank you.

Communication of electronic protected health information (ePHI) is protected under the Health Insurance Portability and Accountability Act (HIPAA) Act of 1996. Electronic mail (e-mail) communication is not encrypted or secure. The HIPAA Security Rule allows for patients to initiate communication of personal health information over this medium and for providers to respond accordingly with the understanding that privacy of communication is not guaranteed."

[Shane11]

Hi Anthony,

If you're thinking about upgrading at some point Eureka allows you to use variables in the filter builder for catalog tables, but you still can't display variables as columns. You can't display them because each request can have different columns it would be difficult to show them in any sane way.

The only way I know to accomplish exactly what you're looking for would be to create new columns to store the data to display or search on and use a business rule to fill it in.