You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

TSL sequence [[[#]]]


Use this operator to add a sequence-number to each instance in a set of instances.


Note: The sequence operator returns the sequence-number of the FOREACH loop that it is used in. It is not the sequence in which the instances where created. The sequence number starts at 0.


Syntax

[[[#]]]


Input

  • # is the sequence operator


Example

Suppose you want to create an overview of all registered users. Then you could create the following message:

[[[FOREACH user]]][[[# user.last_name]]], [[[user.first_name]]][[[/FOREACH]]]

If you have three registered users: John Doe, Jane Doe and Mr X your user list would look like this: 0 Doe, John 1 Doe, Jane 2 X, Mr

Or you want to create a comma separated list that contains all users:

[[[FOREACH user]]] [[[user.first_name]]] [[[user.last_name]]]
[[[IF # != (COUNT user.last_name - 1)]]], [[[ELSE]]]. [[[/IF]]]
[[[/FOREACH]]] /*end user loop*/

Than the result would look like this:

John Doe, Jane Doe, Mr X.



TSL formats [[[expression{format}]]]

There are two different types of formatting available in TSL, number formats and date formats. Both formats are applied to attributes or expressions in the same way.


Syntax


[[[expression{format}]]]


Inputs

  • expression: is a number or date

  • format: is the number or date formatting


Numbers

In TSL, you can use number formats to change the appearance of numbers, without changing the number behind the appearance. The number format you apply does not affect the actual value. In this context a number can be any of the following basetypes; number, integer, currency or percentage.

The number formats used in TSL are common Java decimal formats. The most commonly used formatting symbols are listed below. For a complete documentation we refer to the online java documentation that is available at https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/text/DecimalFormat.html.


SymbolNameMeaning
0Digit_zerodisplays insignificant zeros if a number has fewer digits than there are zeros in the format
#Digitdisplays only significant digits and does not display insignificant zeros
,Thousand separatorThe integer portion of a number is often split into groups by a grouping separator. Western numbers generally separate numbers into thousands, or groups of 3 digits. However, other styles exist.
.Decimal separatorThe separator between integer and fractional parts of a number
-Minus signSign to specify a negative value
;Sub pattern separatorSeparates formatting for positive and negative numbers
%Percentage signMultiply by 100 and show as percentage
¤(ALT_0164)Currency signUse localized currency symbol (for € sign simply use ALT_0128)
Escape characterUse special characters as ordinary characters


These symbols are used to create a format pattern. How this pattern is created is shown in the examples below.

To use the symbols as ordinary characters in your expression use the escape character.


Note that the formatting depends on the language that is used. This means that when you specify a thousand separator , in the Dutch language this is outputted as a .


Examples

Format patternNumberResult (with English language)Result (with Dutch language)
{0000000000}9813756.19800098137560009813756
{##########}9813756.19898137569813756
{#,###.##}9813756.1989,813,756.29.813.756,2
{#,-##0.00}-9813756.1989,813,756.20-9.813.756,20-
{-#,##0.00}9813756.198-9,813,756.20-9.813.756,20
{#,##0.00;-#,##0.00}9813756.1989,813,756.209.813.756,20
{#,##0.00;-#,##0.00}-9813756.198-9,813,756.20-9.813.756,20
{#,##0.## %}0.880 %80 %
{% #,##0.##}0.8% 80% 80
{¤ #,##0.00}9813756.198£ 9,813,756.20€ 9.813.756,20
{#,##0.00 ¤}9813756.1989,813,756.20 £9.813.756,20 €
{#,##0.00 €}9813756.1989,813,756.20 €9.813.756,20 €
{€ #,##0.00}9813756.198€ 9,813,756.20€ 9.813.756,20
{‘#’#}123#123#123


Dates

In TSL, you can use date formats to change the appearance of dates, without changing the date behind the appearance. The date format you apply does not affect the actual value.

Unable to render {include} The included page could not be found.

These symbols are used to create a format pattern.


Examples

Format patternExample result
TODAY{dd-MM-yyyy}11-04-2019
NOW{dd-MM-yyyyTHH:mm:ss.SSS}11-04-2019T11:06:56.330

NOW{hh:mm a}

09:40 AM

  • No labels