http://www.awareim.com/dokuwiki/ 2026-05-13T22:37:06+00:00 http://www.awareim.com/dokuwiki/ http://www.awareim.com/dokuwiki/_media/logo.png text/html 2023-05-08T06:25:04+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/abs?rev=1683527104&do=diff index function function_list mathematical ABS Description Returns the number constant being an absolute value of the provided number Parameters Attribute of the Number type or number constant or calculation producing number Example IF ABS (Transaction.Amount) = 10 THEN ... text/html 2023-05-08T06:25:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/age?rev=1683527122&do=diff index function function_list date_and_time AGE Description Returns the full year difference between the provided date and the current date Parameters Attribute of the Date type or date constant or calculation producing date Example IF Age (Account.Customer.DateOfBirth) > 70 Then... text/html 2023-05-08T06:25:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/app_copyright?rev=1683527143&do=diff index function function_list miscellaneous version:v5.0 APP_COPYRIGHT Description Returns the copyright the system Parameters None Example DISPLAY MESSAGE APP_COPYRIGHT() text/html 2023-05-08T06:25:54+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/app_id?rev=1683527154&do=diff index function function_list miscellaneous APP_PRODUCT_ID Description Returns the product id of the system Parameters None Example DISPLAY MESSAGE APP_PRODUCT_ID() text/html 2023-05-08T06:26:07+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/app_name?rev=1683527167&do=diff index function function_list miscellaneous version:v5.0 APP_NAME Description Returns the name of the application, version number, copyright and product id of the system respectively Parameters None Example DISPLAY MESSAGE APP_NAME() text/html 2023-05-08T06:26:21+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/app_version?rev=1683527181&do=diff index function function_list miscellaneous version:v5.0 APP_VERSION Description Returns the name of the version number of the system Parameters None Example DISPLAY MESSAGE APP_VERSION() text/html 2023-05-08T06:26:35+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/as_date?rev=1683527195&do=diff index function function_list text AS_DATE Description Converts the given string into a date according to the specified format. Parameters Attribute of the Plain Text type or string constant or calculation producing text and a format string Example Object.DateAttr = AS_DATE ('02-25-2007', 'MM-dd-yyyy') text/html 2023-05-08T06:27:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/as_number?rev=1683527242&do=diff index function function_list text AS_NUMBER Description Converts the given string into a number. If a string cannot be converted the original string is returned. Parameters Attribute of the Plain Text type or string constant or calculation producing text Example IF AS_NUMBER(Account.Text)= 5 THEN ... text/html 2023-05-08T06:27:36+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/as_string?rev=1683527256&do=diff index function function_list text AS_STRING Description Converts the given attribute or expression of the Number, Date, Timestamp, Yes/No or Plain Text types into a string. Parameters Attribute or expression of the Number, Date, Timestamp, Yes/No or Plain Text types Example IF AS_STRING (Account.Number) = '5' THEN ... text/html 2023-05-08T06:27:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/as_timestamp?rev=1683527275&do=diff index function function_list text AS_TIMESTAMP Description Converts the given string into a timestamp according to the specified format. Parameters Attribute of the Plain Text type or string constant or calculation producing text and a format string Example Object.TimeStampAttr = AS_TIMESTAMP ('02-25-2007 10:05', 'MM-dd-yyyy HH:mm') text/html 2023-05-08T06:28:09+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/bsv_version?rev=1683527289&do=diff index function function_list miscellaneous version:v5.0 BSV_VERSION Description Returns the version number of the business space version as shown in the Configuration Tool Parameters None Example DISPLAY MESSAGE BSV_VERSION() text/html 2023-05-08T07:04:00+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/business_day_back?rev=1683529440&do=diff index function function_list date_and_time BUSINESS_DAY_BACK Description Calculates the date that corresponds to the first business day before the provided date. Business days are usually those that do not include weekends and public holidays. The list of public holidays may be provided in the text/html 2023-05-08T07:04:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/business_day_forward?rev=1683529455&do=diff index function function_list date_and_time BUSINESS_DAY_FORWARD Description Calculates the date that corresponds to the first business day after the provided date. Business days are usually those that do not include weekends and public holidays. The list of public holidays may be provided in the text/html 2023-05-08T07:04:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/ceiling?rev=1683529490&do=diff index function function_list mathematical CEILING Description Returns the smallest integer number that is not less than the provided number: * CEILING (5.67) = 6; * CEILING (-5.57) = -5 Parameters Attribute of the Number type or number constant or calculation producing number Example text/html 2023-05-08T07:05:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/chars_from_left?rev=1683529501&do=diff index function function_list text CHARS_FROM_LEFT Description Returns the text being the specified number of the leftmost characters in the provided text Parameters Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of characters to retrieve text/html 2023-05-08T07:05:42+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/chars_from_right?rev=1683529542&do=diff index function function_list text CHARS_FROM_RIGHT Description Returns the text being the specified number of the rightmost characters in the provided text Parameters Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of characters to retrieve text/html 2023-05-08T07:05:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/context_size?rev=1683529556&do=diff index function function_list miscellaneous version:v8.6 CONTEXT_SIZE Description Determines the number of instances of the specified business object currently in Context. Can be useful if one needs to determine the number of objects that user selected in the process that handles multiple selection. Parameters text/html 2023-05-08T07:06:13+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/cr?rev=1683529573&do=diff index function function_list text version:v8.4 CR Description Generates new line symbol Parameters None Example Company.Address = Company.Address1 + CR() + Company.Address2 text/html 2023-05-08T07:06:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/currency_symbol?rev=1683529587&do=diff index function function_list financial version:v4.8 CURRENCY_SYMBOL Description Returns the currency symbol for the given currency code Parameters Currency code, for example USD Example CURRENCY_SYMBOL('USD') text/html 2023-05-08T07:06:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_date?rev=1683529606&do=diff index function function_list date_and_time CURRENT_DATE Description Returns current date as the date constant Parameter None Example Account.OpeningDate=CURRENT_DATE text/html 2023-05-08T07:07:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_day_of_month?rev=1683529621&do=diff index function function_list date_and_time CURRENT_DAY_OF_MONTH Description Returns current day of the month as an integer constant in the range 1-31 Parameters None Example IF CURRENT_DAY_OF_MONTH = 8 THEN ... text/html 2023-05-08T07:07:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_day_of_week?rev=1683529634&do=diff index function function_list date_and_time CURRENT_DAY_OF_WEEK Description Returns current day of the week as a string constant ('Monday', 'Tuesday', etc) Parameters None Example IF CURRENT_DAY_OF_WEEK = 'Saturday' Then ... text/html 2023-05-08T07:07:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_day_of_year?rev=1683529647&do=diff index function function_list date_and_time CURRENT_DAY_OF_YEAR Description Returns current day of the year as an integer constant in the range 1-366 Parameters None Example IF CURRENT_DAY_OF_YEAR = 8 THEN ... text/html 2023-05-08T07:07:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_hour?rev=1683529663&do=diff index function function_list date_and_time CURRENT_HOUR Description Returns current hour as an integer constant in the range 0-23 Parameters None Example IF CURRENT_HOUR = 12 Then DISPLAY MESSAGE 'Midday!' text/html 2023-05-08T07:07:52+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_minute?rev=1683529672&do=diff index function function_list date_and_time CURRENT_MINUTE Description Returns current minute as an integer constant in the range 0-59 Parameters None Example IF CURRENT_MINUTE = 45 Then ... text/html 2023-05-08T07:08:05+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_month?rev=1683529685&do=diff index function function_list date_and_time CURRENT_MONTH Description Returns current month as an integer constant in the range 1-12 Parameters None Example IF CURRENT_MONTH = 1 Then ... text/html 2023-05-08T07:08:16+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_timestamp?rev=1683529696&do=diff index function function_list date_and_time CURRENT_TIMESTAMP Description Returns current date and time as the timestamp Parameters None Example Transaction.Time = CURRENT_TIMESTAMP text/html 2023-05-08T07:08:29+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_week?rev=1683529709&do=diff index function function_list date_and_time CURRENT_WEEK Description Returns current week as an integer constant in the range 1-52 Parameters None Example IF CURRENT_WEEK = 1 THEN SEND GreetingEmail TO Customer text/html 2023-05-08T07:08:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/current_year?rev=1683529723&do=diff index function function_list date_and_time CURRENT_YEAR Description Returns current year as an integer constant Parameters None Example IF CURRENT_YEAR = 2004 THEN ... text/html 2023-05-08T07:10:29+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/date?rev=1683529829&do=diff index function function_list date_and_time DATE Description Returns the date constant built from the given numbers Parameters An integer constant indicating day (1-31), an integer constant indicating month (1-12), an integer constant indicating year Example IF DATE (DAY_OF_MONTH (Account.OpeningDate), 4, 2004) = 07/04/2004 THEN ... text/html 2023-05-08T07:10:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/date_add?rev=1683529846&do=diff index function function_list date_and_time DATE_ADD Description: Returns the date resulting from adding/subtracting the specified number of days to the specified date Parameters An expression producing date and an expression producing a number to be added or subtracted (if the number is negative) to the date text/html 2023-05-08T07:16:48+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/date_part?rev=1683530208&do=diff index function function_list date_and_time DATE_PART Description Returns the date part of the given timestamp Parameters Timestamp Example IF DATE_PART (Account.OpeningDateTime) = 07/04/2004 THEN ... text/html 2023-05-08T07:27:37+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/days?rev=1683530857&do=diff index function function_list date_and_time DAYS Description Returns an integer constant indicating the number of days in the provided duration Parameters Attribute of the Duration type or duration constant or calculation producing duration Example IF DAYS (Task.Duration) = 5 THEN ... text/html 2023-05-08T07:17:06+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/day_difference?rev=1683530226&do=diff index function function_list date_and_time DAY_DIFFERENCE Description Calculates the day difference between the two dates as an integer constant Parameters Two attributes of the Date type or date constants or calculations producing date Example IF DAY_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 3 THEN ... text/html 2023-05-09T00:47:32+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/day_difference2?rev=1683593252&do=diff index function function_list date_and_time DAY_DIFFERENCE2 Description Calculates the day difference between the first date and the second date ignoring years of the dates. For example: DAY_DIFFERENCE2 (15/06/1985, 17/06/1998) = 2 (the difference between 15 of June and 17 of June is 2) DAY_DIFFERENCE2 text/html 2023-05-09T00:47:16+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/day_number_in_week?rev=1683593236&do=diff index function function_list date_and_time DAY_NUMBER_IN_WEEK Description Returns day of week of the provided date (1 for Sunday, 2 for Monday etc) Parameters Attribute of the Date type or date constant or calculation producing date Example IF DAY_NUMBER_IN_WEEK (Account.OpeningDate=1) THEN ... text/html 2023-05-08T07:28:48+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/day_of_month?rev=1683530928&do=diff index function function_list date_and_time DAY_OF_MONTH Description Returns day of month of the provided date as an integer constant in the range 1-31 Parameters Attribute of the Date type or date constant or calculation producing a date Example IF DAY_OF_MONTH (Account.OpeningDate=25) THEN ... text/html 2023-05-08T07:28:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/day_of_week?rev=1683530913&do=diff index function function_list date_and_time DAY_OF_WEEK Description Returns day of week of the provided date as a string ('Monday', 'Tuesday' etc) Parameters Attribute of the Date type or date constant or calculation producing a date Example IF DAY_OF_WEEK (Account.OpeningDate='Wednesday') THEN ... text/html 2023-05-08T07:27:58+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/day_of_year?rev=1683530878&do=diff index function function_list date_and_time DAY_OF_YEAR Description Returns day of year of the provided date as an integer constant in the range 1-366| Parameters Attribute of the Date type or date constant or calculation producing a date| Example IF DAY_OF_YEAR (Account.OpeningDate=250) THEN ... text/html 2025-06-12T03:59:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/decrypt_b64?rev=1749700774&do=diff index function function_list miscellaneous DECRYPT_B64 Description Provides BASE64 with XOR shift decryption of the specified string. Can be used to encrypt AwareIM links – see Login Parameters Parameters An attribute of the Plain Text type or an expression producing a string Example DISPLAY URL 'logonOp.aw?e=ENCRYPT_B64(`domain=Test&userName=john&password=123`)' text/html 2023-05-08T07:17:32+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/decrypt_base64?rev=1683530252&do=diff index function function_list miscellaneous version:v8.7 DECRYPT_BASE64 Description Provides BASE64 decryption of the specified string. Parameters An attribute of the Plain Text type or an expression producing a string Example Object.Attr=DECRYPT_BASE64('abc') text/html 2023-05-08T07:17:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/distance?rev=1683530239&do=diff index function function_list miscellaneous DISTANCE Description Returns the distance between two addresses or locations in metres Parameters Two addresses or locations as Plain Text and a Google Maps key as PlainText. A location can be specified as two geo coordinates separated by comma Example text/html 2024-01-28T06:09:53+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/dq?rev=1706422193&do=diff index function function_list text version:v9.0 DQ Description Adds double quotation marks to the text Parameters None Example Object.Attribute = '<a style=' + DQ() + 'color:red' + DQ() + '/a>' text/html 2023-05-09T00:48:26+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/element_count?rev=1683593306&do=diff index function function_list reports_and_documentation ELEMENT_COUNT Description Returns number of elements in a report, page, column or group (which is specified by pressing the Evaluation Details button in the Report/Presentation Designer – see editing tag elements) Parameters None Example (to be used only inside tags in the Report Designer) text/html 2023-05-09T00:48:38+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/element_counter?rev=1683593318&do=diff index function function_list reports_and_documentation ELEMENT_COUNTER Description Returns the number of an element in the report, page, column or group (which is specified by pressing the Evaluation Details button in the Report/Presentation Designer – see editing tag elements). For example, if Details band contains 5 elements the value of the function for the first element will be 1, the second – 2 etc. text/html 2025-06-12T03:59:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/encrypt_b64?rev=1749700774&do=diff index function function_list miscellaneous ENCRYPT_B64 Description Provides BASE64 with XOR shift encryption (decryption) of the specified string. Can be used to encrypt AwareIM links – see Login Parameters Parameters An attribute of the Plain Text type or an expression producing a string Example DISPLAY URL 'logonOp.aw?e=ENCRYPT_B64('domain=Test&userName=john&password=123') text/html 2023-05-09T00:49:02+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/encrypt_base64?rev=1683593342&do=diff index function function_list miscellaneous version:v8.7 ENCRYPT_BASE64 Description Provides BASE64 encryption (decryption) of the specified string. Parameters An attribute of the Plain Text type or an expression producing a string Example Object.Attr=ENCRYPT_BASE64('abc') text/html 2023-05-09T00:49:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/encrypt_doc_base64?rev=1683593352&do=diff index function function_list files version:v8.6 ENCRYPT_DOC_BASE64 Description Returns a string that represents BASE64 encryption of the bytes of the specified document. Parameters An attribute of the Document type or an expression producing a Document Example Object.StrAttr = ENCRYPT_DOC_BASE64(Object.DocAttr) text/html 2023-05-09T00:49:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/end_of_week?rev=1683593362&do=diff index function function_list date_and_time END_OF_WEEK Description Returns a date being Sunday of the week that the parameter date represents Parameters Attribute of the Date type or duration constant or calculation producing Date Example Account.EndOfWeek = END_OF_WEEK(CURRENT_DATE) text/html 2023-05-09T00:51:05+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/eval_string?rev=1683593465&do=diff index function function_list miscellaneous version:v8.1 EVAL_STRING Description Evaluates the specified string as if it was a condition of the Rule Language. Returns the result of evaluation, which can either be a numeric value or “Yes/No” value Parameters An expression providing a string. Two optional extra parameters specify what should happen when condition evaluates to Yes or No (see the last example) text/html 2025-06-12T03:59:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/exact?rev=1749700774&do=diff index function function_list miscellaneous EXACT Description By default AwareIM automatically translates explicit strings used in rules using the current locale. This function allows to bypass this mechanism and use strings as they are specified in the function Parameters A string to use text/html 2023-05-09T00:51:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/exec_spf?rev=1683593515&do=diff index function function_list mathematical version:v8.4 EXEC_SPF Description Executes the specified stored procedure and returns a value in the OUT parameter of the stored procedure. The stored procedure must have one and only one OUT parameter defined. All other parameters (if any) should be IN parameters. The returned valus is of Plain Text type. If you need to convert it to number use the text/html 2023-05-09T00:52:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/exp?rev=1683593535&do=diff index function function_list mathematical EXP Description Returns the exponential number raised to the power of the provided number Parameters Attribute of the Number type or number constant or calculation producing number Example IF EXP (Transaction.Amount)=10 THEN ... text/html 2023-05-09T00:54:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/file_exists?rev=1683593652&do=diff index function function_list files FILE_EXISTS Description Checks if the specified file or directory exists Parameters An expression returning a string identifying a file or directory name Example IF FILE_EXISTS('c:/myfile.txt') = 'Yes' THEN DISPLAY MESSAGE ('File exists') text/html 2023-05-09T00:54:25+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/file_extension?rev=1683593665&do=diff index function function_list files FILE_EXTENSION Description Returns the extension of the specified file or document Parameters An expression returning a string identifying a file or directory name or an attribute of the Document type Example DISPLAY MESSAGE ('File extension is ' + FILE_EXTENSION('c:/myfile.txt')) text/html 2023-05-09T00:54:37+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/file_last_modified?rev=1683593677&do=diff index function function_list files FILE_LAST_MODIFIED Description Returns the date when the specified file was last modified Parameters An expression returning a string identifying a file or directory name Example DISPLAY MESSAGE ('File modified ' + AS_STRING(FILE_LAST_MODIFIED('c:/myfile.txt'))) text/html 2023-05-09T00:54:49+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/file_name?rev=1683593689&do=diff index function function_list files FILE_NAME Description Returns the name of the specified file or document without the extension Parameters An expression returning a string identifying a file or directory name or an attribute of the Document type Example DISPLAY MESSAGE ('File name is ' + FILE_NAME('c:/myfile.txt')) text/html 2023-05-09T00:55:00+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/file_size?rev=1683593700&do=diff index function function_list files FILE_SIZE Description Returns the size of the specified file or document in bytes Parameters An expression returning a string identifying a file or directory name or an attribute of the Document type Example DISPLAY MESSAGE ('File size is ' + FILE_SIZE('c:/myfile.txt')) text/html 2023-05-09T00:55:21+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/first_day_of_month?rev=1683593721&do=diff index function function_list date_and_time FIRST_DAY_OF_MONTH Description Calculates the date that corresponds to the first day of month of the provided date Parameters Attribute of the Date type or date constant or calculation producing a date Example IF FIRST_DAY_OF_MONTH (Account.OpeningDate=01/10/2004) THEN ... text/html 2023-05-09T00:55:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/first_day_of_next_month?rev=1683593733&do=diff index function function_list date_and_time FIRST_DAY_OF_NEXT_MONTH Description Calculates the date corresponding to the first day of the next month of the provided date Parameters Attribute of the Date type or date constant or calculation producing a date| Example IF FIRST_DAY_OF_NEXT_MONTH (Account.OpeningDate=01/11/2004) THEN ... text/html 2023-05-09T00:55:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/first_day_of_prev_month?rev=1683593746&do=diff index function function_list date_and_time FIRST_DAY_OF_PREV_MONTH Description Calculates the date corresponding to the first day of the previous month of the provided date Parameters Attribute of the Date type or date constant or calculation producing a date Example IF FIRST_DAY_OF_PREV_MONTH (Account.OpeningDate=01/09/2004) THEN ... text/html 2023-05-09T00:55:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/floor?rev=1683593757&do=diff index function function_list mathematical FLOOR Description Returns the largest integer number that is not greater than the provided number: * FLOOR (5.67) = 5; * FLOOR (-5.57) = -6 Parameters Attribute of the Number type or number constant or calculation producing number Example text/html 2023-05-09T00:56:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/full_years?rev=1683593772&do=diff index function function_list date_and_time FULL_YEARS Description Calculates the number of full years between the two dates as an integer constant. Full year difference between 31/12/2004 and 01/01/2005 is 0 Parameters Two attributes of the Date type or date constants or calculations producing date| text/html 2023-05-09T00:56:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/fv?rev=1683593787&do=diff index function function_list financial FV Description Calculates the future value of an investment based on periodic constant payments and a constant interest rate Parameters * Rate – interest rate per period (in percents, 50% is 0.5). * Nper – total number of payment periods in an annuity text/html 2023-05-09T00:56:58+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/generate_pwd?rev=1683593818&do=diff index function function_list miscellaneous GENERATE_PWD Description Generates random string that can be used as string password Parameters * Min. number of characters in the password * Max. number of characters in the password * Number of capital letters * Number of digits * Number of special characters text/html 2023-07-28T04:23:37+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/get_attr_value?rev=1690518217&do=diff index function function_list miscellaneous version:v8.8 GET_ATTR_VALUE Description This function is useful when you have to get an attribute value of a certain instance in Context (where there are multiple instances of the object of the required type in the Context). These instances must be placed in the Context by an ordered query, for example text/html 2023-05-09T00:57:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/get_changes?rev=1683593847&do=diff index function function_list miscellaneous GET_CHANGES Description If an object was changed returns which attributes have been changed as well as old and new values Parameters Object name that has been changed Example IF MyObject WAS CHANGED THEN CREATE AuditRecord WITH AuditRecord.Description = GET_CHANGES(MyObject) text/html 2023-05-09T00:57:40+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/group_member?rev=1683593860&do=diff index function function_list miscellaneous GROUP_MEMBER Description Returns ‘Yes’ if the specified business object belongs to the specified business object group Parameters * String identifying the business object * String identifying the business object group Example IF GROUP_MEMBER('SavingAccount', 'Account') = 'Yes' Then ... text/html 2023-05-09T00:57:51+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/hour?rev=1683593871&do=diff index function function_list date_and_time HOUR Description Returns hour of the provided date as an integer constant in the range 0-23 Parameters Attribute of the Date type or date constant or calculation producing date Example IF HOUR (Account.OpeningDate=12) THEN ... text/html 2023-05-09T00:58:02+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/hours?rev=1683593882&do=diff index function function_list date_and_time HOURS Description Returns an integer constant indicating the number of hours in the provided duration Parameters Attribute of the Duration type or duration constant or calculation producing duration Example IF HOURS (Task.Duration) = 5 THEN ... text/html 2023-05-09T00:58:13+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/image_height?rev=1683593893&do=diff index function function_list images IMAGE_HEIGHT Description Determines height of the provided image Parameters An attribute of the picture type Example IF IMAGE_HEIGHT(Object.Picture) > 800 THEN ... text/html 2023-05-09T00:58:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/image_width?rev=1683593902&do=diff index function function_list images IMAGE_WIDTH Description Determines width of the provided image Parameters An attribute of the picture type Example IF IMAGE_WIDTH(Object.Picture) > 800 THEN ... text/html 2023-05-09T00:58:42+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/index_of?rev=1683593922&do=diff index function function_list text INDEX_OF Description Returns an integer constant indicating the index of the first string within the second string. For example, INDEX_OF('fox', 'red fox') returns 5. If the first string is not contained within the second one 0 is returned. Parameters text/html 2023-05-09T00:58:32+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/in_context?rev=1683593912&do=diff index function function_list miscellaneous version:v8.6 IN_CONTEXT Description Determines if the specified business object is currently in Context Parameters The name of the object Example IF IN_CONTEXT('Customer') = 'Yes' THEN ... text/html 2023-05-09T00:59:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/last_day_of_month?rev=1683593958&do=diff index function function_list date_and_time LAST_DAY_OF_MONTH Description Calculates the date that corresponds to the last day of month of the provided date Parameters Attribute of the Date type or date constant or calculation producing a date Example IF LAST_DAY_OF_MONTH (Account.OpeningDate)=31/10/2004 THEN ... text/html 2023-05-09T00:59:28+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/last_day_of_next_month?rev=1683593968&do=diff index function function_list date_and_time LAST_DAY_OF_NEXT_MONTH Description Calculates the date that corresponds to the last day of next month of the provided date Parameters Attribute of the Date type or date constant or calculation producing a date Example IF LAST_DAY_OF_NEXT_MONTH (Account.OpeningDate)=11/2004 THEN ... text/html 2023-05-09T00:59:37+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/last_day_of_prev_month?rev=1683593977&do=diff index function function_list date_and_time LAST_DAY_OF_PREV_MONTH Description Calculates the date that corresponds to the last day of the previous month of the provided date. Parameters Attribute of the Date type or date constant or calculation producing a date Example IF LAST_DAY_OF_PREV_MONTH (Account.OpeningDate)=30/09/2004 THEN ... text/html 2023-05-09T00:59:47+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/last_index_of?rev=1683593987&do=diff index function function_list text LAST_INDEX_OF Description Returns an integer constant indicating the last index of the first string within the second string. For example, LAST_INDEX_OF(‘r, ‘bright red fox’) returns 8. If the first string is not contained within the second one 0 is returned. text/html 2023-05-09T00:59:58+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/length?rev=1683593998&do=diff index function function_list text LENGTH Description Returns an integer constant indicating the number of characters in the provided text Parameters Attribute of the Plain Text type or string constant or calculation producing text Example IF LENGTH (Account.Name) = 5 THEN ... text/html 2023-05-09T01:00:11+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/list?rev=1683594011&do=diff index function function_list miscellaneous LIST Description Prints out a list of business objects as a table where each row represents a single list member. A list may be specified as an attribute or as a query string. Only specified attributes of each list member are printed out. This function is useful when it is necessary to print out a relatively small list inside a document or inside an e-mail (usually used inside a tag). Returns a table as a text string. text/html 2023-05-09T01:00:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/list_line?rev=1683594022&do=diff index function function_list miscellaneous LIST_LINE Description Prints out members of a list as a single line. Only specified attributes of each list member are printed out. A list may be specified as an attribute or as a query string. This function is useful when it is necessary to print out a relatively small list inside a document or inside an e-mail (usually used inside a tag). Returns a line as a text string. text/html 2023-05-09T01:00:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/list_size?rev=1683594034&do=diff index function function_list miscellaneous LIST_SIZE Description Returns number of elements in the list Parameters A reference to the list Example IF LIST_SIZE (Client.Children) > 2 THEN ... text/html 2023-05-09T01:00:45+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/list_table?rev=1683594045&do=diff index function function_list reports_and_documentation LIST_TABLE Description Prints out a list of business objects as a table where each row represents a single list member. A list may be specified as an attribute or as a query string. Only specified attributes of each list member are printed out. The header of the table containing attribute names is printed automatically text/html 2025-06-12T03:59:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/list_table_end?rev=1749700774&do=diff index function function_list reports_and_documentation LIST_TABLE_END Description Whereas the LIST_TABLE function prints the entire table including the header, the combination of LIST_TABLE_START and LIST_TABLE_END functions allows using an existing header of the table. Just like the LIST_TABLE function it prints out members of a list of query results. However, you create the table in the document itself and only mark the start and end of the data. All tags in between the markers represent at… text/html 2025-06-12T03:59:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/list_table_start?rev=1749700774&do=diff index function function_list reports_and_documentation LIST_TABLE_START Description Whereas the LIST_TABLE function prints the entire table including the header, the combination of LIST_TABLE_START and LIST_TABLE_END functions allows using an existing header of the table. Just like the LIST_TABLE function it prints out members of a list of query results. However, you create the table in the document itself and only mark the start and end of the data. All tags in between the markers represent … text/html 2024-01-28T06:28:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/list_to_json?rev=1706423326&do=diff DELETE THE TAGS THAT ARE NOT APPLICABLE TO THIS FUNCTION AND THEN DELETE THIS COMMENT AND ADD THE VERSION NUMBER (LAST ITEM IN TAG LIST) THAT INTRODUCES THE FUNCTION index function function_list miscellaneous version:v9.0 LIST_TO_JSON Description Converts a list of business objects into a JSON string. Specified attributes of each list member are printed out. text/html 2023-05-09T01:03:26+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/ln?rev=1683594206&do=diff index function function_list mathematical LN Description Calculates the natural (base e) logarithm of the provided value Parameters An attribute of the Number type or number constant or a calculation producing a number Example IF LN (Transaction.Amount) = 1 THEN ... text/html 2023-05-09T01:03:42+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/log?rev=1683594222&do=diff index function function_list mathematical version:v8.1 LOG Description Calculates the base 10 logarithm of the provided value Parameters An attribute of the Number type or number constant or a calculation producing a number Example IF LOG (Transaction.Amount) = 1 THEN ... text/html 2023-05-09T01:10:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/matches?rev=1683594623&do=diff index function function_list text MATCHES Description Returns 'Yes' if the specified string matches the specified regular expression Parameters Attribute of the Plain Text type or string constant or calculation producing text and a regular expression Example IF MATCHES (Customer.PhoneNo, '[0-9]') = 'No' THEN ... text/html 2023-05-09T01:10:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/max2?rev=1683594633&do=diff index function function_list mathematical MAX2 Description Calculates the maximum of the two provided numbers Parameters Two attributes of the Number type or number constants or calculations producing number Example IF MAX2 (Transaction.Amount, Account.Balance) = 100 THEN ... text/html 2023-05-09T01:10:45+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/min2?rev=1683594645&do=diff index function function_list mathematical MIN2 Description Calculates the minimum of the two provided numbers Parameters Two attributes of the Number type or number constants or calculations producing number Example IF MIN2 (Transaction.Amount, Account.Balance) = 100 THEN ... text/html 2023-05-09T01:10:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/minute?rev=1683594656&do=diff index function function_list date_and_time MINUTE Description Returns the minute of the provided date as an integer constant in the range 0-59 Parameters Attribute of the Date type or date constant or calculation producing a date Example IF MINUTE (Account.OpeningDate)=45 THEN ... text/html 2023-06-07T06:38:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/minutes?rev=1686119894&do=diff index function function_list date_and_time MINUTES Description Returns an integer constant indicating the number of minutes in the provided duration Parameters Attribute of the Duration type or duration constant or calculation producing duration Example IF MINUTES (Task.Duration) = 5 THEN ... text/html 2023-05-09T01:11:17+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/mod?rev=1683594677&do=diff index function function_list mathematical MOD Description Calculates the remainder of the first number divided by the second one Parameters Two attributes of the Number type or number constants or calculations producing number Example IF MOD (Account.Balance, Transaction.Amount) = 10 THEN ... text/html 2023-05-09T01:11:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/month?rev=1683594687&do=diff index function function_list date_and_time MONTH Description Returns the month of the provided date as an integer constant in the range 1-12 Parameters Attribute of the Date type or date constant or calculation producing a date Example IF MONTH (Account.OpeningDate)=12 THEN ... text/html 2023-05-09T01:11:37+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/month_add?rev=1683594697&do=diff index function function_list date_and_time MONTH_ADD Description Returns the date resulting from adding/subtracting the specified number of months to the specified date Parameters An expression producing date and an expression producing a number to be added or subtracted (if the number is negative) to the date text/html 2023-05-09T01:11:47+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/month_difference?rev=1683594707&do=diff index function function_list date_and_time MONTH_DIFFERENCE Description Calculates the month difference between the two dates as an integer constant Parameters Two attributes of the Date type or date constants or calculations producing a date Example IF MONTH_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 5 THEN ... text/html 2023-05-09T01:11:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/month_difference2?rev=1683594717&do=diff index function function_list date_and_time MONTH_DIFFERENCE2 Description Calculates the month difference between the first date and the second date ignoring years. For example: MONTH_DIFFERENCE2 (15/06/1985, 17/07/1998) = 1 (the difference between June and July is 1) MONTH_DIFFERENCE2 (15/06/1985, 14/05/1973) = 11 text/html 2023-05-09T01:12:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/month_text?rev=1683594728&do=diff index function function_list date_and_time version:v8.6 MONTH_TEXT Description Returns the name of the specified month as text Parameters * A number indicating the month - 1 for January, 2 for February etc Example IF MONTH_TEXT (CURRENT_MONTH) = 'January' THEN ... text/html 2023-05-09T01:14:04+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/nab_of_sessions?rev=1683594844&do=diff index function function_list miscellaneous version:v4.8 NMB_OF_SESSIONS Description Returns the number of time a particular user is logged in the system, 0 is returned if the user is not logged in Parameters An instance of an object that belongs to the SystemUser group Example IF NMB_OF_SESSIONS(RegularUser) > 1 THEN REPORT ERROR 'User can only be logged in once' text/html 2023-05-09T01:12:41+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/native_mobile_mode?rev=1683594761&do=diff index function function_list miscellaneous NATIVE_MOBILE_MODE Description Return 'Yes' if the current user is running a native mobile application. Can only be used in applicability conditions! Parameters None Example NATIVE_MOBILE_MODE()='Yes' text/html 2023-05-09T01:12:51+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/neg?rev=1683594771&do=diff index function function_list mathematical NEG Description Returns the provided number negated Parameters Attribute of the Number type or number constant or calculation producing number Example IF NEG (Transaction.Amount) = -10 THEN ... text/html 2023-05-09T01:13:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/nesting_level?rev=1683594781&do=diff index function function_list reports_and_documentation NESTING_LEVEL Description Returns the level of nesting of the currently executing subreport. Master report has nesting level 0, the subreport of the master report has nesting level 1, the subreport of the subreport has nesting level 2 etc. To be used only inside tags in the Report Designer text/html 2023-05-09T01:13:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/next_day_of_week?rev=1683594794&do=diff index function function_list date_and_time version:v8.1 NEXT_DAY_OF_WEEK Description Returns the next day of the week closest to the specified date Parameters An expression producing a date and a string identifying the day Example Object.NextDay = NEXT_DAY_OF_WEEK (CURRENT_DATE, 'Tuesday') /** This returns next Tuesday from current date**/ text/html 2023-07-28T04:25:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/next_sequence_nmb?rev=1690518301&do=diff index function function_list miscellaneous version:v8.4 NEXT_SEQUENCE_NMB Description Returns next value of the specified auto-incremented attrubute Parameters * Name of the business object that owns the auto-incremented attribute * Name of the auto-incremented attribute * Optional expression that calculates the value identifying group of instances as specified in the auto-incremented attribute text/html 2023-05-09T01:13:38+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/next_sequence_time?rev=1683594818&do=diff index function function_list date_and_time version:v8.5 NEXT_SEQUENCE_TIME Description Defines a time sequence that starts at a particular minute of a particular hour and then occurs every few minutes. Returns “Yes” if the current time coincides with the sequence occurrence. Parameters identifier of the time sequence (any text that has to be unique across all sequences), minutes of the hour when the sequence starts and time interval of the sequence in minutes text/html 2025-01-09T06:44:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/nformat?rev=1736405074&do=diff index function function_list mathematical version:v8.5 NFORMAT Description Formats a number differently depending on its value – whether it is positive, negative or zero. Returns formatted number Parameters expression, such as SUM, format of the positive non-zero value; format of the zero value; optional format of the negative value text/html 2025-06-12T03:59:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/nmb_of_users?rev=1749700774&do=diff index function function_list miscellaneous NMB_OF_USERS Description Returns the number of licensed users for the current AwareIM license or –1 if evaluation version Parameters None Example IF Object.Count > NMB_OF_USERS() THEN REPORT ERROR 'Error' text/html 2023-05-09T01:14:28+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/nper?rev=1683594868&do=diff index function function_list financial NPER Description Calculates total number of payment periods in an annuity Parameters * Rate – interest rate per period (in percents, 50% is 0.5). * Payment – payment made each period * Future value (optional) – future value or the cash balance that is attained after the last payment is made. If omitted assumed to be 0 text/html 2023-05-09T01:14:38+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/number_of_pages?rev=1683594878&do=diff index function function_list reports_and_documentation NUMBER_OF_PAGES Description Returns the number of pages in a report To be used only inside tags in the Report Designer Parameters None Example text/html 2023-05-09T01:15:05+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/old_value?rev=1683594905&do=diff index function function_list miscellaneous OLD_VALUE Description Returns the old value of the attribute before it was changed Parameters An attribute of a business object or group Example IF OLD_VALUE(Account.Balance) = 100 THEN ... text/html 2023-05-09T01:15:31+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/pad_left?rev=1683594931&do=diff index function function_list text PAD_LEFT Description Pads the given string on the left with the specified character Parameters Attribute of the Plain Text type or string constant or calculation producing text identifying the string to pad; the character to pad with; the resulting length of the string text/html 2023-05-09T01:15:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/pad_right?rev=1683594943&do=diff index function function_list text PAD_RIGHT Description Pads the given string on the right with the specified character Parameters Attribute of the Plain Text type or string constant or calculation producing text identifying the string to pad; the character to pad with; the resulting length of the string text/html 2023-05-09T01:15:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/page_number?rev=1683594955&do=diff index function function_list reports_and_documentation PAGE_NUMBER Description Returns the current page number in a report To be used only inside tags in the Report Designer Parameters None Example text/html 2023-05-09T01:16:05+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/parse_json?rev=1683594965&do=diff index function function_list text version:v8.6 PARSE_JSON Description Parses the specified string in JSON format and extracts a value according to the specified path Parameters Attribute of the Plain Text type or string constant or calculation producing text identifying the string in JSON format to parse and the path in JSONPath format (see text/html 2024-05-16T03:49:29+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/parse_json2?rev=1715831369&do=diff DELETE THE TAGS THAT ARE NOT APPLICABLE TO THIS FUNCTION AND THEN DELETE THIS COMMENT AND ADD THE VERSION NUMBER (LAST ITEM IN TAG LIST) THAT INTRODUCES THE FUNCTION index function function_list text version:9.0 PARSE JSON2 Description Returns the value of the specified attribute in the same node text/html 2023-05-09T01:16:16+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/parse_xml?rev=1683594976&do=diff index function function_list text version:v8.6 PARSE_XML Description Parses the specified string in XML format and extracts a value according to the specified path Parameters Attribute of the Plain Text type or string constant or calculation producing text identifying the string in XML format to parse and the path in XPath format (see text/html 2023-05-09T01:16:30+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/pmt?rev=1683594990&do=diff index function function_list financial PMT Description Calculates payment to be made each period Parameters * Rate – interest rate per period (in percents, 50% is 0.5). * Nper – total number of payment periods in an annuity * Future value (optional) – future value or the cash balance that is attained after the last payment is made. If omitted assumed to be 0 text/html 2023-05-09T01:16:41+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/power?rev=1683595001&do=diff index function function_list mathematical POWER Description Returns the value of the first number raised to the power of the second number Parameters Two attributes of the Number type or number constants or calculations producing number Example IF POWER (Transaction.Amount, 2) = 100 THEN ... text/html 2023-05-09T01:16:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/prev_day_of_week?rev=1683595016&do=diff index function function_list date_and_time version:v8.1 PREV_DAY_OF_WEEK Description Returns the previous day of the week closest to the specified date Parameters An expression producing a date and a string identifying the day Example Object.PrevDay = PREV_DAY_OF_WEEK (CURRENT_DATE, 'Tuesday') /** This returns previous Tuesday from current date*/ text/html 2023-05-09T01:17:07+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/pv?rev=1683595027&do=diff index function function_list financial PV Description Calculates present value of an investment. The present value is the total amount that a series of future payments is worth now Parameters * Rate – interest rate per period (in percents, 50% is 0.5). * Nper – total number of payment periods in an annuity text/html 2025-03-28T09:15:17+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/random?rev=1743153317&do=diff index function function_list mathematical RANDOM Description Calculates randomly generated number as a floating point constant in the range of 0-1 Parameters None Example Account.Key = RANDOM() text/html 2023-05-09T01:17:29+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/read_text_file?rev=1683595049&do=diff index function function_list files version:v8.1 READ_TEXT_FILE Description Returns the textual contents of the specified file Parameters An expression returning a string identifying the full path of the textual file Example Object.Attribute = READ_TEXT_FILE('c:/temp/myFile.txt') text/html 2023-05-09T01:17:42+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/replace_pattern?rev=1683595062&do=diff index function function_list text REPLACE_PATTERN Description Returns the text being the replacement of all occurrences of the old pattern in the provided text with the new pattern Parameters Attribute of the Plain Text type or string constant or calculation producing text; the text indicating the old pattern (supports format of regular expressions) and the text indicating the new pattern text/html 2023-05-09T01:17:52+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/round?rev=1683595072&do=diff index function function_list mathematical ROUND Description Returns the first number rounded to the precision of the second number. For example, * ROUND (6.738, 1) = 6.7; * ROUND (6.738, 2) = 6.74 Parameters Two attributes of the Number type or number constants or calculations producing number text/html 2023-05-09T01:18:27+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/scale_image?rev=1683595107&do=diff index function function_list images version:v5.0 SCALE_IMAGE Description Scales the given image to the specified width and height Parameters An attribute of the picture type and two numbers representing width and height respectively Example Object.ScaledImage = SCALE_IMAGE(Object.OrgImage, 30, 30) text/html 2023-05-09T01:18:44+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/search_count?rev=1683595124&do=diff index function function_list miscellaneous SEARCH_COUNT Description Returns the number of object instances found by the last query Parameters None Example FIND ALL Account IF SEARCH_COUNT = 1 THEN DISPLAY MESSAGE ('One account was found') text/html 2023-05-09T01:18:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/seconds?rev=1683595135&do=diff index function function_list date_and_time SECONDS Description Returns an integer constant indicating the number of seconds in the provided duration Parameters Attribute of the Duration type or duration constant or calculation producing duration Example IF SECONDS (Task.Duration) = 5 THEN ... text/html 2023-05-09T01:19:13+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/sign?rev=1683595153&do=diff index function function_list mathematical SIGN Description Returns the sign of the provided number (0, 1 or –1) Parameters Attribute of the Number type or number constant or calculation producing number Example IF SIGN (Transaction.Amount) = -1 THEN ... text/html 2023-05-09T01:19:23+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/sqrt?rev=1683595163&do=diff index function function_list mathematical SQRT Description Calculates the square root of the provided number Parameters Attribute of the Number type or number constant or calculation producing number Example IF SQRT (Transaction.Amount) = 10 THEN ... text/html 2023-05-09T01:19:32+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/start_of_week?rev=1683595172&do=diff index function function_list date_and_time START_OF_WEEK Description Returns a date being Monday of the week that the parameter date represents Parameters Attribute of the Date type or duration constant or calculation producing Date Example Account.StartOfWeek = START_OF_WEEK(CURRENT_DATE) text/html 2023-05-09T01:19:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/substring?rev=1683595190&do=diff index function function_list text SUBSTRING Description Extracts a string between two indexes of the given string (the second index is not inclusive) Parameters Attribute of the Plain Text type or string constant or calculation producing text and two indexes Example IF SUBSTRING (Account.Name, 0, 4) = 'John' THEN ... text/html 2023-05-09T01:19:41+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/sub_document?rev=1683595181&do=diff index function function_list reports_and_documentation SUB_DOCUMENT Description Includes a subdocument inside a master document. The source of data for the sub-document is specified as the first parameter of the function. The sub-document will be included for each instance of the business object in the data source. text/html 2023-05-09T01:19:59+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/testing_mode?rev=1683595199&do=diff index function function_list miscellaneous version:v7.0 TESTING_MODE Description Return 'Yes' if the current user is running in the testing mode Parameters None Example IF TESTING_MODE() = 'Yes' THEN ... text/html 2023-05-09T01:20:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/timestamp?rev=1683595218&do=diff index function function_list date_and_time TIMESTAMP Description Returns the timestamp constant built from the given numbers Parameters An integer constant indicating day (1-31), an integer constant indicating month (1-12), an integer constant indicating year, an integer constant indicating hours (0-23), an integer constant indicating minutes (0-59). text/html 2023-05-09T01:20:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/time_add?rev=1683595208&do=diff index function function_list date_and_time TIME_ADD Description Returns the timestamp resulting from adding/subtracting the specified number of hours to the specified timestamp Parameters An expression producing timestamp and an expression producing a number to be added or subtracted (if the number is negative) to the timestamp text/html 2023-05-09T01:20:29+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/to_lower_case?rev=1683595229&do=diff index function function_list text TO_LOWER_CASE Description Returns the text being the lower case representation of the provided text Parameters Attribute of the Plain Text type or string constant or calculation producing text Example IF TO_LOWER_CASE (Account.Name) = 'john smith' THEN ... text/html 2023-05-09T01:20:40+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/to_proper_case?rev=1683595240&do=diff index function function_list text version:v7.0 TO_PROPER_CASE Description Returns the text being the ‘proper’ case representation of the provided text. * “bill sMith” becomes “Bill Smith” * “o’mailey” becomes “O’Mailey” Parameters Attribute of the Plain Text type or string constant or calculation producing text text/html 2023-05-09T01:20:49+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/to_timezone?rev=1683595249&do=diff index function function_list date_and_time version:v8.4 TO_TIMEZONE Description Converts specified timestamp into the specified timezone Parameters An expression producing timestamp and an expression identifying the timezone (string) Example TO_TIMEZONE(Object.Timestamp, RegularUser.TimeZone) text/html 2023-05-09T01:21:01+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/to_upper_case?rev=1683595261&do=diff index function function_list text TO_UPPER_CASE Description Returns the text being the upper case representation of the provided text Parameters Attribute of the Plain Text type or string constant or calculation producing text Example IF TO_UPPER_CASE (Account.Name) = 'JOHN SMITH' THEN ... text/html 2023-05-09T01:21:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/translate?rev=1683595274&do=diff index function function_list text TRANSLATE Description Translates the specified string to the locale of the current user if it is defined. Returns the translated string. If no locale is defined the original string is returned. Parameters Attribute of Plain Text type or expression producing Plain Text representing a string. There is also an optional second parameter indicating the name of the locale. text/html 2025-02-07T01:08:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/trim?rev=1738890530&do=diff index function function_list text version:v5 TRIM Description Removes leading and trailing spaces at the start and end of the string Parameters A string or an expression producing a string Example IF TRIM ('Some string ') = 'abc' THEN ... text/html 2023-05-09T01:21:35+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/type?rev=1683595295&do=diff index function function_list miscellaneous process business_rule TYPE Description Returns the specific type of the member of the business object group as a string constant Cannot be used in queries Parameters The name of the business object group Example IF TYPE (Account) = 'PersonalSavingAccount' THEN ... text/html 2023-05-09T01:23:45+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/url_contents?rev=1683595425&do=diff index function function_list miscellaneous URL_CONTENTS Description Calls the specified URL and returns its response as text. Parameters URL to call Example Object.URLContents = URL_CONTENTS('http://www.test.com') text/html 2023-05-09T01:23:54+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/url_decode?rev=1683595434&do=diff index function function_list text version:v8.1 URL_DECODE Description Convert the string into a representation that can be used in a URL replacing spaces and other special symbols Parameters Attribute of the Plain Text type or string constant or calculation producing text Example NO EXAMPLE text/html 2023-05-09T01:24:04+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/url_encode?rev=1683595444&do=diff index function function_list text version:v8.1 URL_ENCODE Description Convert the string into a representation that can be used in a URL replacing spaces and other special symbols Parameters Attribute of the Plain Text type or string constant or calculation producing text Example DISPLAY URL URL_ENCODE(Object.Url) text/html 2023-05-09T01:24:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/week?rev=1683595454&do=diff index function function_list date_and_time WEEK Description Returns the week of the provided date as an integer constant in the range 1-52 Parameters Attribute of the Date type or date constant or calculation producing a date Example IF WEEK (Account.OpeningDate=50) THEN ... text/html 2023-05-09T01:24:39+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/weeks?rev=1683595479&do=diff index function function_list date_and_time WEEKS Description Returns an integer constant indicating the number of weeks in the provided duration Parameters Attribute of the Duration type or duration constant or calculation producing duration Example IF WEEKS (Task.Duration) = 5 THEN ... text/html 2023-05-09T01:24:26+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/week_difference?rev=1683595466&do=diff index function function_list date_and_time WEEK_DIFFERENCE Description Calculates the week difference between the two dates as an integer constant Parameters Two attributes of the Date type or date constants or calculations producing date Example IF WEEK_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 2 THEN ... text/html 2023-05-09T01:24:58+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/words_from_left?rev=1683595498&do=diff index function function_list text WORDS_FROM_LEFT Description Returns the text being the specified number of the leftmost words in the provided text. Cloudscape/Derby database only. Parameters Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of words to retrieve text/html 2023-05-09T01:25:10+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/words_from_right?rev=1683595510&do=diff index function function_list text WORDS_FROM_RIGHT Description Returns the text being the specified number of the rightmost words in the provided text. Cloudscape/Derby database only. Parameters Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of words to retrieve text/html 2023-05-09T01:24:49+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/word_number?rev=1683595489&do=diff index function function_list text WORD_NUMBER Description Returns an integer constant indicating the number of words in the provided text. Cloudscape/Derby database only. Parameters Attribute of the Plain Text type or string constant or calculation producing text Example IF WORD_NUMBER (Account.Name) > 2 THEN ... text/html 2023-05-09T01:25:24+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/year?rev=1683595524&do=diff index function function_list date_and_time YEAR Description Returns the year of the provided date as an integer constant Parameters Attribute of the Date type or date constant or calculation producing a date Example IF YEAR (Account.OpeningDate = 2004) THEN ... text/html 2023-05-09T01:25:32+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.awareim.com/dokuwiki/a_f/f/af/year_difference?rev=1683595532&do=diff index function function_list date_and_time YEAR_DIFFERENCE Description Calculates the calendar year difference between the two dates as an integer constant. Year difference between 31/12/2004 and 01/01/2005 is 1. Parameters Two attributes of the Date type or date constants or calculations producing a date