-GroupBy
-GroupBy can be used within inlines for MySQL and other data sources to add a GROUP BY element to the generated SQL statement. The value of the parameter should be the name of a field in the current table. The results of the SQL statement will then be grouped so each distinct value in this field is returned only once.
- Syntax
- Parameters
[Inline: ..., -GroupBy='Category'] ... [/Inline]Examples
See the Lasso 8 Language Guide for examples of how to use this tag.
| Tag Link | -GroupBy | Category | Database |
|---|---|---|---|
| Type | Command | Data Source | Any |
| Support | Preferred | Version | 8.0 |
| Output Type | None | Security | None |
| Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0 |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft