i want to use SQL query out put in OptionSourceProvider.groovy, so the query results will be optionsources lists items for my custom report.
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?