transformations:sqlcommand
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:sqlcommand [2021/06/22 10:37] – [Action settings] craigt | transformations:sqlcommand [2022/12/05 14:23] (current) – craigt | ||
---|---|---|---|
Line 6: | Line 6: | ||
=====Description===== | =====Description===== | ||
This action performs one of these 4 commands on a specified database: | This action performs one of these 4 commands on a specified database: | ||
+ | * Custom command | ||
* Create database table | * Create database table | ||
* Delete database table | * Delete database table | ||
* Delete all rows | * Delete all rows | ||
- | * Custom command | + | * List tables |
+ | * List table fields | ||
\\ | \\ | ||
Line 21: | Line 23: | ||
|Connector< | |Connector< | ||
|Command|Select the process to run on the database. | |Command|Select the process to run on the database. | ||
- | |Advanced (Timeout)|Set the number of seconds for this process to complete before timing out. Default is 1800. If the action has not completed within the set Timeout, the workflow stops and displays an error.| | + | |Advanced (Timeout)|Set the number of seconds for this process to complete before timing out. Default is 1800. If the action has not\\ completed within the set Timeout, the workflow stops and displays an error.| |
< | < | ||
+ | |||
+ | \\ | ||
+ | ====Custom command settings==== | ||
+ | **Description: | ||
+ | ^Settings ^Description ^ | ||
+ | |Statement|Enter the free-form SQL query to send to the database. | ||
+ | Example: | ||
\\ | \\ | ||
Line 52: | Line 61: | ||
\\ | \\ | ||
- | ====Custom command | + | ====List tables |
- | **Description: | + | **Description: |
+ | |||
+ | \\ | ||
+ | ====List table fields settings==== | ||
+ | **Description: | ||
^Settings ^Description ^ | ^Settings ^Description ^ | ||
- | |Statement|Enter the free-form SQL query to send to the database. The query can include | + | |Table name< |
- | Example: | + | < |
\\ | \\ |
transformations/sqlcommand.txt · Last modified: 2022/12/05 14:23 by craigt