Table of Content
Group by Library Function

$LibGroup function allows the user to create a value group based on Value Library's table.
The function has the following parameters:

  1. Group number. Positive Integer.
  2. Data Set Name. String.
  3. Column List. Comma-separated string list or * for all columns.
  4. (optional, for '*' as column list only) Where clause. String, default value is empty that means 'all rows'.

Examples

  1. $LibGroup(2,Cities,Name,Country)
    where: 2 is a group name, 'Cities' is list name and 'Name,Country' - columns.
  2. $LibGroup(1,Cities,*) - create group #1 based on 'Cities' set with all columns included.
  3. $LibGroup(1,Cities,*,Country='USA') - create group #1 based on US Cities list.