GroupOptions is not working [DATASOLR-290]

[spring-projects-issues]

Yogya H opened DATASOLR-290 and commented

In order to group results by personId I used the following code

Criteria cb =   PatientIndexCriteriaBuilder.getCriteriaBuilder(searchCriteria);
Query search = new SimpleQuery(cb);

Field field = new SimpleField("personId");
SimpleQuery groupQuery = new SimpleQuery(new SimpleStringCriteria("*:*"));
GroupOptions groupOptions = new GroupOptions()
.addGroupByField(field)
.addGroupByQuery(search);
groupQuery.setGroupOptions(groupOptions);

GroupPage<PatientIndex> results= solrTemplate.queryForGroupPage(search, PatientIndex.class);

The returning result is not group by the person Id.

But instead of using groupoptions If I use the following code, The returning data is properly group by the personId.

Query search = new SimpleQuery(cb);
search.addGroupByField(field);
Page<PatientIndex> results = solrOperations.queryForPage(search, PatientIndex.class);

---

Affects: 1.5.4 (Gosling SR4)

Reference URL: http://stackoverflow.com/questions/36336816/spring-data-solr-groupoptions-is-not-working

[spring-projects-issues]

Partha commented

I am having a similar issue,

I have defined the group options as below :

 

private GroupOptions getGroupOptions(Pageable page, final String groupBy) {
   final Field groupByField = new SimpleField(groupBy);
   final GroupOptions groupOptions = new GroupOptions().addGroupByField(groupByField);
   groupOptions.setTotalCount(true);
   groupOptions.setOffset(Long.valueOf(page.getOffset()).intValue());
   groupOptions.setLimit(Long.valueOf(page.getPageSize()).intValue());
   return groupOptions;
}


// In the called function, I do :

final GroupOptions groupOptions = getGroupOptions(page, groupBy);
GroupPage<MyDocument> groupPage =
			 solrTemplate.queryForGroupPage(solrCollection, searchQuery,
			 MyDocument.class);
// I get : Page 1 of 0 UNKNOWN instances in the log.

If i follow the suggestion of Yogya, I am able to group by. Looks like your GroupOptions feature and GroupPage, are broken