Thursday, April 28, 2011

Modifying non customizable entities in CRM 4.0

We wanted to add extra columns for the Queues view, while the Queue item is not customizable entity we found a way posted in several blogs, by modifying the "isCustomizable" setting from the DB directly with the below statement

UPDATE Entity
SET ISCUSTOMIZABLE = 1
WHERE NAME = 'queueitem'

After doing this, we were able to open the Queue Item entity and modify the View, we added more columns, then with javascript we modified the values for this columns.

It is very important to change back the settings as it was after finishing the modification by running the same script again and setting it back to 0


UPDATE Entity
SET ISCUSTOMIZABLE = 0
WHERE NAME = 'queueitem'