...
Default
...
SQL that will be used when not using individual operations like get, insert, update, etc.Get -
Example:
Code Block |
---|
SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4} |
Get
SQL used to determine how data will be retrieved from the database.
Example:
Code Block | ||
---|---|---|
| ||
SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4} |
Set
...
SQL code used to determine how data will be set in Jira, not the database.
Insert
...
SQL code used to determine how data will be inserted into the database.
Example:
Code Block | ||
---|---|---|
| ||
INSERT INTO auto_info(id, year, make, model) VALUES ({:1}, {:2}, {:3}, {:4}) |
Update
...
SQL code used to determine how data will be updated in the database.
Example:
Code Block | ||
---|---|---|
| ||
UPDATE auto_info SET year = {:2}, make = {:3}, model = {:4} WHERE id = {:1} |
Delete
...
SQL code used to determine how data will be deleted from the database.
Example:
Code Block | ||
---|---|---|
| ||
DELETE FROM auto_info WHERE id = {:1} |
Search
...
SQL code used to determine how data will be searched in the database.
Example:
Code Block | ||
---|---|---|
| ||
SELECT id, year, make, model FROM auto_info |
...
WHERE model ~ {:4} |
Seq
...
SQL code used to determine a sequence value for the ID in case you are when inserting new values into the database. If not specified, it will try to use the value provided in the inputs, and if that does not exist, it will rely on the database to have a mechanism for the ID.
Example:
Code Block |
---|
SELECT MAX(id) FROM auto_info |