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

[rajmartha]

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?

[#2]

Here are examlpes for Datasets (which replace OptionSources):

github.com

morpheus-plugin-dataset-examples/src/main/groovy/com/morpheusdata/datasets at...

A Morpheus plugin containing several examples of dataset providers. - gomorpheus/morpheus-plugin-dataset-examples

To add SQL into the mix, this report provider has an examlpe:

github.com

gomorpheus/morpheus-plugin-samples/blob/main/morpheus-reports-plugin/src/main/groovy/com/morpheusdata/reports/CustomReportProvider.groovy#L90

      

          
	ContentSecurityPolicy getContentSecurityPolicy() {
          
		def csp = new ContentSecurityPolicy()
          
		csp.scriptSrc = '*.jsdelivr.net'
          
		csp.frameSrc = '*.digitalocean.com'
          
		csp.imgSrc = '*.wikimedia.org'
          
		csp.styleSrc = 'https: *.bootstrapcdn.com'
          
		csp
          
	}
          

          

          
	void process(ReportResult reportResult) {
          
		morpheus.report.updateReportResultStatus(reportResult,ReportResult.Status.generating).blockingGet();
          
		Long displayOrder = 0
          
		List<GroovyRowResult> results = []
          
		withDbConnection { Connection dbConnection ->
          
			if(reportResult.configMap?.phrase) {
          
				String phraseMatch = "${reportResult.configMap?.phrase}%"
          
				results = new Sql(dbConnection).rows("SELECT id,name,status from instance WHERE name LIKE ${phraseMatch} order by name asc;")
          
			} else {
          
				results = new Sql(dbConnection).rows("SELECT id,name,status from instance order by name asc;")
          
			}