Role Owner campaign template update

[Lakhitha]

Hi,

We have a requirement to update the role description attribute in role owner campaign templates.

We need to update the same attribute in all the role owner campaign templates. Is there any way we can automate this step? (updating all the role owner campaign template once instead of updating individual campaign template)

Thanks & Regards,

Lakhitha

[NM]

Hi @Lakhitha , you can try using enhancedquery.

[Lakhitha]

Hi

Thanks for your response.

Can you please help us on the table information and also sample enhanced query?

Thanks & Regards,

Lakhitha

[Raghu]

@Lakhitha  if want update role_owner table data we can't update it have two primary key

Reference for limitation of all tables

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...

requirement for you can update table

1.

example : select rolekey as roles__primarykey,'ABC' as roles__DESCRIPTION from roles where role_name ('A','B')

2.if not able to update desc via enhanced query , try upload via csv file upload also have option.

https://forums.saviynt.com/t5/identity-governance/add-user-to-role-with-csv-using-upload-role-associ...

[Manu269]

I assume you are looking to update the Role Desc attribute.

Refer this post : how to convert emergency role to Enterprise role i... - Saviynt Forums - 93029

[Lakhitha]

Hi Manish

Thanks for responding,

No, we need to add role description attribute to role owner campaign templates. Please find the below screenshot for your reference.

Thanks & Regards,

Lakhitha

[Lakhitha]

Hi Raghu,

I don't want to update the roles table, I just want to add the role description attribute in all the campaign templates at once.

Thanks,

Lakhitha

[dgandhi]

You can explore campaign_template table , all the configuration are stored in configuration_As_json column in the JSON format.

You might have to modify the JSON, add the role description and update it.

However its better to update the same from UI as that would be much easy.

[Lakhitha]

Hi Devang,

Thanks for responding. I have explored this option and config JSON varies as per the campaign templates. For all the campaign template I cannot update description attribute at once, I need to run enhanced query individually for every campaign templates.

Thanks & Regards,

Lakhitha

[rushikeshvartak]

Avoid running enhanced query as its json stored in db and if it’s gets messed campaign will behave unexpectedly 

[rushikeshvartak]

You need to update manually as you can export campaign templates individually and not in bulk.

[Lakhitha]

Thanks for the updates.