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"