SOQL equivalent of countif

Question

Is there something equivalent to the excel countif function (http://www.techonthenet.com/excel/formulas/countif.php) in SOQL ?

This is especially important in group by queries.

In oracle I would use the case function together with the case function

sum(
    case
         when (condition is true) 
          then 1 else 0 
  end
)

How do i perform the same in salesforce SOQL?

Thanks,

David

score 2 · Accepted Answer · answered Sep 03 '13 at 19:06

This is one place where SOQL is not the equal of SQL. There is no CASE statement in SOQL, and there's really no way to accomplish a pivot here. We recently solved a similar problem by querying all rows and then accumulating the pivoted values using Apex, and then exposing that as an Apex web service so we could call the query on demand.

score 0 · Answer 2 · answered Sep 03 '13 at 11:54

0

When using group by you could use HAVING clause to filter the aggregate function by criteria.

answered Sep 03 '13 at 11:54

Moti Korets

3,738
2
26
35

Hi, I need to make something like a pivot table. So i don't want to filter out. I want to have a table where as rows i have a certain column i make group by and as column i want to have the age of the case when it was created. column 1) num of cases created this month case 2) num of cases created last month ... – David Michael Gang Sep 03 '13 at 12:01

SOQL equivalent of countif

2 Answers2