+ Start a Discussion
Firas Taamallah 18Firas Taamallah 18 

Soql - How to get number of time a field being tracked ?

Hello ,

I want to develop an soql which will return number of time a field being changed since september 2020 .
  • Soql : SELECT count(Case.Subject), count(Case.OwnerId)  FROM CaseHistory where case.LastModifiedDate  >= 2020-09-01T00:00:00Z 
Does this soql true? how can i aggregate Checkbox field as i can not use Count on checkbox field .. 

Thanks,
AbhishekAbhishek (Salesforce Developers) 
Firas,

https://salesforce.stackexchange.com/questions/146823/soql-query-to-get-accounts-that-have-been-refreshed-since-x-time

The above developer discussion is similar to your query and has to make some changes for it.

If it helps you and close your query by marking it as solved so that it can help others in the future.

Thanks.
Firas Taamallah 18Firas Taamallah 18
abhishek ,

It doesn't helped me , i think my soql is work - well , i want to count Old value in Case history ..