delete macro reference with Scriprunner

Michael Regelin

Hello,

I need to delete all references to a macro (in this case: tracking-info) on all pages.

Is it possible with scriptrunner to run this job that would be based on a cql and delete all occurences of the macro ?

No need to keep the content inside the body of macro. Of course, it would be appreciate ;-)

 

Thanks for your help.

 

Michael

Jonny Carter_3nm6du

Yup! This is definitely possible with ScriptRunner.

UPDATE: A better choice might be to use the Update Macro built-in script.

You could setup a CQL Escalation Service job (or just use the "Run Now" to run it as a one-off). A query like

macro = tracking-info and type = page 

should find all pages with the tracking-info macro in them.

As to doing the update, I've got an example up at of bulk-updating a table, but this should be just as possible to remove macro content.

I'm not 100% sure what the tracking-macro's storage format looks like, but many macros are wrapped in an ac:structured-macro tag with an ac:name attribute. You can find those elements in the Confluence storage format with a little massaging for the name-spaced format.Something like this in the inline script blank of a CQL Esclatation Service job should remove the macro and its contents entirely.

import com.atlassian.confluence.pages.PageManager
import com.atlassian.sal.api.component.ComponentLocator
import org.jsoup.Jsoup

def pageManager = ComponentLocator.getComponent(PageManager)
hits.each { page ->
    def body = page.bodyContent.body
    def parsedBody = Jsoup.parse(body)
    def macroBody = parsedBody.select('ac|structured-macro').attr('ac:name', 'tracking-info')
    if (!macroBody.empty) {
        pageManager.saveNewVersion(page) { pageObject ->
            macroBody.remove()
            pageObject.setBodyAsString(parsedBody.toString())
        }
    }
}

Saving the macro's body should be possible, but is left as an exercise to the reader.

Also, we've got some work in the backlog to bulk update macros with less code: https://productsupport.adaptavist.com/browse/SRCONF-1238