[Urgent] Deleting newly inserted data in PROD


#1

Hi,
I’m deleting a newly inserted data which is mapped to different C3 Types,
We identified the file causing a big issue in PROD.
Which is the following,

I am simply applying this query on every mapped Object :
RateTieredCharge.removeAll({filter:“meta.sourceFile==’ C3_###_Canonical_Rate_20180605160022_fr-FR_6a2b24d9.csv.gz’”})

Which returns:
Message: "Invalid expression "meta.sourceFile=’ C3_###_Canonical…r-FR_6a2b24d9.csv.gz “: Expecting single expression.”,

I tried then this one switching quotes and double quotes:
RateTieredCharge.removeAll({filter:‘meta.sourceFile==" C3_###_Canonical_Rate_20180605160022_fr-FR_6a2b24d9.csv.gz"’})
Message:” message: "Cannot convert to string for removeAll argument removeFil”


#2

removeFilter in removeAll is just a string. You can look at the syntax of removeAll using c3ShowType(Persistable) and search for the function

You should use the below command:

RateTieredCharge.removeAll(“meta.sourceFile==‘C3_###_Canonical_Rate_20180605160022_fr-FR_6a2b24d9.csv.gz’”)