Tag: Postgresql
Using Database Views in Creatio
There are many benefits to using database views in Creatio. It can make operations that would require several expensive reads simplified using joins. It can make what would be complex or impossible aggregates simple. The end result is that the view can be used in Creatio just like any object. They can be used in Entity Schema Queries or...
Transforming Comma-Delimited Text to One-To-Many Records in a Creatio Postgresql Database
A client recently had an Excel file that was imported into their Creatio system. The Excel file had a text column of tags that were comma-delimited text values. This article looks how to use built-in Postgresql functions to transform this comma-delimited text into one-to-many tags for the contacts.
How to Add Activities to a Custom Section in Creatio
Out of the box in Creatio, you can connect an Activity to several different types of entities/sections. You can also add support for a custom section to have activities as well with a few manual steps. I'll outline those steps in this article with code that supports both MSSQL and Postgresql implementations.
STEP 1 - Create a Lookup column for...
