How to add Variables to List View on Task Table?

Community Alums · ‎07-31-2020

On the 'My Groups Work' module, we have been asked to add one of the catalog variables to the list view to help our Server team organize their work intake. I can see and add all sorts of extended table fields, but I can't seem to find the variables. When I switch and go to the Requested Item table list view, I can see and add variables there no problem. It is fairly straightforward - add variables.c35ad1efdb34c010993f5f774896193e as an element in list configuration and there is the variable. When I go back to task table, I can see when I add an one of the extended fields on the Requested Item table the syntax for the element is ref_req_item.field and this works just fine for any field, but when I use ref_req_item.variables.c35ad1efdb34c010993f5f774896193e nothing shows up.

Anyone able to help me?

Community Alums · ‎02-16-2021

Hi Dirk,

I meant to come back here and add the response to the HI ticket but I forgot.

Here is the response from the HI Agent:

- Adding a catalog item variable to the list is not a good idea because not all the catlog items will have the variable used in them.
- To explain this better, let me take an example. The variable "Enter Full name of the AD Group" is added to the list view of "sc_task" and "task". The "task" list contains request, requested items, task records and "sc_task" list contains task records. Not all the catalog items will have the "Enter Full name of the AD Group" variable.
- The following is the hierarchy in which the tables are extended.
task - sc_request - sc_req_item - sc_task
- The variables of the catalog item are available only from the "sc_req_item" table. That is the reason the variables and values associated to the variables are present on "sc_req_item", "sc_task" tables but not on "task" and "sc_request" tables.

I've gone ahead and added a new Idea on the Idea Portal:

https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=a41741f2db9ee850d5c4d9d968961925&sysparm_idea_table=x_snc_com_ideation_idea&sysparm_module_id=enhancement_requests

I will most likely go with Ankur's workaround and just map the variable values to a field on the Catalog Task table so that these will be visible.

Thanks,

Dustin

View solution in original post

Ankur Bawiskar · ‎07-31-2020

Hi Dustin,

Are you willing to have that on sc_task table?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Community Alums · ‎01-06-2021

@Ankur Bawiskar

Hi Ankur,

Sorry for the delayed response. I have still not solved this, but I prefer not to duplicate the data. What I find odd is that the column is displayed correctly, but there are no values present. I have opened a HI ticket for this issue and will update this post with results.

Ankur Bawiskar · ‎01-06-2021

Thank you

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

DirkRedeker · ‎02-09-2021

Hi Dustin

Thanks for the update. I also am interested in the results of your HI Ticket. So, please keep us informed here.

Thanks a lot & BR

Dirk