mvSQL database function - VisibilityOption()¶
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