Search results
Trying to use Case in SOQL's select. SOQL doesn't like that one bit! Any ideas what's the equivalent of Case? My code should be something like: SELECT Client_Account__c, CASE Max (Termination_Date__c) <= TODAY. THEN Termination_Date__c. ELSE 'Active'. FROM Plan__c. GROUP BY Client_Account__c.
3 kwi 2013 · I have a query which includes fields named openingbalance and commissions. I would like to compute values for commissions based on openingbalance, similar to this Select Case block in Access VBA: Select Case OpeningBalance Case 0 To 5000 commission = 20 Case 5001 To 10000 commission = 30 Case 10001 To 20000 commission = 40 Case Else ...
SOQL SELECT Examples. The following are examples of text searches that use SOQL. Type of Search. Examples. Simple query. SELECT Id, Name, BillingCity FROM Account. WHERE. SELECT Id FROM Contact WHERE Name LIKE 'A%' AND MailingCity = 'California'. ORDER BY.
SOQL query syntax consists of a required SELECT statement followed by one or more optional clauses, such as TYPEOF, WHERE, WITH, GROUP BY, and ORDER BY. The SOQL SELECT statement uses the following syntax: SELECT fieldList [subquery][...] [TYPEOF typeOfField whenExpression[...] elseExpression END][...] FROM objectType[,...]
Learn how to write and execute SOQL queries in Apex. Query related records and filter results with conditions. Improve your SOQL syntax skills.
In this article, I will provide you with some practical examples of SOQL queries that you can use to retrieve data from Salesforce databases. I’ll cover some basic queries and then move on to more advanced queries that will help you get the most out of your data.
I want to get the associated CaseComment's CommentBody for a list of cases. String queryFields = 'Id, Subject, CaseComment.CommentBody'; List<Case> cases = Database.query ('select '+ queryFields +' from Case'); for (Case c: cases) { System.debug (c.CaseComment.CommentBody); }
