I want to create a queue first. then i have to assign the case owner to that particular queue. How to accomplish this ?
I am trying to create a queue using Apex
Group testGroup = new Group(Name='testgroup', Type='Queue');
insert testGroup;
QueuesObject testQueue = new QueueSObject(QueueID = testGroup.id, SObjectType = 'Case');
insert testQueue;
I am getting the error as
DML operation INSERT not allowed on Group
Provide me a solution please..
Thanks in advance
Rather than setting the Case.OwnerId to the Queue ID you need to set it to the Group ID. As OwnerId is a lookup to User and Group rather than User and Queue as displayed in the UI.
You can check it yourself using Workbench > Info > Standard & Custom Objects > Case, Fields > OwnerId > Reference To.
However by doing this you will receive a MIXED_DML_EXCEPTION due to executing DML on a setup object (inserting QueuesObject) between DML on non-setup objects (Group and Case) to get around this you need to execute the DML on setup objects in a different context, this can be done using System.runAs(...).
If you change it to the following it should work:
Group testGroup = new Group(Name='test group', Type='Queue');
insert testGroup;
System.runAs(new User(Id=UserInfo.getUserId()))
{
QueuesObject testQueue = new QueueSObject(QueueID = testGroup.id, SObjectType = 'Case');
insert testQueue;
}
Case aCase = new Case(OwnerId = testGroup.Id);
insert aCase;
One workaround would be to use future methods to create the setup objects. Have a look at this post for more details on how to do it.
You also need to bulkify your code so that you don't have the inserts within a for loop.
Best Answer
Are you doing other things as part of this code?
There are restrictions on what DML operations you can perform in the same context For example You can only insert and update a group in a transaction with other sObjects. Other DML operations are not allowed.
I find that I can run your code fragment provided without problem. So maybe you are doing something else in the code before this which is forbidden in combination with DML on the Group.
https://www.salesforce.com/us/developer/docs/apexcode/Content/apex_dml_non_mix_sobjects.htm