Skip to end of banner
Go to start of banner

getSqlResultList

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Current »

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

sql, (database or url)

Optional Parameters

limit, columns, select, options, outputFormat, outputType, file, append, encoding, field, channel

Type

Get

Category

Info

Output Formats

1 - CSV table of all columns

Replacement Variables

Hosting
Since Version10.4

Examples

Related How To's

  • No labels