Miscellaneous Functions

Home \| Table of Contents	Miscellaneous Functions
Prev	Functions Reference	Next

The rest of the functions can be denominated as miscellaneous. They are the functions listed below.

Important

	Important
Remember that the object notation (e.g., `arg.isnull()`) cannot be used for these Miscellaneous functions! For more information about object notation see Functions Reference.

Remember that the object notation (e.g., arg.isnull()) cannot be used for these Miscellaneous functions!

For more information about object notation see Functions Reference.

<any type> iif(boolean con, <any type> iftruevalue, <any type> iffalsevalue);
The iif(boolean, <any type>, <any type>) function accepts three arguments: one is boolean and two are of any data type. Both argument data types and return type are the same.
The function takes the first argument and returns the second if the first is true or the third if the first is false.

boolean isnull(<any type> arg);

The isnull(<any type>) function takes one argument and returns a boolean value depending on whether the argument is null (true) or not (false). The argument may be of any data type.

Important

	Important
If you set the Null value property in metadata for any `string` data field to any non-empty string, the `isnull()` function will return `true` when applied on such string. And return `false` when applied on an empty field. For example, if `field1` has Null value property set to `"<null>"`, `isnull($0.field1)` will return `true` on the records in which the value of `field1` is `"<null>"` and `false` on the others, even on those that are empty. See Null value for detailed information.

If you set the Null value property in metadata for any string data field to any non-empty string, the isnull() function will return true when applied on such string. And return false when applied on an empty field.

For example, if field1 has Null value property set to "<null>", isnull($0.field1) will return true on the records in which the value of field1 is "<null>" and false on the others, even on those that are empty.

See Null value for detailed information.

<any type> nvl(<any type> arg, <any type> default);
The nvl(<any type>, <any type>) function accepts two arguments of any data type. Both arguments must be of the same type. If the first argument is not null, the function returns its value. If it is null, the function returns the default value specified as the second argument.

<any type> nvl2(<any type> arg, <any type> arg_for_non_null, <any type> arg_for_null);
The nvl2(<any type>, <any type>, <any type>) function accepts three arguments of any data type. This data type must be the same for all arguments and return value. If the first argument is not null, the function returns the value of the second argument. If the first argument is null, the function returns the value of the third argument.

void printErr(<any type> message);

The printErr(<any type>) function accepts one argument of any data type. It takes this argument and prints out the message on the error output.

This function works as void printErr(<any type> arg, boolean printLocation) with printLocation set to false.

	Note
	Remember that if you are using this function in any graph that runs on CloudConnect Server, the `message` is saved to the log of Server (e.g., to the log of Tomcat). Use the `printLog()` function instead. It logs error messages to the console even when the graph runs on CloudConnect Server.

void printErr(<any type> message, boolean printLocation);

The printErr(type, boolean) function accepts two arguments: the first is of any data type and the second is boolean. It takes them and prints out the message and the location of the error (if the second argument is true).

	Note
	Remember that if you are using this function in any graph that runs on CloudConnect Server, the `message` is saved to the log of Server (e.g., to the log of Tomcat). Use the `printLog()` function instead. It logs error messages to the console even when the graph runs on CloudConnect Server.

void printLog(level loglevel, <any type> message);

The printLog(level, <any type>) function accepts two arguments: the first is a log level of the message specified as the second argument, which is of any data type. The first argument is one of the following: debug, info, warn, error, fatal. The log level must be specified as a constant. It can be neither received through an edge nor set as variable. The function takes the arguments and sends out the message to a logger.

	Note
	Remember that you should use this function especially in any graph that would run on CloudConnect Server instead of the `printErr()` function which logs error messages to the log of Server (e.g., to the log of Tomcat). Unlike `printErr()`, `printLog()` logs error messages to the console even when the graph runs on CloudConnect Server.

void raiseError(string message);
The raiseError(string) function takes one string argument and throws out error with the message specified as the argument.

void sleep(long duration);
The function pauses the execution for specified milliseconds.

Prev	Up	Next
Container Functions	Home \| Table of Contents	Lookup Table Functions