Export Structure to excel

Alex_beivb3

Hi!

I try export structure to excel with using scriptrunner.

It works, but we want to export the structure using pre-saved filters. Is it even possible?

The example has variables such as viewSpec, expandState, clientFilter, but it doesn't say what they are and how to use them. Maybe someone has an example of using these variables with a value other than null?

Alex_beivb3

Hi everyone!

I went into the source code of the Structure plugin and StructureApi and figured out how to insert filters. Maybe this will help someone.

---

To add filters, you need to add the Transforms parameter to ForestSpec. You can get these transformations like this - go to the desired structure, configure the filters as needed and press the export to Excel. In the browser developer console, in the Network tab, find the Excel post request and in the "Payload" tab, take forestSpec.

Now replace the line

def spec = ForestSpec.structure(structureId, helper.userManager.getUserByName(userName))

with

List<ForestSpec.Transformation> transformations = [
    new ForestSpec.Transformation("com.almworks.jira.structure:filter-jql", [
        "showSubItems": false,
        "jql": "status not in (Closed) AND duedate <= endOfMonth()",
        "level": null,
        "keepNonIssues": false
    ])
]

ForestSpec spec = ForestSpec.builder()
    .setStructureId(structureId)
    .setUserKey(helper.userManager.getUserByName(userName).key)
    .setTransformations(transformations)
    .build() as ForestSpec
exporter.configure(viewId, viewSpec, spec, expandState, clientFilter)