Overview
Creates a connection to the relevant system with the information defined on the domain and runs the query
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
...
Parameters set on the query. Optional.
Remarks
CONNECTION_NAME can be set on Edit Domain → URL Credentials → External Database Credentials.
Example
| Code Block | ||
|---|---|---|
| ||
$Database.ExecuteQuery("DenemeCONNECTION_NAME", "select * from wDomains where Id=@Id", {
Id: "17cec122-a909-45ac-89f9-78b5e96fc0c4"
}); |
See Also
- ExecuteQuery