Clarity Service Management

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  How to set one-click submit to all service offerings?

    Posted 03-04-2018 01:35 PM

    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?

     



  • 2.  Re: How to set one-click submit to all service offerings?

    Posted 03-05-2018 08:59 AM

    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.



  • 3.  Re: How to set one-click submit to all service offerings?
    Best Answer

    Posted 03-06-2018 01:53 AM

    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.