Package com.onec.ui

Class CatalogQueryService

java.lang.Object

com.onec.ui.CatalogQueryService

public class CatalogQueryService
extends Object

Read-side queries for catalogs, shared by the REST API and the DivKit emitters so the SQL and ref-resolution live in one place. Pure data access — access control stays with the callers.

Constructor Summary

Constructors

Constructor	Description
CatalogQueryService(MetadataRegistry registry, org.jdbi.v3.core.Jdbi jdbi)

Method Summary

Modifier and Type	Method	Description
BigDecimal	aggregate(CatalogDescriptor desc, String metric, String field, String filter)	A single aggregate value for a count/metric card — count of rows, or sum|avg|min|max of one numeric column — restricted to live records and narrowed by an optional safe filter predicate (see WidgetFilter).
List<Map<String,Object>>	children(CatalogDescriptor desc, UUID parent)
long	count(CatalogDescriptor desc)
long	count(CatalogDescriptor desc, String search, List<String> eq, List<String> in, List<String> like, List<String> prefix, List<String> ge, List<String> le)	Total live rows matching the search (+ any declarative filters) — for the virtual scroller.
CatalogDescriptor	forClass(Class<?> clazz)	The catalog descriptor for a domain class, or null if it isn't a registered catalog.
Map<String,Object>	get(CatalogDescriptor desc, UUID id)
List<Map<String,Object>>	list(CatalogDescriptor desc)
List<Map<String,Object>>	list(CatalogDescriptor desc, int offset, int limit)
List<Map<String,Object>>	page(CatalogDescriptor desc, int offset, int limit, String sortColumn, boolean descending, String search, List<String> eq, List<String> in, List<String> like, List<String> prefix, List<String> ge, List<String> le)	One page of a catalog list, server-side sorted and filtered — the engine behind the virtualized/paged list grid.
List<Map<String,Object>>	relatedRows(CatalogDescriptor desc, String viaColumn, UUID parentId)	Live rows of a join catalog whose viaColumn ref points at parentId — the read side of a related-list panel (see RelatedList).
CatalogDescriptor	require(String name)
List<Map<String,Object>>	search(CatalogDescriptor desc, String query, int limit)	Server-side typeahead for ref pickers: case-insensitive match on code/description, capped at limit, so a 2000-row catalog never ships whole to the client.
Set<String>	sortableColumns(CatalogDescriptor desc)	Column names that may be sorted on: the system columns + every attribute column.
List<Map<String,Object>>	tree(CatalogDescriptor desc)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

CatalogQueryService

public CatalogQueryService(MetadataRegistry registry,
 org.jdbi.v3.core.Jdbi jdbi)

Method Details

require

public CatalogDescriptor require(String name)

forClass

public CatalogDescriptor forClass(Class<?> clazz)

The catalog descriptor for a domain class, or null if it isn't a registered catalog.

list

public List<Map<String,Object>> list(CatalogDescriptor desc)

search

public List<Map<String,Object>> search(CatalogDescriptor desc,
 String query,
 int limit)

Server-side typeahead for ref pickers: case-insensitive match on code/description, capped at limit, so a 2000-row catalog never ships whole to the client.

count

public long count(CatalogDescriptor desc)

aggregate

public BigDecimal aggregate(CatalogDescriptor desc,
 String metric,
 String field,
 String filter)

A single aggregate value for a count/metric card — count of rows, or sum|avg|min|max of one numeric column — restricted to live records and narrowed by an optional safe filter predicate (see WidgetFilter).

list

public List<Map<String,Object>> list(CatalogDescriptor desc,
 int offset,
 int limit)

page

public List<Map<String,Object>> page(CatalogDescriptor desc,
 int offset,
 int limit,
 String sortColumn,
 boolean descending,
 String search,
 List<String> eq,
 List<String> in,
 List<String> like,
 List<String> prefix,
 List<String> ge,
 List<String> le)

One page of a catalog list, server-side sorted and filtered — the engine behind the virtualized/paged list grid. sortColumn must be one of the entity's real columns (validated by the caller via sortableColumns(com.onec.metadata.CatalogDescriptor)); search matches case-insensitively across the text columns. Live records only.

count

public long count(CatalogDescriptor desc,
 String search,
 List<String> eq,
 List<String> in,
 List<String> like,
 List<String> prefix,
 List<String> ge,
 List<String> le)

Total live rows matching the search (+ any declarative filters) — for the virtual scroller.

sortableColumns

public Set<String> sortableColumns(CatalogDescriptor desc)

Column names that may be sorted on: the system columns + every attribute column.

children

public List<Map<String,Object>> children(CatalogDescriptor desc,
 UUID parent)

tree

public List<Map<String,Object>> tree(CatalogDescriptor desc)

relatedRows

public List<Map<String,Object>> relatedRows(CatalogDescriptor desc,
 String viaColumn,
 UUID parentId)

Live rows of a join catalog whose viaColumn ref points at parentId — the read side of a related-list panel (see RelatedList). Ordered by code so the inline roster is stable. Refs are resolved (so the display ref shows its description) and secrets redacted, exactly like the standalone catalog list. viaColumn must be a real column on desc (the caller resolves it from the join catalog's metadata, never from user input) so this stays injection-safe.

get

public Map<String,Object> get(CatalogDescriptor desc,
 UUID id)