The following plugin provides functionality available through Pipeline-compatible steps. Read more about how to integrate steps into your Pipeline in the Steps section of the Pipeline Syntax page.

For a list of other such plugins, see the Pipeline Steps Reference page.

Database

getDatabaseConnection: Get Database Connection

  • id (optional)
    Unique identifier for this database connection, used to select this connection with the sql step
    • Type: String
  • type (optional)
    • Values: GLOBAL, PERITEM

sql: Run SQL

  • sql
    SQL Statement to execute on given database connection. If the statment requires parameters pass an array like so:
    sql sql: "SELECT * FROM jobs WHERE id = ?", parameters: [1]
    • Type: String
  • connection (optional)
    ID of the connection as passed to the getDatabaseConnection step
    • Type: String
  • parameters (optional)
    • Type: Array / List of Object

Was this page helpful?

Please submit your feedback about this page through this quick form.

Alternatively, if you don't wish to complete the quick form, you can simply indicate if you found this page helpful?

    


See existing feedback here.