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

  • Question

  • 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


    Thursday, July 11, 2013 9:40 AM

All replies

  • 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" />
        <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" />

    Scott Durow
    Blog www.develop1.net    Follow Me
    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