...
- Construct the SQL script that will be used to retrieve the results.
- Use executeUsingPreparedStatement(sqlStatement, dbName, parameters, dbType) method of SQLUtil class, to retrieve the results and put them in a variable of type com.crm.framework.util.ResultSetUtil.
- Convert com.crm.framework.util.ResultSetUtil to com.crm.process.dashboards.DashboardComponentData using DashboardComponentData class constructor.
Note:
- To add any additional summary filters to the summary page linked to the dashboard component, use addSummaryFilter method as shown in the following example.
- The method must always return a result of type com.crm.process.dashboards.DashboardComponentData
...