how to get task those are not in any queue in crm 2011

0
votes

I am using CRM 2011 on-Premisis. I have a portal in which client create a ticket(task in crm) and it goes in specific queue line (CS Queue,EDI Queue, Lab Quue). But some tasks created but do not goes in any quue. How I get these taks which are not in any queue.

If anyone have an idea please share with me.

Thanks in advance.

Regards,

Riaz Usmani

1
dynamics-crm-2011crm

1 Answers

1
votes

I believe you can try to use Left Outer Join to get your data. I've built provided query based on following article - http://msdn.microsoft.com/en-us/library/dn531006.aspx Try it:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
  <entity name="task">
    <attribute name="activityid" />
    <attribute name="subject" />
    <link-entity name="queueitem" from="objectid" to="activityid" alias="ab" link-type="outer">
       <attribute name="objectid" />
    </link-entity>
    <filter type="and">
        <condition entityname="ab" attribute="objectid" operator="null" />
    </filter>
  </entity>
<fetch/>