Project Toolkit

New rules

• PRO_TK_UrlEncodeString - Encodes a string for use in a URL, replacing non-ASCII or disallowed characters (such as spaces or double quotes) with compatible characters (such as %20 or %22).
• PRO_TK_FindLastOccurenceOfCharacterInString - Returns the position of the last occurrence of a given character in a string, or zero if it does not occur.
• PRO_TK_GetFieldValueDifference - Returns an array of map containing the differences between two Dictionaries, Maps, CDTs, or Records.
• PRO_TK_GetUniqueArrayItems - Returns the unique items from an array or arrays. Similar to (and uses) fn!union, but can handle multiple arrays at once.

Notes When this version of the toolkit is deployed to an environment where an older version of the toolkit already exists, it may be necessary to run the deployment twice as the first deployment may show import errors. This is because the renaming of some existing expressions may result in a number of circular dependencies that need to be resolved.

New rules

• PRO_TK_ConvertEpochToDateTime - Accepts an Epoch timestamp in milliseconds and converts it to a date and time type
• PRO_TK_CovertColumnNumberToExcelColumnName - Accepts a column number and returns the excel column name (e.g. A, F, AD, CED etc) that is equivalent to the column number
• PRO_TK_IsUserActive - Returns true if the provided username belongs to an active user, or false if it does not
• PRO_TK_Length - A replacement for the original version of this rule, which uses fn!count rather than fn!length and so will return the correct length for an array containing null entries
• PRO_TK_IsNullOrEmpty - A replacement for the original version of this rule, with behaviour matching a!isNullOrEmpty

Changes

• The original PRO_TK_Length has been renamed to PRO_TK_Length_v2_4_1 and will function as before
• The original PRO_TK_IsNullOrEmpty has been renamed to PRO_TK_IsNullOrEmpty_v2_4_1 and will function as before
• More than 60 changes to various rules to ensure all toolkit items use the new versions of PRO_TK_Length and PRO_TK_IsNullOrEmpty
• Added or updated test cases for many rules so that regression testing can be more easily performed
• Defined the Prefix and Users group in the Application properties

Bug fixes

• Added start and end of string anchors to PRO_TK_REGEX_PATTERN_POSTCODE_UK
• Added start and end of string anchors to PRO_TK_REGEX_PATTERN_SAFELINK_URL
• Added start and end of string anchors to PRO_TK_REGEX_PATTERN_TELEPHONE_NUMBER_UK

Notes When this version of the toolkit is deployed to an environment where an older version of the toolkit already exists, it may be necessary to run the deployment twice as the first deployment may show import errors. This is because renaming PRO_TK_Length and PRO_TK_IsNullOrEmpty results in a number of circular dependencies that need to be resolved.

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

New rules: PRO_TK_GetCurrentDateForUser - Returns a localised date for a given or the logged in user PRO_TK_GetCurrentDateTimeForUser - Returns a localised dateTime for a given or the logged in user

New date/datetime formatting constants: PRO_TK_FORMAT_DATE_DD_MMMM_YYYY PRO_TK_FORMAT_DATE_TIME_DD_MMMM_YYYY_HH_MM_AM_PM PRO_TK_FORMAT_DATE_TIME_DD_MMMM_YYYY_HH_MM_SS_AM_PM PRO_TK_FORMAT_DATE_TIME_DD_MMMM_YYYY_HH_MM_SS PRO_TK_FORMAT_DATE_TIME_DD_MMMM_YYYY_HH_MM

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

A brief changelog: PRO_TK_RandomiseList - New rule for randomising the the order of lists of any type. PRO_TK_IndexHelper - New rule to assist with use of PRO_TK_Index within older functions such as fn!reduce PRO_TK_GenerateUniqueRandomNumberList - renamed to PRO_TK_GenerateUniqueRandomIndices to better describe the rule functionality PRO_TK_RemoveNulls - Fixed a bug when handling certain types of empty inputs. PRO_TK_IsValidInteger - fixed a typo in the description PRO_TK_IsFalse - fixed a bug relating to the output type

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

A brief changelog:

• New rules - PRO_TK_IsTrue, PRO_TK_IsFalse and PRO_TK_IsNull - see the documentation for details
• Deprecated PRO_TK_IsNull_v2_1_1 - replaced by PRO_TK_IsNull above
• Fixed a bug in PRO_TK_ConvertAppianDateTimeToJsonDateTime caused by migration to the newer version of a!fromJson
• Removed the User record from the application to prevent overwrites of User record versions

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

A brief changelog:

• Fixed a bug with the indices calculation rule
• Added more validation rules for the various regular expressions
• Updated the PRO_TK_Index rule to handle square-bracket notation for multiple levels of nested arrays

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

A brief changelog:

• Fixed a bug with the indices calculation rule
• Added more validation rules for the various regular expressions
• Updated the PRO_TK_Index rule to handle square-bracket notation for multiple levels of nested arrays

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions

To use the toolkit, simply import it to your environment. Some aspects of the Procensol Toolkit rely upon the Regular Expression Functions plugin, so to get the most out of the toolkit you’ll need to add that to your deployment; don’t worry – it's cloud approved and very quick to deploy. The Regular Expression Functions plugin can be found here: https://community.appian.com/b/appmarket/posts/regular-expression-functions