Searching in a database system refers to the process of finding and processing data in a database based on specific criteria. Searching can include various methods, such as full-text searching, filtering results, sorting, and other features that enable efficient searching of large data sets. Searching is a key part of how a database system works, as it allows users to quickly and efficiently find the data they need in a 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 Mercury DB system offers many services that implement various methods of searching for cases, both in the logical and business layers of the system. In order to standardize and centralize, two main services were created, containing several advanced search methods.
Example//testcluster.hgdb.io/mercury-ws-app/restServices/CaseSearchExtRest.wadl.
Example//testcluster.hgdb.io/mercury-ws-app/restServices/CaseIndexerFieldsManagerRest.wadl.
The service is generated based on the ICaseSearchAction interface, which implements SOAP services.