[SEARCH-1922] Support count(field) with group by Created: 11-Nov-19  Updated: 24-Aug-20  Resolved: 26-May-20

Status: Done
Project: Search and Discovery
Component/s: None
Affects Version/s: None
Fix Version/s: Search Services 2.0

Type: Story Priority: Critical
Reporter: Meenal Bhave [X] (Inactive) Assignee: Unassigned
Resolution: Done Votes: 0
Labels: T-Shirt-L, solr-jdbc
Remaining Estimate: 0 minutes
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
relates to SEARCH-1824 Queries including count(*) do not wor... Done
is related to by SEARCH-2250 Support count(distinct field_name) wi... Open
Epic Link: BI Tool integration via CData - Must Have
Sprint: Team Ninja-King - S&I 28, Team Ninja-King - S&I 29, Team Ninja-King - S&I 30, Team Ninja-King - S&I 31
Release Train: Southall
Delivery Team: Search
Story Points: 13


A Solr limitation - needs investigation on if/how it can be resolved

"count" works.
Sizing includes research in SEARCH-900.

Acceptance criteria:

  • Investigate the "count(field)" with "group by" translation to Solr query. This might require schema modifications. See related SEARCH-900.
  • It should be possible to use "count(field)" with "group by"

Comment by Alessandro Benedetti [ 18-May-20 ]

Ready for review: https://git.alfresco.com/search_discovery/insightengine/merge_requests/509/diffs

Comment by Alessandro Benedetti [ 22-May-20 ]

Review has been approved and code merged, it is ready for review

Generated at Sat Mar 06 22:38:36 GMT 2021 using Jira 7.13.15#713015-sha1:7c5ddd2c3e1709974ae9c48c17df8edd3919fe2c.