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
  • 2291 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

A
AnkitaV3131Author
Level 2
October 19, 2023

And why not hide the column with the full number, and then create a new one visible to all with the last 4 digits.

Or maybe I am missing something?


 

Actually, they want to perform the functions on the single column and not hide the column. Only the visibility should be masked value and the same column must be used to send communication or personalization with the whole value.

Is it possible to store the whole value in database and only visibility of the column can be masked??

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...