plugin:struct:aggregation
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
plugin:struct:aggregation [2016-12-08 10:42] – [Table] grosse | plugin:struct:aggregation [2018-08-06 09:49] – [Table] solewniczak | ||
---|---|---|---|
Line 1: | Line 1: | ||
<= [[plugin: | <= [[plugin: | ||
====== Struct Plugin: Aggregation ====== | ====== Struct Plugin: Aggregation ====== | ||
+ | ===== Table ===== | ||
Aggregation of structured data is the main purpose of the plugin. Aggregation is done through a simple syntax which will result in a dynamic table listing all pages and associated data matching certain criteria. | Aggregation of structured data is the main purpose of the plugin. Aggregation is done through a simple syntax which will result in a dynamic table listing all pages and associated data matching certain criteria. | ||
Line 33: | Line 34: | ||
Please note that you can join data from multiple page schemas (as long as they are assigned on the same pages), but can only run aggregations on a single lookup schema. | Please note that you can join data from multiple page schemas (as long as they are assigned on the same pages), but can only run aggregations on a single lookup schema. | ||
- | ===== Aliases | + | ==== Aliases ==== |
When selecting data from multiple schemas which contain the same field names, you have to prefix them with the schema name: | When selecting data from multiple schemas which contain the same field names, you have to prefix them with the schema name: | ||
Line 56: | Line 57: | ||
- | ===== Special Columns | + | ==== Special Columns ==== |
The following special column names can be used to access non-field columns: | The following special column names can be used to access non-field columns: | ||
- | ^ Special Name ^ Description | + | ^ Special Name |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
+ | | '' | ||
Line 85: | Line 87: | ||
| schema\\ from | yes | | | schema\\ from | yes | | ||
| cols\\ select | | cols\\ select | ||
- | | head\\ header\\ headers | + | | head\\ header\\ headers |
| max\\ limit | yes | | | max\\ limit | yes | | ||
| sort\\ order | yes | | | sort\\ order | yes | |
plugin/struct/aggregation.txt · Last modified: 2024-03-13 18:17 by 91.89.222.218