Design – Vahana Academy

Vahana Academy

The CONCAT function is used to combine (concatenate) two or more string values into a single string. It is commonly applied in scenarios where multiple text inputs or variable values need to be merged into a unified string output. Use Case On an application page, there are two input fields: When the user enters values… Continue reading Concat

ISNULL

The ISNULL function checks if an element, attribute, system variable, or other object type contains a null value (i.e., no value assigned). If the object is null, the function returns true. If the object contains any value, including an empty one, it returns false. Use Case: The ISNULL function is used to validate mandatory fields… Continue reading ISNULL

Get Enum Object

Introduction The GETENUMOBJ function fetches the data from a mapped enumeration or enum type or object. After the GETENUMOBJ function fetches the data from the enum type, you can use it as follows: Apart from these functional scenarios, you can use the enum data in several functional requirements. For instance, you can collaboratively use the… Continue reading Get Enum Object

ISEMPTY

You can use the ISEMPTY function to check if an element, attribute, system variable, or other object type contains no value or is empty. If the ISEMPTY function finds that an element, attribute, system variable, or other object type is empty, it returns the true Boolean value. If the ISEMPTY function finds that an element,… Continue reading ISEMPTY

ISNUMERIC

This function checks characters in a string-type value. When you use the ISNUMERIC() function to check characters in a string, you can fetch the string from an attribute or element. If it finds that the string contains numeric characters, it returns the true Boolean value. If it finds that the string does not contain numeric characters, it returns the false Boolean… Continue reading ISNUMERIC

ISALPHANUMERIC

This function checks characters in a string-type value. When you use the ISALPHANUMERIC() function to check characters in a string, you can fetch the string from an attribute or element. If it finds that the string contains only alphanumeric characters, it returns the true Boolean value. If it finds that the string contains only alphabets or numeric… Continue reading ISALPHANUMERIC

IS ALPHA

This function checks characters in a string-type value. When you use the ISALPHA() function to check characters in a string, you can fetch the string from an attribute or element. If it finds that the string contains only alphabetic characters, it returns the true Boolean value. If it finds that the string contains alphanumeric or… Continue reading IS ALPHA

Subtract Years

This function subtracts a specific number of years (for example, 2) from a date with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to subtract 2 years from the 05/03/24 (5 March, 2024) date. After you use the SUBYEARS() function to subtract 2 years from the 05/03/24 date, it performs the subtraction and then returns the 05/03/22 (5 March, 2022) date. You can use the SUBYEARS function… Continue reading Subtract Years

Subtract Days

This function subtracts a specific number of days (for example, 11) from a date with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to subtract 11 days from the 25/06/24 (25 June, 2024) date. After you use the SUBDAYS() function to subtract 11 days from the 25/06/24 date, it performs the subtraction and then returns the 14/06/24 (14 June, 2024) date. You can use the SUBDAYS… Continue reading Subtract Days