Functions
ById
function on a data of type
Number for example.
In this article
General functions
By Key
The By Key
function returns the value of an element from its key.
Parameter: Key
By Index
The By Index
function returns the value of an element from its index. The first element of an array is 0.
Parameter: Index
By Id
The By Id
function returns the value of an element from its unique identifier.
Parameter: Identifier
Mathematical
Add
The Add
function adds the number specified in parameter and returns the value.
Parameter: Number
Substract
The Substract
function subtracts the number specified in parameter and returns the value.
Parameter: Number
Multiply
The Multiply
function multiplies by the number specified in parameter and returns the value.
Parameter: Number
Divide
The Divide
function divides by the number specified in parameter and returns the value.
Parameter: Number
Round
The Round
function rounds a numerical value to the nearest integer number.
Floor
The Floor
function returns the largest integer less than or equal to a specified number.
Ceil
The Ceil
function returns the smallest integer less than or equal to a specified number.
Format Number
The Format Number
function returns a number in the requested format.
Parameters:
- Minimums (Fractions): the minimum number of fraction digits to be used
- Maximums (Fractions): the maximal number of fraction digits to be used
Parse Number
The Parse Number
function parses a string with a number and returns the number.
Text and string of characters
Truncate
The function Truncate
limits the number of characters in a text by adding "..."
Split
The function Split
splits a string into substrings. This function returns the result as an array. The single separator parameter contains the character to split the string.
Date and time
Date format
The function Format Date
returns a string expression based on the date, date format and language specified by the user. There are several date and time formats to choose from (none, short, medium, long, integer).
Paramètres :
- Format Date :
- Format Heure :
Parse Date
The Parse Date
function parses a string with a date and returns the date.
Add Seconds
The function Add Seconds
returns a new date resulting from adding a given number of seconds to a date. To subtract seconds, enter a negative number.
Add Minutes
The function Add Minutes
returns a new date resulting from adding a given number of minutes to a date. To subtract minutes, enter a negative number.
Add Hours
The function Add Hours
returns a new date resulting from adding a given number of hours to a date. To subtract hours, enter a negative number.
Add Days
The function Add Days
returns a new date resulting from adding a given number of days to a date. To subtract days, enter a negative number.
Add months
The function Add Months
returns a new date resulting from adding a given number of months to a date. To subtract months, enter a negative number.
Add years
The function Add Years
returns a new date resulting from adding a given number of years to a date. To subtract years, enter a negative number.
Set seconds
The function Set Seconds
returns a new date with the seconds specified in the parameters. Accepts numbers from 0 to 59. If a number is given outside this range, the date will be returned with the seconds of the previous or next minute(s) accordingly.
Set Minutes
The function Set Minutes
returns a new date with the minutes specified in the parameters. Accepts numbers from 0 to 59. If a number is given outside this range, the date will be returned with the seconds of the previous or next minute(s) accordingly.
Set Hours
The function Set Hours
returns a new date with the time specified in the parameters. Accepts numbers from 0 to 23. If a number is given outside the range, it will return the date with the time of the previous or next day accordingly.
Set Days
The function Set Days
returns a new date with the day of the month specified in the parameters. Accepts numbers from 1 to 31. If a number is given outside the range, it will return the previous or next day of the month accordingly.
Set Months
The function Set Months
returns a new date with the month specified in the parameters. Accepts numbers from 1 to 12. If a number is given outside this range, it will return the month of the previous or next year accordingly.
Set Years
The function Set Years
renvoie une nouvelle date avec l'année spécifiée comme paramètre.
Array and Collection
Merge
The Merge
functions
Count
The Count
function calculates the number of elements in an array.
Group by
The Group by
function groups the data according to a criteria.
Uniq by
The Uniq by
function removes duplicates according to a criteria.