GetLastValue Function

  • Updated

Returns the specified field value of last member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified.

Syntax 1

 

Returns the specified field value of last member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified.

 

GetLastValue(collection, returnField, defaultReturnValue)

 

 

Arguments:

 

 

 

collection

Collection - A collection.

 

 

returnField

Field - The field with the value to return.

 

 

defaultReturnValue

Any - Default value of type of return field.

Syntax 2

 

Returns the specified field value of last member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified.

 

GetLastValue(collection, returnField, defaultReturnValue, orderby)

 

 

Arguments:

 

 

 

collection

Collection - A collection.

 

 

returnField

Field - The field with the value to return.

 

 

defaultReturnValue

Any - Default value of type of return field.

 

 

orderby

SortExpression - Field to order by.

Syntax 3

 

Returns the specified field value of last member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified.

 

GetLastValue(collection, returnField, defaultReturnValue, orderby, filter)

 

 

Arguments:

 

 

 

collection

Collection - A collection.

 

 

returnField

Field - The field with the value to return.

 

 

defaultReturnValue

Any - Default value of type of return field.

 

 

orderby

SortExpression - Field to order by.

 

 

filter

FilterExpression - A filter expression.

Remarks

  • Example: GetLastValue(LineItems, Quantity, 1) returns 42.
  • Example: GetLastValue(LineItems, Quantity, 1, ProductID, UnitPrice > 10) returns 42.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.