Block() mvSQL database function in Jitterbit App Builder
Summary
Provides the ability to use Block column usage types by name.
Syntax
Block(<BlockColumn>)
Parameters
| Block column | Value | Description |
|---|---|---|
None |
0 |
No restrictions; allows all operations on the row |
Edit |
1 |
Prevents editing of the row |
Delete |
2 |
Prevents deleting of the row |
EditAndDelete |
3 |
Prevents both editing and deleting of the row |
Returns
Allows or prevents operations on an individual row based on evaluation of the expression.
Example
Consider the line:
IIF(DDS.Sealed = True, Block(EditAndDelete), Block(None))
The condition (DDS.Sealed = True) tests if a certain row is sealed, meaning it shouldn't be changed. The Block() function will return:
3(the value forEditAndDelete), preventing edit and delete operations in the target row if the expression evaluates to true.0(the value forNone), allowing all operations if the expression evaluates to false.