VisibilityOption() mvSQL database function in Jitterbit App Builder
Summary
Provides the ability to use named Visibility Values in an expression.
Note
This function is designed for use with Visibility Views.
Syntax
VisibilityOption(<VisibilityName>)
Parameters
Visibilityname
| Visibility Name | Value | Description |
|---|---|---|
Clear | 0 | Hides the field from display and clears the field value |
Require | 1 | Makes the field a mandatory visible field |
Show | 2 | Makes the field an optional visible field |
Hide | 3 | Hides the field from display, field value remains intact |
Returns
Hides or displays information based on evaluation of the expression
Example
IIF(OS.ShipCountry = 'France', VisibilityOption(Require), VisibilityOption(Hide))
Returns
1 (the value for Require), making the target field required, if the Ship Country is France, 3 otherwise (the value for Hide), hiding that field