getSqlResultList
See also: Actions
Description | Get a list of results from a dynamic SQL query or other dynamic SQL request. Specify the SQL using the sql parameter or indirectly using '--sql @' to specify a file with SQL. Use a site configuration entry with database connection information either directly as a site for the action or indirectly as a reference on the database parameter like '--database @'. |
|---|---|
Required Parameters | |
Optional Parameters | limit, columns, select, options, outputFormat, outputType, file, append, encoding, field, channel |
Type | |
Category | |
Output Formats | 1 - CSV table of all columns |
Replacement Variables |
|
Hosting |
|
Since Version | 10.4 |
Examples |
|