How to use Sql query results in OptionSourceProvider.groovy class for Option sources

Automation/IaC
1

HI all

i want to use SQL query out put in OptionSourceProvider.groovy, so the query results will be optionsources lists items for my custom report.

  1. ReportProvider.groovy
    2)OptionSourceProvider.groovy
    3)ReportsPlugin.groovy

in OptionSourceProvider.groovy class i want to get a SQL query out put and use that Output in List<Map<String, Object>>,

soo this List can be used as a optionSource in ReportProvider.groovy

Anyone have smaple code? so i can use it?