Deleting Usage Data

  • 1
  • Problem
  • Updated 11 months ago
  • Solved
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?
Photo of Lane H

Lane H, Employee

  • 8,414 Points 5k badge 2x thumb
  • frustrated

Posted 11 months ago

  • 1
Photo of Scott Morris

Scott Morris, Alum

  • 6,312 Points 5k badge 2x thumb
Hey Lane what error are you getting when trying to get this to work?  Feel free to shoot me an email if that's easier as well.
Photo of Lane H

Lane H, Employee

  • 8,414 Points 5k badge 2x thumb
Thanks Scott! I shot you an email. I'm getting a Malformed Query error.
Photo of Scott Morris

Scott Morris, Alum

  • 6,312 Points 5k badge 2x thumb
Awesome glad we were able to figure it out!
Photo of Lane H

Lane H, Employee

  • 8,414 Points 5k badge 2x thumb
Thanks Scott!