[SalesForce] Using “Case” in SOQL Select statement

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

LIMIT 100

Best Answer

There is no equivalent in SOQL. More to the point, you'll need some code. You'd have to query all rows, then determine which one you'd like to use.

Related Solutions

[SalesForce] SOQL to update a field of an OpportunityLineItem in the opportunity in use

You need to query by a particular id, or a list of ids, instead of all available ids. You can use a bind to provide an apex variable to a query for use in a filter.

From the Using Apex Variables in SOQL:

Account A = new Account(Name='xxx');
insert A;
Account B;

// A simple bind
B = [SELECT Id FROM Account WHERE Id = :A.Id];

You can also use a Id or a List<Id>.

List<Id> ids = new List<Id>(); // set from somewhere, or get from a list of sObjects
Id someId = 'a0Cc000000PAWBv'; // For example only, avoid hardcoding ids

List<Account> accounts = [SELECT ID, Name FROM Account WHERE Status = 'Active' AND Id IN :Ids];

Account account = [SELECT ID, Name FROM Account WHERE Status = 'Active' AND Id = :someId LIMIT 1];

This is a general example on how to use these variables in queries. Try to modify your code to use these, and either edit your question, or ask a new question if you encounter issues with your code.

Best Answer

Related Solutions

[SalesForce] SOQL to update a field of an OpportunityLineItem in the opportunity in use

Related Topic