Genpact Cora Knowledge Center

Support

SQL Queries in Expressions

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
SyntaxExample
Return Value Type
SQL and SQLT Queries in Expressions
{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