Tag: MSSQL
Searching SQL Server Views, Stored Procedures, and Functions for a Specific String
Quickly locate where a field or keyword is used in your SQL Server database by searching across view definitions, stored procedures, and functions. This simple script helps Infor CRM developers and DBAs trace dependencies, clean up legacy code, and understand how data flows through customized environments.
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...
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...
