Tag: SQL

  • Content Type

Manage SQL Logs in Infor CRM Database

As I mentioned in last week’s post, using the Full recovery model in SQL in an Infor CRM database would prevent some data loss in the event of a database failure, but would require more careful management of the SQL logs. In today’s post, I will expand on that. When using the Full recovery model […]

Query To Find Objects Related To Another Object in Creatio

If you need to determine the objects that are related to another object in Creatio, there’s a few ways to do this. For example, let’s say you want to find all of the objects that have a relationship to the account object – meaning, find all the objects that have an account lookup. We’ll take […]

Executing Direct SQL Statements in a Process or Configuration Web Service in Creatio (formerly bpm’online)

Creatio does have a lot of options for working with objects/data with an Entity object model, EntitySchemaQuery, Select/Update/Insert objects (I’ll get around to writing articles on these topics as well). You can also execute a SQL statement directly when needed as well. Before we get into the code, it’s worth mentioning, executing a SQL statement […]

Load order issue in Infor CreateUnicodeDB utility

I recently bumped into an issue with the order in which the utility (CreateUnicodeDB) creates database objects.  SQL Users and schemas are processed first, followed by SQL tables, followed by the other SQL objects.  In this particular database, there were scalar UDFs being used to create computed columns in a number of the SQL tables.  Since the utility creates Tables before UDFs, it would error out on any table referencing that non-existent U...

SQL Function for Creating Pretty Key Values for Data in Infor CRM

Some entities in Infor CRM (Saleslogix), such as Tickets, use a “pretty key” as an easier to use value to reference the record. These pretty keys take a table ID value and then create a value like 000-00-001234. If you are creating an external application with this functionality, you’ll need to be able to create […]

Clearing all Activity Notifications in Infor CRM with a SQL Statement

If you’ve ever imported activities into your Infor CRM (Saleslogix) database, you’ll likely hear from users that they’ve been bombarded with notifications. In some instances, you might want to clear those notifications so newly created activity notifications don’t end up getting lost in them all. Luckily, you can do that with a single SQL statement. […]

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!