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?
Page 1 / 1
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.
Thanks Scott! I shot you an email. I'm getting a Malformed Query error.
Awesome glad we were able to figure it out!
Thanks Scott!
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.