ATF: Edit MRVS rows?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-07-2022 10:10 AM
I have a catalog item that requires data to be collected in an MRVS. Once the RITM is created, the first task requires additional data to be added to the existing rows in the MRVS.
I don't see a test step for editing existing MRVS rows. Am I missing something? If there's not an existing test step, has anyone found a way to do this via a script step?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-07-2022 12:05 PM - edited 11-07-2022 12:10 PM
I ended up having to do this in 4 steps PER VARIABLE that I needed to update:
1. Record query on sc_multi_row_question_answer table
where Parent ID is my RITM (which I queried for in an earlier step) and Question = the variable I need to set
2. Open an existing record (the record found in the previous step)
3. Set field values - set the 'value' field to the appropriate value for that variable.
4. Submit a form
So, since I had 5 variables in the row that I needed to update, I had to use 20 steps to accomplish this goal.
If anyone knows of an easier/more efficient way, I'm all ears.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 12:49 PM - edited 05-15-2025 12:55 PM
I was thinking this could be done in a single Server Side Script step where you query for all the Multi Row Question Answer records where Parent ID is your RITM. Then loop through each of the returned records and depending on the Question value, make the desired change. Maybe using a case switch statement where there's a case for each "Question" value.
After looping through all the return MRVS question answer records, do an gr.update() to save it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2023 08:34 AM
I am also struggling to edit mrvs in service portal catalog items. any recent update in steps pl let me know.