Grouping in a database system refers to the process of organizing data into groups based on specific criteria. Grouping allows data to be aggregated and analyzed in the context of different attributes or fields. Grouping is often used in database queries to obtain summaries, statistics, or other information about the data in the database.
View all tagsBelow are examples of data aggregation, which were performed via the CaseSearchExtRest#groupByQuery(POST) service. The syntax of the **Group By** clause was described in the article Lucene Index Queries. The examples were performed using the SoapUI tool.
The basic search engine in the HgDB database is the Apache Lucene index implementation. Lucene Core is a Java library that provides advanced indexing and search features, as well as spell checking, hit highlighting, and advanced analysis capabilities. This article will describe the rules for creating search and aggregate queries that apply in Mercury DB (HgDb) 3.0.