Supported ARJDBC functions
Using a predefined function, you can add calculation to your dashboard. The following tables lists the available functions that you can use in the Service Management queries:
Function | Description |
|---|---|
Character Index/Position, ARJDBC | Searches for one character expression inside a second character expression. It returns the starting position of the first expression, if found. |
Convert CLOB to Varchar (Oracle), ARJDBC | Converts an expression of type CLOB to an expression of type Varchar. |
Convert nText to Varchar (MSSQL), ARJDBC | Converts an expression of type nText to an expression of type Varchar. |
Convert String to Number, ARJDBC | Converts an expression of type String to an expression of type Number. |
Current Date, ARJDBC | Returns the current date and time. The date is returned in the DD/MM/YYYY format. For example, 16/09/2022. |
Date Difference - In Days, ARJDBC | Returns the difference between two date values, in days. |
Date Difference - In Seconds, ARJDBC | Returns the difference between two date values, in seconds. |
Date, ARJDBC | Returns the current system date. |
DateAdd, ARJDBC | Adds a specified number value (as a signed integer) to a specified input date value, and then returns that modified value. |
Day, ARJDBC | Returns the day of the month from a specified date. |
First Day of Month, ARJDBC | Returns the first day of the month. |
First Day of Quarter, ARJDBC | Returns the first day of the quarter. |
First Day of Year, ARJDBC | Returns the day of the year. |
Hour, ARJDBC | Returns the hour part of the specified time. |
Length, ARJDBC | Returns the number of characters of an input string. |
List Aggregation, ARJDBC | Transforms values from a group of rows into a list of values that are delimited by a configurable separator. |
Lower, ARJDBC | Returns a character expression after converting uppercase character data to lowercase. |
LPAD, ARJDBC | Returns a character expression that is left-padded with another string to a specified length. |
LTRIM, ARJDBC | Returns a character expression after removing the leading blanks from the specified string. |
Minute, ARJDBC | Returns the minute part of the specified time. |
Month Name, ARJDBC | This function returns the name of the month from a specified date. |
Month Short Name, ARJDBC | Returns the name of the month in short format from a specified date. For example, Jan, Feb, and so on. |
Month, ARJDBC | Returns an integer that represents the month of the specified date. |
Quarter, ARJDBC | Returns the quarter of the year for a specified date. |
Replace String, ARJDBC | Replaces all occurrences of a specified string value with another string value. |
RPAD, ARJDBC | Returns a character expression that is right-padded with another string to a specified length. |
RTRIM, ARJDBC | Returns a character expression after removing the trailing blanks from the specified string. |
Seconds, ARJDBC | Returns the seconds part of the specified time. |
SubString, ARJDBC | Returns part of a character for given length from start position. |
Upper, ARJDBC | Returns a character expression after converting lowercase character data to uppercase. |
Week Day Name, ARJDBC | Returns the weekday name of a specified date. |
Week, ARJDBC | Returns an integer that represents the week number of the specified date. Use any of the following options:
|
Weekday Number, ARJDBC | Returns an integer that represents the weekday of the specified date. |
Year, ARJDBC | Returns an integer that represents the year of the specified date. |