Synergex.SynergyDE.Select.NoCaseGroupBy

Group selection results (case insensitive)

namespace Synergex.SynergyDE.Select
public class GroupBy
public class NoCaseGroupBy extends GroupBy

The NoCaseGroupBy class extends the GroupBy class. Like the GroupBy class, the NoCaseGroupBy object provides a subset of the functionality of a SQL “GROUP BY” clause, which arranges identical data into groups, and returns distinct records based on field specifications. However, NoCaseGroupBy is designed for alpha fields that require a case-insensitive sort and cannot be used with integer fields, while GroupBy is case sensitive and can also be used with integer fields.

Constructors

NoCaseGroupBy

public static varargs NoCaseGroupBy(field1, ...)

Sorts and groups records without case sensitivity.

To build code with the NoCaseGroupBy constructor, -qrntcompat must be 12030100 or higher.

Operators

The logical and operator (&& or .AND.) is supported and is equivalent to its Synergy counterpart. See Expressions for more information about this operator.

Discussion

Changes to the file after making the selection may not be reflected in the records retrieved, especially if a record that matches the selection criteria is updated or inserted.

If you need case-sensitive grouping of records, use Synergex.SynergyDE.Select.GroupBy. You can combine GroupBy and NoCaseGroupBy using the .AND. operator if only some fields require case insensitivity or if some fields are integer. For example,

sobj = new Select(new Sparse("*"), from, wobj, 
&  new GroupBy(fld1).and.(new NoCaseGroupBy(fld2)))