Skip to content

Business Object Field Masking

Masking can be configured for fields registered in the Business Object via attributes.

business-object-field-masking-1

Masking provides three methods: Char, String, and Custom, with Custom being the most commonly used.

  1. Char: When a character to mask the data is entered, all entered data is displayed as the replacement character. The length of the displayed string is adjusted by the Mask Length.

business-object-field-masking-2

NOTE

For example, "Honggildong" -> "", "010-1111-2222" -> "".

  1. String: Data is converted and displayed according to the value entered in the Mask String.

business-object-field-masking-3

NOTE

For example, "홍길동" -> Masking, "010-1111-2222" -> Masking.

  1. Custom: Define the format as desired using Excel functions. You can call the Business Object Field using the internal variable @{this}.

business-object-field-masking-4

Example 1) CONCATENATE(LEFT(@{this},1),REPT('*',LEN(@{this})-LEN(LEFT(@{this},1)))) → Masks all characters except the first one: "Hongildong" -> "Hong**"

Example 2) IF(LEN(@{this})=0,, IF(LEN(@{this})=2,REPLACE(@{this},2,1,''),CONCATENATE(LEFT(@{this},1),REPT('',LEN(@{this})-2),RIGHT(@{this},1))))` → Masks middle characters with '': "Honggildong" -> "HongDong"

※ Caution

: Masked fields are not searchable in the list with the default search type as Calculation-based Business Object fields. Therefore, set the search type to Static, and set the Business Object Field without masking as the search target field.