What libraries I would need to add to generate a graph in scriptrunner in Jira

[Mehhss]

I have apache poi libraries installed in my scriptrunner Jira to access excel files.

However I wanted to generate a graph in Scriprunner in Jira.

Will this work 
https://nightlies.apache.org/flink/flink-docs-release-1.15/docs/libs/gelly/graph_generators/

if yes, what libraries I would need to add to generate a graph in Scriptrunner in Jira

[Ram Kumar Aravindakshan _Adaptavist_]

Hi @Mehhss

If you intend to add an external library, you will need to do the following steps.

1. Shut down your Jira instance.

2. Add the external jar file it to the <JAVA_INSTALLATION_PATH>/lib folder and restart your Jira instance

3. Restart your Jira instance.

You will not be able to invoke the external library classes from the ScriptRunner Editors.

Thank you and Kind regards,

Ram

[Mehhss]

Hi @Ram Kumar Aravindakshan _Adaptavist_  Thanks for your reply. In understand that if I need to use external libraries I need to add the jars under the <JAVA_INSTALLATION_PATH>/lib folder and follow the steps as mentioned above.

However, I wanted to know the libraries needed to generate graph from the excel data that can be used from Scriptrunner in jira

[Ram Kumar Aravindakshan _Adaptavist_]

Hi @Mehhss

If you intend to Generate graphs from Excel data, you will need to use the Apache POI library.

I would also suggest looking into the Midory Jira Plugin as it works pretty well with ScriptRunner.

Thank you and Kind regards,

Ram

[Mehhss]

Hi @Ram Kumar Aravindakshan _Adaptavist_ , I wanted to use JFreechart library from my scriptrunner(Jira Data Center).

https://github.com/davetcc/groovychart  -- If I have to use the below ChartBuilder library, 

com.thecoderscorner.groovychart.chart.ChartBuilder

 which jar file I need to use?

[Ram Kumar Aravindakshan _Adaptavist_]

Hi @Mehhss

If you intend to use the JFreechart library, no jar is available upfront.

You must download the code from the GitHub repository and build it using either Maven or Gradle.

If the build is successful, a jar file will be produced.

You will need to include that jar file into your Jira instance using the approach that I mentioned in my previous comment, i.e.:-

1. Shut down your Jira instance.

2. Add the external jar file it to the <JAVA_INSTALLATION_PATH>/lib folder and restart your Jira instance

3. Restart your Jira instance.

The classes contained in the Jar file should be accessible from the ScriptRunner editors.

Thank you and Kind regards,

Ram