SQL | Customer FX

Safely Shrink the Size of the Infor CRM SQL Log File

by Dan Ramsey | Oct 15, 2021 | Infor CRM

You can use the SQL console or a SQL command to shrink a Infor CRM SQL database log file that has grown too large, but be sure to back up the database first.

Manage SQL Logs in Infor CRM Database

by Dan Ramsey | Sep 28, 2021 | Infor CRM

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 […]

SQL Recovery Models and Infor CRM

by Dan Ramsey | Sep 21, 2021 | Infor CRM

In the SQL database for Infor CRM, you can set the recovery model to Simple or Full.

Query To Find Objects Related To Another Object in Creatio

by Ryan Farley | Dec 21, 2020 | 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 […]

Sysdba SQL login for Infor CRM Database

by Dan Ramsey | Aug 31, 2020 | Infor CRM

In order to prepare a SQL server to run Infor CRM, you must set up a SQL login for CRM to use, and must link it with the sysdba user in the CRM database.

Moving or Restoring Databases in Infor CRM (formerly Saleslogix)

by Dan Ramsey | Mar 3, 2020 | Infor CRM

Use the sa SQL account to move or restore CRM databases, but use sysdba to connect to them.

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

by Ryan Farley | Nov 11, 2019 | Creatio

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 […]

Clear User Settings in Infor CRM LAN client (formerly SalesLogix)

by Dan Ramsey | Sep 18, 2019 | Infor CRM

It is possible to clear the user settings in the CRM LAN client (formerly SalesLogix) using a SQL query.

GLOBALCHANGETRACKING Table and Email Sync.

by Dan Ramsey | Jul 16, 2018 | Infor CRM

If you are running some email sync, and it having issues completing, one possible solution is to purge the GLOBALCHANGETRACKING table of all its old delete records.

Dealing with Columns in Infor CRM (SalesLogix) Query Builder

by Dan Ramsey | Jul 2, 2018 | Infor CRM

Adding Columns in Infor CRM Querry Builder can be confusing, as columns are listed based on the organization of the database, rather than what is displayed in the Client.

SQL Script to Enable/Disable all triggers in a Database

by Jason Buss | Jun 8, 2018 | Infor CRM

One thing I find myself doing frequently is enabling/disabling triggers in an InforCRM database, especially with users who are not utilizing any of the newer ERP integration features found in current versions of InforCRM.

Do not enable No Count on Infor CRM (Saleslogix) SQL server

by Dan Ramsey | May 14, 2018 | Infor CRM

Do not enable No Count on a SQL server running Infor CRM (Saleslogix).

Load order issue in Infor CreateUnicodeDB utility

by Jason Buss | May 1, 2018 | Infor CRM

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...

Hide Infor CRM Groups in the Database

by Dan Ramsey | Mar 16, 2018 | Infor CRM

It is possible to hide groups at the database level, thus speeding up load times.

Create an Infor CRM (Saleslogix) Report to Filter by Date

by Dan Ramsey | Nov 8, 2017 | Infor CRM

When creating a report in Infor CRM (Saleslogix) that filters based on date, the options can be a bit tricky. Luckily, most of tables and columns in the underlying SQL database are named fairly intuitively.

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

by Ryan Farley | Oct 17, 2017 | 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 […]

Edit Infor CRM (Saleslogix) data in SQL

by Dan Ramsey | Oct 3, 2017 | Infor CRM

There are simple SQL statements that can be used to delete or change a single piece of data in Infor CRM (Saleslogix).

SQL for Infor CRM 8.3.x

by Dan Ramsey | May 3, 2017 | Infor CRM

When we are assisting clients with an upgrade or new installation of CRM, we are frequently asked what version of SQL should be used.

Clearing all Activity Notifications in Infor CRM with a SQL Statement

by Ryan Farley | Jan 23, 2017 | Infor CRM

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. […]

Executing a Business Rule via the Infor CRM SData API from T-SQL

by Ryan Farley | Oct 24, 2016 | Infor CRM

I had the need to call a business rule in Infor CRM from a stored procedure in SQL. This turned out to be a relatively easy task, although you want to make sure you think through what you’re doing for this to not introduce performance problems in SQL. Keep in mind, sometimes SData requests can […]

Tag: SQL

Content Type