Posted on

Greater Than

SELECT Name,Amount,Id FROM Opportunity WHERE CloseDate < NEXT_YEAR ORDER BY Id ASC LIMIT 10

{"fields":"Name,Amount","o":"Opportunity","filter":"CloseDate < NEXT_YEAR","by":"Id","n":"10","debug":"true"}

{"totalSize":10,"done":true,"records":[{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfj9AAA"},"Name":"Susan Pooley","Amount":3619367,"Id":"00628000007jfj9AAA"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjAAAQ"},"Name":"Christina Watson","Amount":2413260,"Id":"00628000007jfjAAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjBAAQ"},"Name":"Lauren Campbell","Amount":25755842,"Id":"00628000007jfjBAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjCAAQ"},"Name":"GenePoint Standby Generator","Amount":9150057,"Id":"00628000007jfjCAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjDAAQ"},"Name":"Grand Hotels Kitchen Generator","Amount":11461270,"Id":"00628000007jfjDAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjEAAQ"},"Name":"United Oil Refinery Generators","Amount":3844410,"Id":"00628000007jfjEAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjFAAQ"},"Name":"United Oil SLA","Amount":17738687,"Id":"00628000007jfjFAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjGAAQ"},"Name":"Grand Hotels Guest Portable Generators","Amount":3626699,"Id":"00628000007jfjGAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjIAAQ"},"Name":"University of AZ Portable Generators","Amount":19728542,"Id":"00628000007jfjIAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjJAAQ"},"Name":"Pyramid Emergency Generators","Amount":12040268,"Id":"00628000007jfjJAAQ"}]}

{"objectName":"Opportunity","fieldsArray":["Name","Amount"],"currentLabelsArray":{"Id":"Opportunity ID","IsDeleted":"Deleted","AccountId":"Account ID","IsPrivate":"Private","Name":"Name","Description":"Description","StageName":"Stage","Amount":"Amount","Probability":"Probability (%)","ExpectedRevenue":"Expected Amount","TotalOpportunityQuantity":"Quantity","CloseDate":"Close Date","Type":"Opportunity Type","NextStep":"Next Step","LeadSource":"Lead Source","IsClosed":"Closed","IsWon":"Won","ForecastCategory":"Forecast Category","ForecastCategoryName":"Forecast Category","CampaignId":"Campaign ID","HasOpportunityLineItem":"Has Line Item","Pricebook2Id":"Price Book ID","OwnerId":"Owner ID","CreatedDate":"Created Date","CreatedById":"Created By ID","LastModifiedDate":"Last Modified Date","LastModifiedById":"Last Modified By ID","SystemModstamp":"System Modstamp","LastActivityDate":"Last Activity","PushCount":"Push Count","LastStageChangeDate":"Last Stage Change Date","FiscalQuarter":"Fiscal Quarter","FiscalYear":"Fiscal Year","Fiscal":"Fiscal Period","ContactId":"Contact ID","LastViewedDate":"Last Viewed Date","LastReferencedDate":"Last Referenced Date","HasOpenActivity":"Has Open Activity","HasOverdueTask":"Has Overdue Task","LastAmountChangedHistoryId":"Opportunity History ID","LastCloseDateChangedHistoryId":"Opportunity History ID","DeliveryInstallationStatus__c":"Delivery\/Installation Status","TrackingNumber__c":"Tracking Number","OrderNumber__c":"Order Number","CurrentGenerators__c":"Current Generator(s)","MainCompetitors__c":"Main Competitor(s)","Anniversary_Date__c":"Anniversary Date","Anniversary_Dates__c":"Anniversary Dates","Date_and_Time__c":"Date and Time","End_Date_Time__c":"End Date Time","End_Date__c":"End Date","Difference__c":"Difference","Youtube__c":"Youtube Link","Photo__c":"Profile Photo","WordPress_ID__c":"WordPress ID","Bio__c":"Bio","Formatted_Bio__c":"Formatted Bio","Artist_Bio__c":"Artist_Bio","PatientName__c":"Patient Name","Website__c":"Website","Videos__c":"Videos","User_IDs__c":"User IDs","Detail_Link__c":"Detail Link","Formula_Field__c":"Formula Field","Sample_Date__c":"Sample Date","Contact_ID__c":"Contact ID","Close_Date_Format__c":"Close Date Format","Date_and_Time_TEXT__c":"Date and Time TEXT"}}
Susan Pooley

Amount

3619367
Christina Watson

Amount

2413260
Lauren Campbell

Amount

25755842
GenePoint Standby Generator

Amount

9150057
Grand Hotels Kitchen Generator

Amount

11461270
United Oil Refinery Generators

Amount

3844410
United Oil SLA

Amount

17738687
Grand Hotels Guest Portable Generators

Amount

3626699
University of AZ Portable Generators

Amount

19728542
Pyramid Emergency Generators

Amount

12040268
Leave a Reply

Your email address will not be published. Required fields are marked *