Answered by:
Customize queue entity to add column in a view

Question
-
Guys,
Is it possible to customize queue entity, it's the system entity. The actual requirement is that need to customize the views i.e., need to add a column, let me know if it's do-able, if yes how? Need to achieve in MS CRM 4.0
Thanks
- Edited by Satish Ashy Monday, February 18, 2013 5:15 PM Added version of MS CRM
Monday, February 18, 2013 5:13 PM
Answers
-
Guys,
Got the solution we need to use the following update queries, we need to update 2 entities:
UPDATE entity SET iscustomizable = 1 --0 WHERE name LIKE 'QueueItem'
UPDATE attribute SET displaymask = 335544320 --67108864: Hidden, 335544320: Exposed WHERE entityid = (SELECT entityid FROM entity WHERE name = 'QueueItem') AND name = 'sender'
- Marked as answer by Satish Ashy Tuesday, February 19, 2013 8:10 AM
Tuesday, February 19, 2013 7:57 AM
All replies
-
Hi,
Unfortunately, there is no supported way of doing this in crm4, but you can use the technique here http://crmland.blogspot.co.uk/2011/07/modifying-queue-item-views.html?m=1
Scott Durow
Read my blog: www.develop1.net/publicFollow Me on Twitter
If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"Monday, February 18, 2013 6:54 PMAnswerer -
I want the attribute "sender" which is found in queueitem entity to be displayed in views, I am not getting that attribute when I try adding new columns to any existing view.Tuesday, February 19, 2013 6:46 AM
-
Guys,
Got the solution we need to use the following update queries, we need to update 2 entities:
UPDATE entity SET iscustomizable = 1 --0 WHERE name LIKE 'QueueItem'
UPDATE attribute SET displaymask = 335544320 --67108864: Hidden, 335544320: Exposed WHERE entityid = (SELECT entityid FROM entity WHERE name = 'QueueItem') AND name = 'sender'
- Marked as answer by Satish Ashy Tuesday, February 19, 2013 8:10 AM
Tuesday, February 19, 2013 7:57 AM -
Updating the database is not supported so chances are it'll break as soon you would like to migrate to CRM 2011.Tuesday, February 19, 2013 3:10 PM