I need a way to update via sql all service offerings with 'one-click submit' option, and alter the value in approval process field, but i cant found the table where this features are setted.
Does anyone know how to do this?
The mssql select query on the mdb database to check for the offering type is:
USE mdbGOSELECT offering_id,parent_id,status,offering_name,description,typeFROM dbo.usm_offering
Where:Type = 0 for ShoppingCartType = 3 for One-Click
Thanks and kind regards, Louis van Amelsfort.
Good Morning Albino.
Should you decide to indeed update the content of the mdb database, then please check the below preparation steps:
1. Stop all processing on the mdb database
2. Make a backup of the mdb database
Thanks and kind regards, Louis.