how do report on multi row variable set

[MMKK]

Hi All,

I wanted to know if there is any way that i can report on Multi row variable set variables. I really need this feature and i see that there is some limitation.

Please share any alternate way.

[kevinray]

Hi.

Unfortunately that SYS is what is stored in the value field of the MRSV table. It's not a traditional reference field field that does the value lookup for you.

I think your best bet here would be to add a string variable to your variable set. (just hide it from your catalog and request item views (so people dont see it) Then create a client script to set the new variable to the value of the reference field. something like this: 

function onChange(control, oldValue, newValue, isLoading) {
    var refField = g_form.getReference('field_that_is_a_ref',setValueToRef);

function setValueToRef(refField){
    g_form.setValue('new_string_field', refField.name);
  }

}

Then you can use this new field in your report instead of the actual reference field with the sys_id

I'm suggesting you do the call back method (with function) so it's asynchronous. You don't have to do this but it helps performance.

Here someone asked the same question: https://community.servicenow.com/community?id=community_question&sys_id=29476a85dbc273c00be6a345ca961965

[Ravindra H V]

Follow below steps to join Req item table with Multi row variables table:

• Step 1: -

Create a Database View as show below in screen grab.

• Step 2: - verify the data is visible on the table.

• Step 3: - create the report.

If this response is useful, please mark it as "Helpful".