LassoScript Utility
Basics Browse Detail

-GroupBy

Tag Link -GroupBy Category Database
Type Command Source Available No
Support Preferred Version 8.0
Change Unchanged Data Source Any
Output Type None Security None
Implementation LCAPI Sets Lasso 8.5, Lasso 8.0

Description

-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

[Inline: ..., -GroupBy='Category'] ... [/Inline]

Parameters

Required Parameters
Field Name The name of the field which is to be used to group the results.

Examples

See the Lasso 8 Language Guide for examples of how to use this tag.