Data source expressions are not case sensitive. You can type in both capital and small letters.
Pipelined principle
Hubcloud Data source expressions are pipelined.
The expression begins with Input Data (the name of the Register or Catalog) and contains any number of sections, separated by the characters “|”.
This expression (Fig.2) can be easily “translated” into human language: we get the Register Inventory | we select all records for the main store | group by-product and find the sum of the quantity and value of each group | calculate the price of each product | sort the resulting table in descending order of price.
Each section performs some actions on the Input data: filters according to the condition, groups the data, perform calculations, etc.
The result of the current section is fed to the next section and so on until the expression ends and we get the result.
You can use the following section types in data source expressions:
- Register or Catalog. Always the first section.
- Filters allow you to filter the source data.
- Functions that retrieve data.
- Functions that provide additional data processing.
- Aggregate Functions.
Expressions built on the pipelined principle are much more visual, which means they are easier to create and debug.
Input Data: Register, Catalog
The data source begins with the name of the Register or the name of the Catalog. In the case of a Catalog, you must add the “Catalog.” keyword before the name.
For example, Money is the name of the Register, Catalog.Stores is the name of the Catalog.
Use Names rather than Titles