Variables not selectable when adding Simple List Data Visualization column

[Evan McElfresh]

I'm hoping I'm just missing something basic here...

I'm trying to build a basic Simple List, on the sc_req_item table that needs to include several of the catalog item variables on it, but when I try and choose those variables, the dot-walk options under 'Variables' seem to be more system attributes of variables, not the variables themselves.

According to this ServiceNow documentation, I feel I should be getting a different result. Can anyone help me figure out what I'm doing wrong, or validate my findings and I will submit a ticket?

We are on Yokohama Patch 1b Hot Fix 1

sn_par_vis_base version 28.0.3 (up-to-date, according to Application Manager)

Edit to add context for this screenshot: The variables, "Hotel" and "Hotel Cost" should be visible in this section. Additionally, I would expect to see subtext for where each of the variables are sourced from, i.e. what Catalog Item they came from, but none of these entries are Catalog Item variables at all.

[GlideFather]

Hi @Evan McElfresh 

as RITMs and variables are both stored in a different table, I don't think this would be possible.

However you can map some of the variables to fields from the form and then you will see these values...

Let me know in case you want to discuss it further

[Evan McElfresh]

Thank you for your reply. I should point out that I've been able to do it in the past and according to the ServiceNow documentation it's doable, specifically by building the report on the sc_req_item table.

[TheJoeDC]

What you want to do is achievable.

One thing to remember is that the variables are requested item specific in general. So you are going to see the variables for all items on that list. 

So one option is to filter the list to a specific item, then filter the variable list (in this example I'm pulling data on printer requests). 

Some more context of what your end result might help:

[Evan McElfresh]

Thank you. Unfortunately, none of the catalog item variables are visible. For example, in my screenshot the variable, "Hotel" should be there, but is not. In addition, none of the options in the Variables drill-down list have the subtext of which catalog item it is from.