Current Campaign Version flag in CI_CAMPAIGN table in CDM table

[JM_VFAU]

If we save campaign by retaining campaign code in SAS CI, it creates multiple records in CI_CAMPAIGN table in CDM database.

Is there a way where to change the current version flag value in this table for the non current campaigns using SAS CI gui? Currently we update the value manually in the table.

[JamesAnderson · Accepted solution]

HI JM_VFAU,

This isn't exposed in the GUI - presumably you are asking this to empower the end users, rather than a support request back to the IT team ? If so you could wrap the update sql into a Stored Proc, and then create a "utility" custom node and give the users instructions to add it to the diagram of the new campaign on first use and execute it to update the flag.

Regards
James

[JM_VFAU]

Thanks James.