How to set one-click submit to all service offerings?

[Albino]

Hi guys!

 

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?

 

[Louis van Amelsfort]

Good Afternoon.

 

The mssql select query on the mdb database to check for the offering type is:

USE mdb
GO
SELECT offering_id,parent_id,status,offering_name,description,type
FROM dbo.usm_offering

 

Where:
Type = 0 for ShoppingCart
Type = 3 for One-Click

 

Thanks and kind regards, Louis van Amelsfort.

[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.