block
The block function is used to render the contents of a block tag more than once.
Example |
|
Output |
|
max
The max function will return the largest of it's numerical arguments.
Example |
{{ max(5, 3) }} |
Output |
|
min
The min function will return the smallest of it's numerical arguments.
Example |
|
Output |
|
parent
The parent function is used inside of a block to render the content that the parent template would have rendered inside of the block had the current template not overriden it.
Template |
|
range
The range function will return a list containing an arithmetic progression of numbers.
Example |
|
Output |
|
range with step
The range function will return a list containing an arithmetic progression of numbers.
Example |
|
Output |
|
bool
The bool function will return a boolean from parsing a value.
Example |
|
Output |
|
Example 2 |
|
Output |
|
codepoint
The codepoint function will return the character for the specified Unicode code point.
Example |
|
Output |
|
combine lists
The combineLists function will return a merged list of the two arguments.
Example |
|
|
|
double
The double function will return an int for the provided Number argument or attempt to parse a String into a double.
Example |
|
Output |
|
Example 2 |
|
Output |
3.145 |
int
The int function will return an int for the provided Number argument or attempt to parse a String into an int.
Example |
|
Output |
|
Example 2 |
|
Output |
|
replace start
The replaceStartfunction will return a String where str will be checked if it starts with match and if so be replaced with replace.
Example |
|
Output |
|
Example 2 |
|
Output |
|
replace end
The replaceEnd function will return a String where str will be checked if it ends with match and if so be replaced with replace.
Example |
|
Output |
|
Example 2 |
|
Output |
|
str is equals
The strIsEquals function will return a boolean for whether the provided String arguments are equal. Safely handles null values.
Example |
|
Output |
|
Example 2 |
|
Output |
|
Example 3 |
|
Output |
|
starts with ignore case
The startsWithIgnoreCase function will return a boolean for whether the provided str begins with match while ignoring casing.
Example |
|
Output |
|
ends with ignore case
The endsWithIgnoreCase function will return a boolean for whether the provided str ends with match while ignoring casing.
Example |
|
Output |
|
3D Specific Functions
closestConnection(Table table or Column column)
The closestConnection function will return a Connection that is the closest when traversing the source mappings.
Template |
|
createSourceGraph(Table table, boolean style, boolean denormalize)
The createSourceGraph function will return a list of QueryGraphs, one for each source connection, containing the tables for a query.
The style flag is set to true for calculating a data query or false for a data warehouse query.
The denormalize flag determines whether to calculate a query with any related tables to the provided table.
- QueryGraph.rootTables - If denormalize is true this contains the original table and all directly related tables, otherwise it only contains the original table.
- QueryTable.tables - Contains a list of source tables to generate the query over.
- QueryTable.connection - The associated connection for the set of source tables.
Template |
|
createSourceGraphBySet(Table table, String sourceSetName, boolean style, boolean denormalize)
The createSourceGraphBySet function will return a list of QueryGraphs, one for each source connection, containing the tables for a query by the given source set.
The style flag is set to true for calculating a data query or false for a data warehouse query.
The denormalize flag determines whether to calculate a query with any related tables to the provided table.
- QueryGraph.rootTables - If denormalize is true this contains the original table and all directly related tables, otherwise it only contains the original table.
- QueryTable.tables - Contains a list of source tables to generate the query over.
- QueryTable.connection - The associated connection for the set of source tables.
Template |
|
getProfilingValues(Table/Column/Relation obj, String metric, boolean casing)
The getProfilingValues function will return a list of all the values for the specified profiling metric name on a given object.
Example |
|
Output |
|
Example 2 |
|
Output |
|
Example 3 |
|
Output |
|
Example 4 |
|
Output |
|
Example 5 |
|
Output |
|
Example 6 |
|
Output |
|
Example 7 |
|
Output |
|
Example 8 |
|
Output |
|
Example 9 |
|
Output |
|
Example 10 |
|
Output |
|
Example 11 |
|
Output |
|
Example 12 |
|
Output |
|
Example 13 |
|
Output |
|
Example 14 |
|
Output |
|
Example 15 |
|
Output |
|
mapDuplicateAlias(List<Table> tables, List<QueryTable> queryTables)
The mapDuplicateAlias function returns a mapping from source table aliases to root tables in the tables list with multiple aliases in the queryTables list.
Template |
|
parseQuery(String query)
The parseQuery function will parse a query String into a QueryDefinition object.
Template |
|
quote(String query, String openQuote, String closeQuote)
The quote function convert any '`'s to the provided open and closing quotes.
Template |
|
Output |
|
uniqueTableName(Table table, String tableName, String schemaName)
The uniqueTableName function will return a String for a unique table name based on the provided names.
Example |
|
Output |
|