How to provide Read and write access to operators based on country's information loaded in a custom schema. | Community
Skip to main content
September 16, 2023
Solved

How to provide Read and write access to operators based on country's information loaded in a custom schema.

  • September 16, 2023
  • 2 replies
  • 967 views

I have a custom Schema in which we have Country as a column. This schema holds data cdr's from Portugal and Germany. Now i want to give read and write access to the data corresponding to the operator which belong to that country.

For eg :- operator's from Portugal can have Read access to the data corresponding to portugal country only and  operator's from Germany can have Read/write access to the data corresponding to Germany country only.

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 @avi2412 ,

similar question as one here
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-segreggate-data-in-recipient-schema/td-p/620004
And sysfilter is the way

I will just copy what I wrote there:

 

"the only  way how to segregate recipient data by eg countries is to use schemas sysfilters. Folder separation won't work as when you do query data in qorkfloe you could see all the recipient from all the folders anyway 

 


https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...

 

 

 

<sysFilter name="dataAccess"> <condition enabledIf="hasNamedRight('admin')=false"> <condition enabledIf="hasNamedRight('GermanyRecipientAccess')=true" expr="(Lower([country/@isoA2])='de'"/> </condition> </sysFilter>

 

 

 

 

You will have to create named rights for each of your operator group that you want to use in the sysfilter. I could not find any article what else you can use in the 'enabledIf' other than operator id or named group."

 

 

 

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

2 replies

Manoj_Kumar
Community Advisor
Community Advisor
September 17, 2023

Hello @avi2412 

 

You can use the sysfilter for this use case.

 

You can find more details on sysfilters here: Filtering schemas | Adobe Campaign

Manoj     Find me on LinkedIn
Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity AdvisorAccepted solution
Community Advisor
September 18, 2023

Hello @avi2412 ,

similar question as one here
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-segreggate-data-in-recipient-schema/td-p/620004
And sysfilter is the way

I will just copy what I wrote there:

 

"the only  way how to segregate recipient data by eg countries is to use schemas sysfilters. Folder separation won't work as when you do query data in qorkfloe you could see all the recipient from all the folders anyway 

 


https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...

 

 

 

<sysFilter name="dataAccess"> <condition enabledIf="hasNamedRight('admin')=false"> <condition enabledIf="hasNamedRight('GermanyRecipientAccess')=true" expr="(Lower([country/@isoA2])='de'"/> </condition> </sysFilter>

 

 

 

 

You will have to create named rights for each of your operator group that you want to use in the sysfilter. I could not find any article what else you can use in the 'enabledIf' other than operator id or named group."

 

 

 

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

Avi2412Author
September 19, 2023

Thanks Marcel for the solution 🙂