function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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

Query returns

When I do this query in the Dev Console, it returns: 
SELECT CreatedDate FROM CustomObject__c WHERE CustomField__c = 'a0Fd000000VCFnxEAH' ORDER BY CreatedDate LIMIT 1

however, when I change the LIMIT 1 to LIMIT 2 for example, it works as expected and returns 2 records. It points to a SF bug but I am not able to diagnose further.
Any ideas?
Thanks
 
SonamSonam (Salesforce Developers) 
Reading the description it seems to be working as expected..

when you run: SELECT CreatedDate FROM CustomObject__c WHERE CustomField__c = 'a0Fd000000VCFnxEAH' ORDER BY CreatedDate LIMIT 1

it returns a single record ..right?
 
HugoNowHugoNow
Sorry, my post was somehow truncated. I reposted with a new subject here:
https://developer.salesforce.com/forums/ForumsMain?id=906F0000000AnfXIAS#!/feedtype=SINGLE_QUESTION_DETAIL&dc=Apex_Code_Development&criteria=OPENQUESTIONS&id=906F0000000Ao4EIAS