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

[Avi2412]

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.

[_Manoj_Kumar_]

Hello @Avi2412 

You can use the sysfilter for this use case.

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

[Marcel_Szimonisz · Accepted solution]

Hello @Avi2412 ,

similar question as one here
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-segreggate-...
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/

[Avi2412]

Thanks Marcel for the solution