+ Start a Discussion
Saurabh BSaurabh B 

Mass update Report filters

Hello, we have recently made change to our Opportunity stages and I was wondering is there is a way I can mass update filters in the Reports. What we want to do is mass update new stage values with the old one`s. I checked and this cant be done via data loader. Is there any other way ? Can I update stage values using metadata/with eclipse?

Best Answer chosen by Saurabh B
kevin lamkevin lam
Yes, you can do a search and replace with regular expression in elicpse to mass update report filters:User-added image

For example, if you want to replace "Closed Won" with "Won", the regular express search strings are:

If it's the first value in the filter-
(<filter>[\s\S]*<criteriaItems>\n[\s]{12}<column>[\s\S]*StageName</column>\n[\s]{12}<operator>[\S]{1,}</operator>\n[\s]{12}<value>)Closed Won([ \S]*</value>\n[\s]{8}</criteriaItems>[\s\S]*</filter>)

If it's not the first value in the filter-
(<filter>[\s\S]*<criteriaItems>\n[\s]{12}<column>[\s\S]*StageName</column>\n[\s]{12}<operator>[\S]{1,}</operator>\n[\s]{12}<value>[ \S]*)Closed Won([ \S]*</value>\n[\s]{8}</criteriaItems>[\s\S]*</filter>)