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:

FunctionDescription
Character Index/Position, ARJDBCSearches 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), ARJDBCConverts an expression of type CLOB to an expression of type Varchar.
Convert nText to Varchar (MSSQL), ARJDBCConverts an expression of type nText to an expression of type Varchar.
Convert String to Number, ARJDBCConverts an expression of type String to an expression of type Number.
Current Date, ARJDBCReturns the current date and time. The date is returned in the DD/MM/YYYY format. For example, 16/09/2022.
Date Difference - In Days, ARJDBCReturns the difference between two date values, in days.
Date Difference - In Seconds, ARJDBCReturns the difference between two date values, in seconds.
Date, ARJDBCReturns 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, ARJDBCReturns the day of the month from a specified date.
First Day of Month, ARJDBCReturns the first day of the month.
First Day of Quarter, ARJDBCReturns the first day of the quarter.
First Day of Year, ARJDBCReturns the day of the year.
Hour, ARJDBCReturns the hour part of the specified time.
Length, ARJDBCReturns the number of characters of an input string.
List Aggregation, ARJDBCTransforms values from a group of rows into a list of values that are delimited by a configurable separator.
Lower, ARJDBCReturns a character expression after converting uppercase character data to lowercase.
LPAD, ARJDBCReturns a character expression that is left-padded with another string to a specified length.
LTRIM, ARJDBCReturns a character expression after removing the leading blanks from the specified string.
Minute, ARJDBCReturns the minute part of the specified time.
Month Name, ARJDBCThis function returns the name of the month from a specified date.
Month Short Name, ARJDBCReturns 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, ARJDBCReturns the quarter of the year for a specified date.
Replace String, ARJDBCReplaces all occurrences of a specified string value with another string value.
RPAD, ARJDBCReturns a character expression that is right-padded with another string to a specified length.
RTRIM, ARJDBCReturns a character expression after removing the trailing blanks from the specified string.
Seconds, ARJDBCReturns the seconds part of the specified time.
SubString, ARJDBCReturns part of a character for given length from start position.
Upper, ARJDBCReturns a character expression after converting lowercase character data to uppercase.
Week Day Name, ARJDBCReturns the weekday name of a specified date.
Week, ARJDBCReturns an integer that represents the week number of the specified date.
Weekday Number, ARJDBCReturns an integer that represents the weekday of the specified date.
Year, ARJDBCReturns an integer that represents the year of the specified date.
Was this page helpful? Yes No Submitting... Thank you

Comments