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