empty multirow variable

[max_danielewicz]

Hi All,

i have a catalogue item which contains a multirow field type. this multirow field contains 2 columns.

after i submit the request via service portal, i inspect the ritm and the multirow variable is empty.

why?  is there anything alse i should do?

regards,

max

[Anil Shewale]

Hi max.danielewicz

Just had a look in our instance, somehow we look to have similar behavior. Which we did not know of until now!

All answers on the variables from the multi-row-variable-set, are stored in the sc_multi_row_question_answer table. My thought would be to query this table, upon submitting the Catalog Item, so actually the inserted Requested Item. Because it's about empty rows, and not empty variables, I think you need to do multiple querying.

1) On insert of the sc_req_item, query the mrvs answer table on records for the parent sc_req_item
2) Group those results, so you would only be left with the unique rows
3) Query on those rows, if there are no values in any of the variables for that row OR turn it around, if there is at least one variable with a value (then the row is not empty)
4) Generate an event which could trigger a notification
5) Setup the notification

for more refer the following thread:

https://community.servicenow.com/community?id=community_question&sys_id=7817ff2adbad3704fff8a345ca96...

https://community.servicenow.com/community?id=community_question&sys_id=40e409c3db477f00fff8a345ca96...

If it help mark helpful or correct 

Thanks and regards

Anil

[Ankur Bawiskar]

Hi Max,

Please check below things

1) is this happening only for that catalog item

2) Is this happening for non-admins?

please share screenshot

Regards
Ankur

[Mark Roethof · Accepted solution]

Hi there,

Are you experiencing this on all your MRVS? Or just this one?

If all, are you using the out-of-the-box SC Catalog Item widget or an older cloned version? Older cloned versions (pre-London) don't support MRVS.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[shail_phillip]

Hi ,

I could find a known problem for the issue you are seeing - PRB1363523. The problem ticket is associated to this case for your reference.
The problem has been fixed in Orlando.
For resolution, please upgrade to Orlando.
As a workaround, please remove the " " from the text.