Variable formatter - Changes not saved

[kristenankeny]

I extended the sc_req_item table, was able to add and update the formatter so that it displays the variables, but any changes made to variables are not saved. The save works on sc_req_item, but not on the extended table. Does anyone know what needs to be updated to allow edit of variables from an extension of sc_req_item?

[SanjivMeher]

Didn't get a chance to go through the below article. But it might be helpful.

ServiceNow Admin 101: Creating a Service Catalog Variable Report

Last option would be update the sc_item_option_mtom table, where the variable and its values are stored.

[kristenankeny · Accepted solution]

After speaking with ServiceNow, we approached this solution differently. We kept the records on the sc_req_item table, instead of extending it. Then we added a field called "partitions" that has two values, one of which is default (so showing whatever view they have access to) and position_bundle, which triggers a view rule that forces them into the PositionBundle view. On the new record types, we set partition to "position_bundle" so that the view rules run.