@Override public void populateSqlViewGrid( Grid grid, String sql ) { SqlRowSet rs = readOnlyJdbcTemplate.queryForRowSet( sql ); int maxLimit = (Integer) systemSettingManager.getSystemSetting( SettingKey.SQL_VIEW_MAX_LIMIT ); log.debug( "Get view SQL: " + sql + ", max limit: " + maxLimit ); grid.addHeaders( rs ); grid.addRows( rs, maxLimit ); }
/** * Adds program data element values to the given grid based on the given data * query parameters. * * @param params the {@link DataQueryParams}. * @param grid the grid. */ private void addProgramDataElementAttributeIndicatorValues( DataQueryParams params, Grid grid ) { if ( ( !params.getAllProgramDataElementsAndAttributes().isEmpty() || !params.getProgramIndicators().isEmpty() ) && !params.isSkipData() ) { DataQueryParams dataSourceParams = DataQueryParams.newBuilder( params ) .retainDataDimensions( PROGRAM_DATA_ELEMENT, PROGRAM_ATTRIBUTE, PROGRAM_INDICATOR ).build(); EventQueryParams eventQueryParams = new EventQueryParams.Builder( EventQueryParams.fromDataQueryParams( dataSourceParams ) ) .withSkipMeta( true ).build(); Grid eventGrid = eventAnalyticsService.getAggregatedEventData( eventQueryParams ); grid.addRows( eventGrid ); } }