Native query and custom group datasource


I have problem with custom datasource. First of all I create native query in service like below

QueryRunner queryRunner = new QueryRunner(persistence.getDataSource());
		try {
			List<Map<String, Object>> rows = queryRunner.query(query, new MapListHandler());
			return rows;
		} catch (SQLException e) {
			throw new RuntimeException(e);

second I create CustomValueGroupDatasourcelike below

protected Collection<KeyValueEntity> getEntities(Map<String, Object> params) {
	Service service = AppBeans.get(Service.NAME);
	List<Map<String, Object>> rows = service.getRow();

	return -> {
		KeyValueEntity entity = new KeyValueEntity();
		entity.setValue("customer_shortname", row.get("customer_shortname"));
		return entity;


I attach my custom datasource to groupTable component in xml file

<rows datasource="reportCustomResultDs"/>

and register this datasource in xml obviously.

Query returns rows, but there aren’t any position in groupTable component. When I refesh browse I see in debug mode then rows load from data, but groupTable is empty.

Any suggestion what is wrong ?

Check that you defined the <properties> element of the value datasource. Also, set a breakpoint to your getEntities() method and make sure it returns some rows.
If it doesn’t help, please provide a test project where the problem is reproduced.

Finally I use groupDatasource and custom datasource and effect is the

I add some check in ready method and there are entites in datasource.

public void ready() {
		Collection<RaportResult> items = getTable("browse").getDatasource().getItems();
		for (RaportResult iii : items) {