Retrieving a list of CRM Queues @ Mitch Milam's Dynamics CRM Discussions

Retrieving a list of CRM Queues

Posted on June 18th, 2007 mitch

Print No comments

As I'm putting the finishing touches on my first commercial CRM Utility, I found the need to obtain a list of CRM Queues so that the user can select one from a combo box, like this:

When working with queues, you need to know two things:

1) The Queue Name ( for the user to see ).

2) The Queue ID ( for the CRM system to reference ).

Both of which can be returned by performing a query against the CRM web service.

The following .NET method will return just such a list:

private ArrayList GetQueueNames(CrmService myCRMService)
{
    string fetchString =
        "<fetch version=\"1.0\" "+
        "output-format=\"xml-platform\" "+ 
        "mapping=\"logical\" distinct=\"false\">" +
        "<entity name=\"queue\">"+
        "<attribute name=\"name\"/>"+
        "<attribute name=\"emailaddress\"/>"+
        "<attribute name=\"businessunitid\"/>"+
        "<attribute name=\"queueid\"/>"+
        "<order attribute=\"name\" descending=\"false\"/>"+
        "<filter type=\"and\">"+
        "<condition attribute=\"name\" operator=\"not-null\"/>"+
        "</filter></entity></fetch>";
 
    XmlDocument xmlDoc = new XmlDocument();
    xmlDoc.LoadXml(myCRMService.Fetch(fetchString));
    XmlNode node = xmlDoc.SelectSingleNode("resultset");
 
    ArrayList queueList = new ArrayList();
    string n1 = string.Empty;
    string n2 = string.Empty;
 
    foreach (XmlNode n in node.ChildNodes)
    {
        n1 = n.SelectSingleNode("name").InnerText.ToString();
        n2 = n.SelectSingleNode("queueid").InnerText.ToString();
        queueList.Add(new ItemData(n2, n1));
    }
 
    return queueList;
}

I created the FetchXML query by following Ronald Lemmen's article on pulling it from the Advanced Find query, which looked like this:

Populating the Combo Box

In order to use the data within a combo box, I had to create a data structure to hold the data. Add this class to your application:

public class ItemData
{
 
    private string m_Value;
    private string m_Description;
 
    public object Value 
    {
        get { return m_Value; }
    }
 
    public string Description 
    {
        get { return m_Description; }
    }
 
    public ItemData(string NewValue, string NewDescription)
    {
        m_Value = NewValue;
        m_Description = NewDescription;
    }
 
    public override string ToString()
    {
        return m_Description;
    }
 
}

and use this code to actually populate your combo box:

 
ArrayList queueList = GetQueueNames(myCRMService);
 
if (queueList.Count > 0)
{
    cboQueues.DataSource = queueList;
    cboQueues.DisplayMember = "Description";
    cboQueues.ValueMember = "Value";
 
}