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

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

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.