Search Panes Error in Relationship Table

[FluffyKnight2002]

I can use search panes with data from relationship entity.

@RequestMapping(value = "/employees-searchpanes-basic", method = RequestMethod.POST)
public DataTablesOutput listWithBasicSearchPanes(@Valid DataTablesInput input, @RequestParam Map<String, String> queryParameters) {
input.parseSearchPanesFromQueryParams(queryParameters, Arrays.asList("position", "office.city"));
return employeeRepository.findAll(input);
}

I want to use office.city in SearchPanes and but when i use like this,
'DataTables warning: table id=employees - java.lang.IllegalArgumentException: org.hibernate.query.SemanticException: Could not resolve attribute 'office.city' of 'sample.employee.Employee'
that error happen. How do i fix that?

[darrachequesne]

I could indeed reproduce the issue. It seems there is a mistake here:

spring-data-jpa-datatables/src/main/java/org/springframework/data/jpa/datatables/repository/DataTablesRepositoryImpl.java

Lines 112 to 113 in be286ee

	query.multiselect(root.get(attribute), criteriaBuilder.count(root));
	query.groupBy(root.get(attribute));

I think root.get(attribute) (here, root.get("office.city")) is not valid, the string should be split into root.get("office").get("city"). Would you have time to create a PR?

[FluffyKnight2002]

i dont know how to do that?

[darrachequesne]

This should be fixed by 495cfbc, which was included in version 6.0.4. Could you please check?