Information
  • Author: Appian Corporation
  • Type: Utility
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Compatible Version(s): 22.4
  • First Released:
  • Last Updated:
  • Cost: Free
Share
Home » AppMarket » Script Management

Script Management

Overview

Developer tool to be used in development environments only to manage DB scripts for Appian applications

Key Features & Functionality

  • Track scripts per application
  • Auto-verify all scripts on every change
  • Change management with approval access
  • Auto-generate idempotent scripts for higher environments
Anonymous
Parents

  • One of our developers has noted that system versioned tables are not supported correctly. In “SMT Wipe Database Script (Maria DB)” in “INSERT INTO TEMP_TABLE_DATE” there is this condition:

    IF(TABLE_TYPE = 'BASE TABLE', 'TABLE', 'VIEW')

    so he had to changed it to :

    IF(TABLE_TYPE = 'SYSTEM VERSIONED' OR TABLE_TYPE = 'BASE TABLE', 'TABLE', TABLE_TYPE)

    Could you please include this in the next version?

    Thank you

Comment

  • One of our developers has noted that system versioned tables are not supported correctly. In “SMT Wipe Database Script (Maria DB)” in “INSERT INTO TEMP_TABLE_DATE” there is this condition:

    IF(TABLE_TYPE = 'BASE TABLE', 'TABLE', 'VIEW')

    so he had to changed it to :

    IF(TABLE_TYPE = 'SYSTEM VERSIONED' OR TABLE_TYPE = 'BASE TABLE', 'TABLE', TABLE_TYPE)

    Could you please include this in the next version?

    Thank you

Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.