ajSystemError function
Description
The ajSystemError retrieves error records from the System Error List.
Syntax
ajSystemError([cell_reference], [function_name], [error_message])
| Argument Name | Argument Type | Description |
|---|---|---|
| cell_reference (optional) | String | The cell address to be filtered and shown from the system error list. The default value is an empty string (“”) which means no filter condition. |
| function_name (optional) | String | The function name to be filtered and shown from the system error list. The default value is an empty string (“”) which means no filter condition. |
| error_message (optional) | String | The partial or full string condition to be used to filter and shown from the system error list. Please take note that the string condition is case-insensitive. For example, records with an error message “ABCDE” will be shown with Error_message “b”. The default value is an empty string (“”) which means no filter condition. |
The function will return:
1) Return Value: Records from System Error List
2) Return Type: Multiple values (array formula)
Click here to download the use case workbooks for further reference.
Example
In this example, a wrong SQL statement (table "me" does not exist) is used in ajDBRunSQL which generates a system error. The error is added to the System Error List. ajSystemError with no filter condition returns such an error from the list.
