Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
DEV_CGDEV_CG 

SELECT Id, MasterLabel FROM LeadStatus WHERE IsConverted=true

what exactly it means..when ever i quered 
SELECT Id, MasterLabel
 FROM LeadStatus WHERE IsConverted=true,
result is only one record:

SELECT Id, MasterLabel
 FROM LeadStatus WHERE IsConverted=false:
result is 3 records:

is it like only 4 master lables we have in leadstatus
Shivdeep KumarShivdeep Kumar
Hi,

Its mean you have only 4 Lead status picklist values in which 1 is converted. Please read below for description;
"
The LeadStatus object represents a value in the lead status picklist (see Lead Status Picklist). The lead status picklist provides additional information about the status of a Lead, such as whether a given status value represents a converted Lead. Query this object to retrieve the set of values in the lead status picklist, and then use that information while processing Lead objects to determine more information about a given lead. For example, the application could test whether a given lead is converted based on its Status value and the value of the IsConverted property in the associated LeadStatus record."

Thanks
Shivdeep
Raj VakatiRaj Vakati
The Query will return based on the  Lead, status such as Open, Qualified, or Converted.

https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_leadstatus.htm


The Below query is retrn the only one record besasue the Only one Converted status to Converted for IsConverted=true,


SELECT Id, MasterLabel
 FROM LeadStatus WHERE IsConverted=true,



The Below query is retrn the more than one record besasue the Only one Converted status to Converted for IsConverted=true,


SELECT Id, MasterLabel
 FROM LeadStatus WHERE IsConverted=false:
Raj VakatiRaj Vakati
The Below query is retrn the more than one record besasue the Only one Converted status to Converted for IsConverted=false,


SELECT Id, MasterLabel
 FROM LeadStatus WHERE IsConverted=false: