Skip to main content
Topics#ApexPergunta de Sarabjeet Pal
Sarabjeet Pal (Fluido) perguntou em #Apex
4 de jun. de 2021, 10:25

Hello everyone, I'm trying to write a soql to fetch the number of case records for this year and trying to group it by month. Below is my query but getting error.But I'm not able to run the query below is the query I'm trying to execute.

select couint(id), CreatedDate from case where createdDate = THIS_YEAR group by createdDate
4 respostas
  1. Maharajan Chinnadurai (Infosys Limited)
    4 de jun. de 2021, 10:43
    Hi Neelesh,

    Please try the below Query:

    couint(id) --> count(id)   --> Typo is there 
    select count(id),CALENDAR_MONTH(CreatedDate) from case where createdDate = THIS_YEAR group by CALENDAR_MONTH(CreatedDate)

    Thanks,

    Maharajan.C
Escrever uma resposta...
0/9000