Grouping data

GROUPISLAST – Identify last n records

68 views June 1, 2018 admin 0

Overview

This Custom Field returns TRUE for a record in the last n positions of a group.

Syntax

GROUPISLAST(GroupPath,SortField,Positions)

Element Description
GroupPath Group path delimited by colons.
SortField Field used to sort records by within the group.
Positions Optional field. The number of positions to be recorded. Defaults to 1.

Examples

GROUPISLAST(Parent Category:Child Category,Colour,2)

Colour GROUPISLAST
Red FALSE
Green FALSE
Red TRUE
Yellow TRUE

GROUPISLAST(Parent Category:Child Category,Colour,3)

Colour GROUPISLAST
Red FALSE
Green TRUE
Red TRUE
Yellow TRUE

EasyCatalog Panel Example

GROUPISLAST(Category1ID:Category2ID:Category3ID:CollectionID,Colour,2)

Records 7 and 8 return TRUE as they are the last 2 items in the CollectionID group.

# ProductInstanceID Category1ID Category1Name Category2ID Category2Name CollectionID CollectionName ProductID ProductCode ProductName Colour Height Width Price GROUPISLAST
1 2344 23 Hardware 454 Brass 2767 xxxx 15068 A1234 16mm screw Red 25 3 $1.50 TRUE

See also

GROUPISFIRST

GROUPFIRST

GROUPLAST

Was this helpful?