Creatio Club webinar in April was full of exciting news about Creatio latest updates and product roadmap. Watch the recording now at Creatio Youtube channel: https://youtu.be/03Tq0GvghIA

Like 0

Like

Share

0 comments
Show all comments

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. 

https://academy.creatio.com/documents/base/7-15/how-set-rules-binding-emails-other-creatio-objects-automatically#XREF_60839

 

Do I need to execute some sql scripts? If so what script do I need to run?

 

Thanks,

Jose

Like 0

Like

4 comments
Best reply

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!

Show all comments

After migration from version 7.12 to 7.15 one of our processes throw such exception (in subject).

when i click save system wants to publish script tasks i click publish get message compilation succesfully but its does not help

 

Regards

Tomek

Like 0

Like

4 comments

Hello Tomasz, 



Can you please try to compile all items on your website first and see if it helps? 



Kind regards,

Roman

Roman Brown,

unfortunately it didn't

regards

Tomek

Roman Brown,

I have the same issue now, I published the process separately, the package, and the entire system. nothing helps I still get this error

Any ideas?

the same problem, but in Creatio 8.0.6, created the source code, compile all but no way. any ideas?

Show all comments