Masking attribute while creating schema for data display | Community
Skip to main content
A
AnkitaV3131
Level 2
October 17, 2023
Solved

Masking attribute while creating schema for data display

  • October 17, 2023
  • 3 replies
  • 2278 views

Hello Folks,

I have a specific requirement: I need to mask the mobile numbers for visibility purposes. When viewing the data, only the last 4 digits should be visible to the user in the mobile number column. However, at the backend, the mobile number column must contain the complete 10-digit value. This full mobile number is essential for triggering communications to our customers.

Is there a way to configure this setup? Please provide guidance on how to achieve this requirement.

Thank you in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Marcel_Szimonisz

Hello @ankitav3131 ,

There is feature called Restrict PII View in adobe campaign.

 

<srcSchema desc="Recipient table (profiles" entitySchema="xtk:srcSchema" extendedSchema="nms:recipient" img="nms:recipient.png" label="Recipients" labelSingular="Recipient" name="recipient" namespace="sec" xtkschema="xtk:srcSchema"> <element desc="Recipient table (profiles" img="nms:recipient.png" label="Recipients" labelSingular="Recipient" name="recipient"> <attribute name="firstName" accessibleIf="$(login)=='admin'"/> <attribute name="lastName" visibleIf="$(login)=='admin'"/> <attribute name="email" accessibleIf="$(login)=='admin'"/> </element> </srcSchema>



But when you are bit of technical user you are able to view hidden fields with this feature.

 

Marcel Szimonisz

3 replies

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity AdvisorAccepted solution
Community Advisor
October 17, 2023

Hello @ankitav3131 ,

There is feature called Restrict PII View in adobe campaign.

 

<srcSchema desc="Recipient table (profiles" entitySchema="xtk:srcSchema" extendedSchema="nms:recipient" img="nms:recipient.png" label="Recipients" labelSingular="Recipient" name="recipient" namespace="sec" xtkschema="xtk:srcSchema"> <element desc="Recipient table (profiles" img="nms:recipient.png" label="Recipients" labelSingular="Recipient" name="recipient"> <attribute name="firstName" accessibleIf="$(login)=='admin'"/> <attribute name="lastName" visibleIf="$(login)=='admin'"/> <attribute name="email" accessibleIf="$(login)=='admin'"/> </element> </srcSchema>



But when you are bit of technical user you are able to view hidden fields with this feature.

 

Marcel Szimonisz

A
AnkitaV3131Author
Level 2
October 18, 2023

Hello Marcel,

 

I want to clarify that my goal is not to hide the column or its data using visibleif or accessibleif. Instead, I aim to display a masked value to any user accessing the data schema. The crucial point is that, in the backend, the column must still contain the complete, unmasked 10-digit value for functional purposes.

Regards,
Ankita Vishe

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
October 18, 2023

Hello @ankitav3131, this is the masking as it gets in adobe campaign

what else you can do is to decrypt data and encrypt them during send.

 

Marcel

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity Advisor
Community Advisor
October 18, 2023

Hi @ankitav3131 ,

 

Please try adding one more attribute in the Schema with the below syntax

 

<attribute expr="'XXXXXX'+ Substring([@msisdn],length(@msisdn)-3,4)" label="msisdnnew" name="msisdnnew" type="string"/>

 

Also, Please modify your existing mobile number attribute to below based on Visibility condition, so that this 10 digit mobile number will be visible only to admin user.

 

<attribute visibleIf="$(login)=='admin'" label="msisdn" name="msisdn" type="string"/>

 

This approach works when tried to do configure list in Schema / workflow level then the attribute wont be visible in drop down of selection of attributes in a query or other activities , but when tried to add an attribute manually (@msisdn) as an additional column, it will show the Data for non admin users also.

 

Regards,

Pravallika.

Sukrity_Wadhwa
Community Manager
Sukrity_WadhwaCommunity Manager
Community Manager
October 27, 2023

Hi @ankitav3131,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Sukrity Wadhwa
Terms & ConditionsAccessibility statement

Loading footer...