The Cora SeQuence engine supports retrieving external data that is stored in the Cora SeQuence database. Use a SQL statement in an expression to retrieve the external data.
| Method Type | Syntax | Example | Return Value Type |
|---|---|---|---|
| {sql: query text [{object expression}] query text } | {sql: } // identifies a SQL query expression query text: // a SQL query text {object expression} // optional query parameter, can be another expression | As a condition: {Form}.Query(“CountryData”).[“Textbox”] == {SQL: select fldName from tblCountries where fldCountry code = ‘TLV’ } As a return value: {sql: SELECT fldEmail from tblEmployees where fldEmployeeId = { rt.CurrentUser.UserId } } | DataTable object |
| {sqlt: query text [{object expression}] query text } | {sqlt: } // identifies a SQLT query expression query text // a SQLT query text {object expression} // optional query parameter, can be another expression | {SQLT: Select field1, field2 from myTable } | DataTable object |
