Set up rule for binding emails for custom section on Creatio Studio Version 7.15.3.1649
Hi I'd like to create a rule where an email is attached to a custom object. I tried to follow the link below, but I don't see my custom object on the 'Connected object' drop down list.
Do I need to execute some sql scripts? If so what script do I need to run?
Thanks,
Jose
Like
Hi Jose,
You can select * from RuleRelationSections and see how the fields look.
You need the Name (capitalized) of the custom section you want to add and the Uid of this section from SysSchema table.
So the script should look like this:
insert into RuleRelationSections (Name,SectionSchemaUId) values ('name of the object capitalized','UID of the custom object from SysSchema')
Thank you.
Hi Jose,
You can select * from RuleRelationSections and see how the fields look.
You need the Name (capitalized) of the custom section you want to add and the Uid of this section from SysSchema table.
So the script should look like this:
insert into RuleRelationSections (Name,SectionSchemaUId) values ('name of the object capitalized','UID of the custom object from SysSchema')
Thank you.
Thanks Bohdan! I follow your instructions and it worked as I need it.
Hello Bohdan Zdor,
Where we can get RuleRelationSections? and where to put the query?
Thanks in Advance
Hi Shrey Soni,
You can find RuleRelationSections as the object in advanced settings of your instance.
You can put the query using SQL Executor (https://marketplace.creatio.com/app/sql-executor-creatio)
if your instance is the cloud one.
In case you have an on-site SQL installation of Creatio you can use your SQL Management Studio to put the queries.
Thank you for choosing Creatio!