locked
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

    Regards.

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