Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Unable to get the qualified on status of a lead? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi,

    i want to get the status of the lead which are qualified on today?

    how can i use the fetch XML to get solve this problem

    Regards.

    Thursday, July 11, 2013 9:40 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    The status of leads that are qualified will always be 'Qualified' - do you mean the status of the opportunity that it was qualified into?

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
  <entity name="lead">
    <attribute name="leadid" />
    <filter type="and">
      <condition attribute="statecode" operator="eq" value="1" />
    </filter>
    <link-entity name="opportunity" from="originatingleadid" to="leadid" alias="aa"></link-entity>
    <link-entity name="opportunity" from="opportunityid" to="qualifyingopportunityid" visible="false" link-type="outer" alias="opp">
      <attribute name="statuscode" />
    </link-entity>
  </entity>
</fetch>
    hth

    Scott Durow
    Blog www.develop1.net    Follow Me
    Rockstar365
    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Thursday, July 11, 2013 10:11 AM
    Answerer