Predefined validator business rules
Use predefined validator business rules to verify that field data meets specific criteria.
Tungsten TotalAgility includes predefined validators that automatically verify field data. Validators are categorized as Single Field (SF) validators that check one field, or Multi Field (MF) validators that check multiple fields together.
Validators
| Name | Type | Description |
|---|---|---|
| Validate MF Contains | MF | Validates that one field contains the value of another field. |
| Validate MF ContainsLetter | MF | Validates that a field contains at least one letter when compared to another field. |
| Validate MF ContainsSpecialCharacter | MF | Validates that a field contains at least one special character when compared to another field. |
| Validate MF EndsWith | MF | Validates that one field ends with the value of another field. |
| Validate MF Equals | MF | Validates that two fields contain equal values. |
| Validate MF IsAfter | MF | Validates that one date field is after another date field. |
| Validate MF IsAgeBetween | MF | Validates that an age calculated from a date field falls between two age values. |
| Validate MF IsAgeGreaterThan | MF | Validates that an age calculated from a date field is greater than a specified age. |
| Validate MF IsAgeLessThan | MF | Validates that an age calculated from a date field is less than a specified age. |
| Validate MF IsAmountBetween | MF | Validates that an amount field falls between two amount values. |
| Validate MF IsBefore | MF | Validates that one date field is before another date field. |
| Validate MF IsBetween | MF | Validates that a field value falls between two other field values. |
| Validate MF IsDateBetween | MF | Validates that a date field falls between two date values. |
| Validate MF IsDayOfWeek | MF | Validates that a date field matches a specified day of the week. |
| Validate MF IsExactLength | MF | Validates that a field has an exact length specified by another field. |
| Validate MF IsGreaterThan | MF | Validates that one field value is greater than another field value. |
| Validate MF IsGreaterThanOrEqual | MF | Validates that one field value is greater than or equal to another field value. |
| Validate MF IsGreaterThanZero | MF | Validates that a field value is greater than zero. |
| Validate MF IsLengthBetween | MF | Validates that the length of a field falls between two length values. |
| Validate MF IsLessThan | MF | Validates that one field value is less than another field value. |
| Validate MF IsLessThanOrEqual | MF | Validates that one field value is less than or equal to another field value. |
| Validate MF IsMaxLength | MF | Validates that a field does not exceed a maximum length specified by another field. |
| Validate MF IsMinLength | MF | Validates that a field meets a minimum length specified by another field. |
| Validate MF IsNewerThanDays | MF | Validates that a date is newer than a specified number of days. |
| Validate MF IsOlderThanDays | MF | Validates that a date is older than a specified number of days. |
| Validate MF IsWithinLastDays | MF | Validates that a date falls within the last specified number of days. |
| Validate MF IsWithinNextDays | MF | Validates that a date falls within the next specified number of days. |
| Validate MF NotEquals | MF | Validates that two fields contain different values. |
| Validate MF StartsWith | MF | Validates that one field starts with the value of another field. |
| Validate SF ContainsDigits | SF | Validates that the field contains at least one digit. |
| Validate SF ContainsLetters | SF | Validates that the field contains at least one letter. |
| Validate SF ContainsSpecialChars | SF | Validates that the field contains at least one special character. |
| Validate SF IsAlpha | SF | Validates that the field contains only alphabetic characters. |
| Validate SF IsAlphanumeric | SF | Validates that the field contains only alphanumeric characters. |
| Validate SF IsAmountNegative | SF | Validates that the amount field contains a negative value. |
| Validate SF IsAmountPositive | SF | Validates that the amount field contains a positive value. |
| Validate SF IsCreditCardNumber | SF | Validates that the field contains a valid credit card number. |
| Validate SF IsCurrency | SF | Validates that the field contains a valid currency value. |
| Validate SF IsDate | SF | Validates that the field contains a valid date. |
| Validate SF IsDecimal | SF | Validates that the field contains a decimal value. |
| Validate SF IsEmail | SF | Validates that the field contains a valid email address. |
| Validate SF IsEmpty | SF | Validates that the field is empty. |
| Validate SF IsEuropeanDate | SF | Validates that the field contains a valid European date format (DD/MM/YYYY). |
| Validate SF IsEven | SF | Validates that the field contains an even number. |
| Validate SF IsInFuture | SF | Validates that the date field is in the future. |
| Validate SF IsInPast | SF | Validates that the date field is in the past. |
| Validate SF IsNegative | SF | Validates that the field contains a negative number. |
| Validate SF IsNotEmpty | SF | Validates that the field is not empty. |
| Validate SF IsNotNumber | SF | Validates that the field does not contain a number. |
| Validate SF IsNumber | SF | Validates that the field contains a number. |
| Validate SF IsNumeric | SF | Validates that the field contains only numeric characters. |
| Validate SF IsOdd | SF | Validates that the field contains an odd number. |
| Validate SF IsPercentage | SF | Validates that the field contains a valid percentage value. |
| Validate SF IsPhoneNumber | SF | Validates that the field contains a valid phone number. |
| Validate SF IsPositive | SF | Validates that the field contains a positive number. |
| Validate SF IsSSN | SF | Validates that the field contains a valid Social Security Number. |
| Validate SF IsThisMonth | SF | Validates that the date field is in the current month. |
| Validate SF IsThisYear | SF | Validates that the date field is in the current year. |
| Validate SF IsToday | SF | Validates that the date field is today's date. |
| Validate SF IsTomorrow | SF | Validates that the date field is tomorrow's date. |
| Validate SF IsUKDate | SF | Validates that the field contains a valid UK date format (DD/MM/YYYY). |
| Validate SF IsUKPostcode | SF | Validates that the field contains a valid UK postcode. |
| Validate SF IsURL | SF | Validates that the field contains a valid URL. |
| Validate SF IsUSDate | SF | Validates that the field contains a valid US date format (MM/DD/YYYY). |
| Validate SF IsUSZIPCode | SF | Validates that the field contains a valid US ZIP code. |
| Validate SF IsValidBIC | SF | Validates that the field contains a valid Bank Identifier Code (BIC). |
| Validate SF IsValidIBAN | SF | Validates that the field contains a valid International Bank Account Number (IBAN). |
| Validate SF IsValidSwift | SF | Validates that the field contains a valid SWIFT code. |
| Validate SF IsWeekday | SF | Validates that the date field falls on a weekday (Monday-Friday). |
| Validate SF IsWeekend | SF | Validates that the date field falls on a weekend (Saturday-Sunday). |
| Validate SF IsWholeNumber | SF | Validates that the field contains a whole number (no decimal places). |
| Validate SF IsYesterday | SF | Validates that the date field is yesterday's date. |
| Validate SF IsZero | SF | Validates that the field contains a zero value. |
More info