Question
Deleting Usage Data
We are trying to reduce our SFDC Storage. To do so, we need to remove some Usage Data. However, our CSM team is a heavy user of the Usage Widget. We would like to removed data for Customers in a certain plan or even customers who have canceled prior to April of this year.
This will require a JOIN of some sort in SOQL between JBCXM__UsageData__c and JBCXM__CustomerInfo__c or the Account record.
The issue is, I'm not sure what the query would look like. I've done some research, but every time I try, WorkBench throws an error.
Can anyone help?
This will require a JOIN of some sort in SOQL between JBCXM__UsageData__c and JBCXM__CustomerInfo__c or the Account record.
The issue is, I'm not sure what the query would look like. I've done some research, but every time I try, WorkBench throws an error.
Can anyone help?