Overview
...
DataTable $Database.ExecuteQuery(connectionName: string, query: string, timeout: number, parameters: object)
Arguments
string connectionName
name of external database name
string query
query to be run
number timeout
request timeout. Optional.
object parameters
...
arameters set on the query. Optional.
...
CONNECTION_NAME can be set on Edit Domain → URL Credentials → External Database Credentials.
Example
| Code Block | ||
|---|---|---|
| ||
$Database.ExecuteQuery("CONNECTION_NAMEAppDB", "select * from wDomainsUsers where Id = @Id", 100, {
Id: "17cec122-a909-45ac-89f9-78b5e96fc0c41"
}); |
See Also
- $Database.ExecuteNonQueryExecuteQuery