$Database.GetData

Overview

Executes query by specified column and value as single criteria and returns resulting data table instance.

DataTable $Database.GetData(schema: string, table: string, column: string, value: any)

Executes query by specific column and value as Name or Id number of target data stored criteria and return resulting datatable instance.

DataTable $Database.GetData(store: string, schema: string, table: string, column: string, value: any)

string schema

Name of target schema

string table

Name of target table

string column

Name of column to use as criteria

any value

Value of column to use as criteria

string store

Name or Id number of target data store. This parameter is optional.

If no row matches return value is empty data table.

var table = $Database.GetData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));