Skip to main content
Topics#ApexDomanda di Sarabjeet Pal
Sarabjeet Pal (Fluido) ha fatto una domanda in #Apex
4 giu 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 risposte
  1. Maharajan Chinnadurai (Infosys Limited)
    4 giu 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
Scrivi una risposta...
0/9000