Block column usage type in Jitterbit App Builder
Block is a usage type that is generally used in App Builder from the business logic layer on a data object. A data object can only use one block. Preferably the block should be aliased as 'Block' so it's readily understood what it's being used for. The output of the expression is what determines the type of block.
Note
The block usage type can also be used through a dedicated mvSQL database function. See Block() function.
The different values a cell can have mean different things:
| Cell value | Description |
|---|---|
1 |
Prevent editing of that row |
2 |
Prevent deleting of that row |
3 |
Prevent both editing and deleting of that row |
| Any other value | Does not prevent anything |
In App Builder this is called a logical block.
If creating a business object from the source table, the developer may use an expression that targets the blocking column to further customize whether a row is blocked. For example, consider the following line:
iif(who('username')='admin',0,customers.block)
It targets the blocking column, allowing a developer to override the current value of the blocking column for specific use cases.
If the underlying table does not contain a column with block usage type, a business object can still utilize this feature. The developer can add a column to the business object with an expression that results in 0, 1, 2, or 3. Then double click the column and set the usage type for it to block.
In the following screenshot, the Edit pencil icon and the Delete trash can icon are both hidden for certain records, this is being done through the block usage type.
