POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

Have you ever needed to be able to associate more than the default number of child cases that a parent case can have in CRM? Out-of-the-box CRM allows for a parent case to have up to 100 child cases, but in today’s blog, we’ll show you how to increase that when necessary.

child cases

NOTE: This solution will only work in an on-premises environment.

While the DBSettings tool, available from CodePlex, won’t let you configure, it does let you make some pretty cool changes in a CRM Online environment and we’d strongly encourage you to check it out!

Many settings like this appear in the MSCRM_CONFIG database. Here is a SQL script that searches any database for a string:

  • declare @TableName char(256)
  • declare @ColumnName char(256)
  • declare @FindString char(256)
  • declare @sql char(8000)

To use the script, replace the word STRING with the word you want to find. You’ll also want to add a USE statement to the beginning of the script or change the context of the database that you are running this against in the SQL Management Studio.

When the script finished, it will return a column in the OrganizationProperties table called MaxChildIncidentNumber. Keep in mind that the settings held in this table appear on a per-organization basis, so the script below will update every organization if run as-is.

When you run the script, perform an IIS reset, and the change will have taken effect!

We’re always writing great technical blogs here at PowerObjects for fun projects like this! Check out these fun reads next:

Happy CRM’ing!

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.