[SalesForce] SOQL to get all Leads that were created on particular date or range

I am trying to a REST call from java and trying to query LEAD entity to get all Leads that were created on a particular date/date range. I am unable to get working query for the same.

I am doing something like this:

HttpGet get = new HttpGet(loginInstanceUrl+ "/services/data/v33.0/query?q=Select+Id+,+FirstName+,+LastName+,+Company+From+Le‌‌ad");

This gives me list of all Leads. I tried adding a where clause here something like Where CreateDate=3/25/2015 but then query fails with CreateDate is not a column on Lead Entity.

Best Answer

The name of the field isn't CreateDate but CreatedDate.

The following query will, in example query all leads which were created in the current year:

SELECT id, firstname, lastname, company, CreatedDate 
FROM Lead 
WHERE CreatedDate = THIS_YEAR


/services/data/v29.0/query?q=SELECT+id,+firstname,+lastname,+company,+CreatedDate+FROM+Lead+WHERE+CreatedDate+=+THIS_YEAR

Related Solutions

[SalesForce] System.SObjectException: Invalid relationship name for Lead

I think you're confusing some methods, to get lead fields you can use the get method.

sObject l = [select id,name from lead limit 1];
system.debug('this is it' + l.get('name'));

Have to admit that I find the getSObject(s) documentation somewhat vague and couldn't produce a working example in a short time. Maybe someone else can.

Edit

GetSObject is to retrieve data from a relationship, like this:

Sobject c = [select account.name from contact where Id = :someId];
String AccountName = (string)c.getSobject('account').get('name');

[SalesForce] SOQL query minimum Date in WHERE clause

Try this:

list<Group> groups = [select id, name, (SELECT Name, Group__c, Business_Value__c, Meeting_Date__c, GPS_Meeting_Location__Latitude__s, GPS_Meeting_Location__Longitude__s FROM Meetings__r ORDER BY Meeting_Date__c DESC LIMIT 1
 ) from Group where Id =:BomaGroups];

Your limit 1 in the original query applied to the whole of the result set and therefore only returned 1 record. By using a sub-query you can get the records that relate to the groupIds you need. I have guessed at the lookup relationship api name being Meetings__r - this may need adjusting.

Best Answer

Related Solutions

[SalesForce] System.SObjectException: Invalid relationship name for Lead

[SalesForce] SOQL query minimum Date in WHERE clause

Related Topic