FETCH query language
FETCH is a custom query language built for One ERP. The FETCH query allows you to retrieve, filter and aggregate data from one or more One ERP entities. It is used throughout the entire system to define search views, catalogs, charts, reports and much more.
The FETCH query is always executed under security privileges defined for each user. When an user executes an FETCH query it sees only the data it has acces to. The FETCH query can be executed within the One ERP interface, through the REST API or through the native Java API. Regardless of the method of execution used, the same security privileges apply.