Database connection using Script task doesn't relate to the specific Creatio functionality. Please read the C# documentation to find the answer to your question.
There are cases when a record is inserted directly from db and the bp doesn't trigger on object signal(Record Added/Modified), how do I proceed in these cases?
A direct database insert/update won't trigger a signal needed for a process to start. Only option I can think of is to flag the record in some...MoreLess
if you have control over the insert/update process, you could set up a stored procedure in the DB and call it after the insert/update operation...MoreLess
It seems that any indexes (unique or otherwise) created in Creatio config are created to ignore case. This is not good from a data perspective, and prevents actual uniqueness checking in cases where the case of the characters matter. We need to be able to configure unique indexes to be case sensitive...MoreLess
I want to update MaxFileSize and ActiveFileContentStorage using a query to save time. But whenever I tried to run the query from SQL Console it successfully update the values in the database but they are not reflected in the Creatio Portal.
When I add the query in the SQL file in advanced setting...MoreLess
There is a bug in the system regarding the 'Contact in Folder' object, because apparently uses InsertQuery directly into the database, instead of the InsertQuery class.This object doesn't throw signals. How can we capture the event of an added record in such a scenario ?
Besides the option that Oleg provided, another variant is to create a trigger in the DB because normal events like OnInserted won't work with INSERT INTO.
Anybody aware of the use of SysProcPersistentStore table in creatio? A customer has 19GB of data in the table but we don't know where the data comes from.
Is it possible to export an existing database schema into a creatio datamodel? Or from an ERD Data export?
I use lucidchart to create a model of my database, it has export functions for MySQL, PostgreSQL, SQL Server, Oracle SQL and a similar platform as creatio, Quickbase.
