System Functions

Category	Function	Description	Example
Math	AbsValue	Returns the absolute value of a number.	AbsValue(-5) => 5
Math	ACos	Returns the arccosine of a number.	ACos(0.5) => 1.0472
Math	AggregateSum	Calculates the sum of all numbers in an array.	AggregateSum([8, 12, 10]) => 30
Math	ASin	Returns the arcsine of a number.	ASin(0.5) => 0.5236
Math	ATan	Returns the arctangent of a number.	ATan(1) => 0.7854
Math	Ceil	Returns the smallest integer greater than or equal to a number.	Ceil(2.5) => 3
Math	Cos	Returns the cosine of a number.	Cos(0) => 1
Math	Exp	Returns Euler's number raised to the power of a number.	Exp(1) => 2.7183
Math	Floor	Returns the largest integer less than or equal to a number.	Floor(2.8) => 2
Math	Log	Returns the natural logarithm (base e) of a number.	Log(10) => 2.3026
Math	Power	Returns the result of a number raised to a power.	Power(2, 3) => 8
Math	Random	Generates a random number between 0 and 1.	Random() => 0.8463 (random value)
Math	Round	Rounds a number to the nearest integer.	Round(2.6) => 3
Math	Sin	Returns the sine of a number.	Sin(0) => 0
Math	Sqrt	Returns the square root of a number.	Sqrt(16) => 4
Math	Tan	Returns the tangent of a number.	Tan(0) => 0
String	CharAt	Returns the character at the specified index in a string.	CharAt("Hello", 1) => "e"
String	CharUnicode	Returns the Unicode value of the character at the specified index.	CharUnicode("Hello", 1) => 101
String	Concat	Concatenates two or more strings.	Concat("Hello", " World") => "Hello World"
String	Contains	Checks if a string contains another string.	Contains("Hello", "ell") => true
String	Ends With	Checks if a string ends with a specified substring.	Ends With("Hello", "lo") => true
String	EqualsIgnoreCase	Compares two strings, ignoring case differences.	EqualsIgnoreCase("hello", "HELLO") => true
String	GetLength	Returns the length of a string.	GetLength("Hello") => 5
String	IndexOf	Returns the position of the first occurrence of a substring.	IndexOf("Hello", "l") => 2
String	IsNullOrEmpty	Checks if a string is null or empty.	IsNullOrEmpty("") => true
String	LastIndexOf	Returns the position of the last occurrence of a substring.	LastIndexOf("Hello", "l") => 3
String	LowerCase	Converts a string to lowercase.	LowerCase("Hello") => "hello"
String	Replace	Replaces all occurrences of a substring with another string.	Replace("Hello", "H", "J") => "Jello"
String	Search	Searches a string for a specified value and returns the position.	Search("Hello", "o") => 4
String	Split	Splits a string into an array of substrings based on a delimiter.	Split("Hello World", " ") => ["Hello", "World"]
String	StartsWith	Checks if a string starts with a specified substring.	StartsWith("Hello", "He") => true
String	StrEquals	Compares two strings for equality.	StrEquals("Hello", "Hello") => true
String	SubString	Extracts a substring from a string.	SubString("Hello", 0, 2) => "He"
String	ToString	Converts an object to a string.	ToString(123) => "123"
String	Trim	Removes whitespace from both ends of a string.	Trim(" Hello ") => "Hello"
String	UpperCase	Converts a string to uppercase.	UpperCase("hello") => "HELLO"
DateTime	AddDate	Adds a specified number of days to a date.	AddDate(Today(), 5) => "2024-04-20"
DateTime	CalculateBusinessDays	Calculates the number of business days between two dates.	CalculateBusinessDays("2024-04-01", "2024-04-10") => 7
DateTime	Date	Retrieves the current date.	Date() => "2024-04-15"
DateTime	DateDiff	Calculates the difference between two dates in days.	DateDiff("2024-04-10", "2024-04-01") => 9
DateTime	DateToISOString	Converts a date to an ISO string format.	DateToISOString(Today()) => "2024-04-15T00:00:00.000Z"
DateTime	DateToUTCString	Converts a date to a string in UTC time zone.	DateToUTCString(Today()) => "Mon, 15 Apr 2024 00:00:00 GMT"
DateTime	DateValueOf	Returns the numeric value of a date.	DateValueOf(Today()) => 177364800000
DateTime	Day	Returns the day of the month for a specified date.	Day(Today()) => 15
DateTime	DaysInMonth	Returns the number of days in the month for a specified date.	DaysInMonth("2024-02-01") => 29
DateTime	FormatDate	Formats a date according to the specified format.	FormatDate(Today(), "DD/MM/YYYY") => "15/04/2024"
DateTime	Full Year	Returns the year portion of a date.	FullYear(Today()) => 2024
DateTime	Hours	Returns the hour portion of a date.	Hours(Today()) => 0
DateTime	IsLeap Year	Checks if a given year is a leap year.	IsLeapYear(2024) => true
DateTime	Milliseconds	Returns the milliseconds portion of a date.	Milliseconds(Today()) => 0
DateTime	Min	Returns the minute portion of a date.	Min(Today()) => 0
DateTime	Month	Returns the month portion of a date.	Month(Today()) => 4
DateTime	ParseDate	Parses a date string into a Date object.	ParseDate("2024-04-15") => Date object representing April 15, 2024
DateTime	Seconds	Returns the seconds portion of a date.	Seconds(Today()) => 0
DateTime	SubtractDate	Subtracts a specified number of days from a date.	SubtractDate(Today(), 5) => "2024-04-10"
DateTime	Time	Returns the time portion of a date.	Time(Today()) => "00:00:00"
DateTime	TimeLocaleStr	Converts a date to a string in the local time zone with locale-specific formatting.	TimeLocaleStr(Today()) => "12:00:00 AM" (may vary based on locale)
DateTime	TimeZoneOffset	Returns the time zone offset in minutes for the current locale.	TimeZoneOffset(Today()) => -240
DateTime	ToDateOnlyString	Converts a date to a string with only the date portion.	ToDateOnlyString(Today()) => "2024-04-15"
DateTime	Today	Returns the current date.	Today() => "2024-04-15"
DateTime	ToLocaleString	Converts a date to a string using the local time zone and locale-specific formatting.	ToLocaleString(Today()) => "4/15/2024, 12:00:00 AM" (may vary by locale)
DateTime	ToTimeOnlyString	Converts a date to a string with only the time portion.	ToTimeOnlyString(Today()) => "00:00:00"
DateTime	UTCDate	Returns the day of the month in UTC time zone.	UTCDate(Today()) => 15
DateTime	UTCDay	Returns the day of the week in UTC time zone.	UTCDay(Today()) => 5
DateTime	UTCFull Year	Returns the year in UTC time zone.	UTCFullYear(Today()) => 2024
DateTime	UTCHours	Returns the hour in UTC time zone.	UTCHours(Today()) => 0
DateTime	UTCMilliseconds	Returns the milliseconds in UTC time zone.	UTCMilliseconds(Today()) => 0
DateTime	UTCMin	Returns the minutes in UTC time zone.	UTCMin(Today()) => 0
DateTime	UTCMonth	Returns the month in UTC time zone.	UTCMonth(Today()) => 3
DateTime	UTCSeconds	Returns the seconds in UTC time zone.	UTCSeconds(Today()) => 0
DateTime	Year	Returns the year of a specified date.	Year(Today()) => 2024
Array	AddItemToArray	Adds an item to an array.	AddItemToArray([], "John") => ["John"]
Array	AppendItems	Appends items from one array to another array.	AppendItems(["John"], ["Doe", "Smith"]) => ["John", "Doe", "Smith"]
Array	ArrayContains	Checks if an array contains a specified item.	ArrayContains(["John", "Doe"], "Doe") => true
Array	Clear	Clears all elements from an array.	Clear(["John", "Doe"]) => []
Array	ConcatArray	Concatenates two or more arrays.	ConcatArray(["John"], ["Doe"]) => ["John", "Doe"]
Array	CopyArray	Creates a shallow copy of an array.	CopyArray(["John", "Doe"]) => ["John", "Doe"]
Array	GetIndexByItem	Returns the index of the first occurrence of an item in an array.	GetIndexByItem(["John", "Doe"], "Doe") => 1
Array	GetLastIndexByItem	Returns the index of the last occurrence of an item in an array.	GetLastIndexByItem(["John", "Doe", "Doe"], "Doe") => 2
Array	ItemByIndex	Returns the item at a specified index in an array.	ItemByIndex(["John", "Doe"], 0) => "John"
Array	Join	Joins all elements of an array into a string.	Join(["John", "Doe"], ", ") => "John, Doe"
Array	Length	Returns the number of elements in an array.	Length(["John", "Doe"]) => 2
Array	RemoveItemByIndex	Removes the item at a specified index from an array.	RemoveItemByIndex(["John", "Doe"], 1) => ["John"]
Array	RemoveItems	Removes all occurrences of a specified item from an array.	RemoveItems(["John", "Doe", "Doe"], "Doe") => ["John"]
Array	Reverse	Reverses the order of the elements in an array.	Reverse(["John", "Doe"]) => ["Doe", "John"]
Array	Sort	Sorts the elements of an array.	Sort(["Doe", "John"]) => ["John", "Doe"]
Array	SliceItems	Returns a shallow copy of a portion of an array into a new array object.	SliceItems(["John", "Doe", "Smith"], 1, 2) => ["Doe", "Smith"]
TypeConverters	ParseDouble	Parses a string representation of a floating-point number into a double-precision floating-point number.	ParseDouble("3.14") => 3.14
TypeConverters	ParseInt	Parses a string representation of an integer into an integer.	ParseInt("10") => 10
TypeConverters	ParseLong	Parses a string representation of a long integer into a long integer.	ParseLong("10000000000") => 10000000000
TypeConverters	ConvertToLong	Converts a value to a long integer.	ConvertToLong(100) => 100L
TypeConverters	ConvertToInt	Converts a value to an integer.	ConvertToInt(10.5) => 10
DB Utils	GetBinaryValue	Retrieves the binary value associated with the specified key from a database.	GetBinaryValue("Employee", "ProfileImage") => [Binary Data]
DB Utils	GetBoolValue	Retrieves the boolean value associated with the specified key from a database.	GetBoolValue("Employee", "IsManager") => true
DB Utils	GetDateTimeValue	Retrieves the datetime value associated with the specified key from a database.	GetDateTimeValue("LeaveRequest", "StartDate") => "2024-04-15 09:00"
DB Utils	GetDoubleValue	Retrieves the double value associated with the specified key from a database.	GetDoubleValue("LeaveRequest", "DurationInDays") => 5.0
DB Utils	GetEnumValue	Retrieves the enum value associated with the specified key from a database.	GetEnumValue("LeaveRequest", "LeaveType") => "Annual"
DB Utils	GetIntValue	Retrieves the integer value associated with the specified key from a database.	GetIntValue("Employee", "YearsOfService") => 3
DB Utils	GetLongValue	Retrieves the long integer value associated with the specified key from a database.	GetLongValue("LeaveRequest", "EmployeeID") => 123
DB Utils	GetStringValue	Retrieves the string value associated with the specified key from a database.	GetStringValue("Employee", "FullName") => "John Doe"
MAP	Add	Adds a key-value pair to a map.	Add("Employee", "123", "John Doe")
MAP	ContainsKey	Checks if a map contains the specified key.	ContainsKey("Employee", "123") => true
MAP	Count	Returns the number of key-value pairs in a map.	Count("Employee") => 10
MAP	GetKeys	Retrieves all keys from a map.	GetKeys("Employee") => ["123", "124", ...]
MAP	GetValue	Retrieves the value associated with the specified key from a map.	GetValue("Employee", "123") => "John Doe"
MAP	Remove	Removes the key-value pair with the specified key from a map.	Remove("Employee", "123")
MAP	RemoveAll	Removes all key-value pairs from a map.	RemoveAll("Employee")
Cache	AddItemToCache	Adds an item to the cache with the specified key and value.	AddItemToCache("EmployeeCache", "123", {Name: "John Doe"})
Cache	GetItemFromCache	Retrieves the item from the cache associated with the specified key.	GetItemFromCache("EmployeeCache", "123") => {Name: "John Doe"}
Cache	ItemExistsInCache	Checks if an item exists in the cache with the specified key.	ItemExistsInCache("EmployeeCache", "123") => true
Cache	RemoveItemFromCache	Removes the item from the cache associated with the specified key.	RemoveItemFromCache("EmployeeCache", "123")
Others	AgeFromDOB	Calculates the age from the date of birth.	AgeFromDOB("1990-01-01")
Others	ConsoleLog	Logs a message to the console for debugging purposes.	ConsoleLog("message")
Others	CopyObject	Creates a shallow copy of an object.	CopyObject({Name: "John Doe"}) => {Name: "John Doe"}
Others	DecodeBase64	Decodes a base64-encoded string.	DecodeBase64("VGhpcyBpcyBhIGJhc2U2NC1lbmNvZGVkIHN0cmluZw==")
Others	EncodeBase64	Encodes a string to base64.	EncodeBase64("This is a base64-encoded string") => "VGhpcyBpcyBh..."
Others	GetConfiguration	Retrieves configuration settings for the application.	GetConfiguration("MaxLeaveDays") => 20
Others	GetByteData	Retrieves byte data from a specified source.	GetByteData("https://example.com/image.jpg") => [byte data]
Others	GetGUID	Generates a globally unique identifier (GUID).	GetGUID() => "f47ac10b-58cc-4372-a567-0e02b2c3d479"
Others	GetRequestHeader	Retrieves the value of a specified header from an HTTP request.	GetRequestHeader("Authorization") => "Bearer <token>"
Others	IfElse	Evaluates a condition and returns one of two values based on the result.	IfElse(IsEmployee, "Employee", "Guest")
Others	IsActivityCompleted	Checks if an activity is completed.	IsActivityCompleted("Task1") => true
Others	IsActivityCompletedSuccessfully	Checks if an activity is completed successfully.	IsActivityCompletedSuccessfully("Task1") => true
Others	IsActivityFaulted	Checks if an activity is faulted.	IsActivityFaulted("Task1") => false
Others	Parse	Parses a string into an object.	Parse('{"Name": "John", "Age": 30}') => {Name: "John", Age: 30}
Others	Stringify	Converts an object to a JSON string.	Stringify({Name: "John", Age: 30}) => '{"Name": "John", "Age": 30}'
Others	GetHMAC	Generates a Hash-based Message Authentication Code (HMAC) using a specified algorithm and key.	GetHMAC("SHA256", "secretKey", "message")
Others	ComputeSha256Hash	Computes the SHA-256 hash of a string.	ComputeSha256Hash("message") => "6f9b9af3cd6e8b8a73c2cdced37fe9b..."
Others	GenerateSalt	Generates a random salt for cryptographic purposes.	GenerateSalt() => "sJr7Bdh1kHm9Q6g4"
Others	SerializeXml	Serializes an object to XML format.	SerializeXml({Name: "John", Age: 30})
Others	DeserializeXml	Deserializes XML data into an object.	DeserializeXml("<Employee><Name>John</Name><Age>30</Age></Employee>")
Others	CompareObject	Compares two objects for equality.	CompareObject({Name: "John"}, {Name: "John"}) => true
Others	GetObjectHashCode	Generates a hash code for an object.	GetObjectHashCode({Name: "John"}) => "a94a8fe5ccb19ba61c4c0873d3..."