Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
The IsOnRow()
function returns a yes/no value that indicates that the indicated list has a specific Row selected; this can be achieved for example by using a list node (go to row), loop node (going though multiple rows in a list) or clicking on a row in a datagrid. or - in case a reference-field is used with this function - the reference-field has a value and is indeed pointing to a specific row in the referenced list (achieved using an assignment node).
When a List is on a specific row, you can access the values of the fields in the list (to read or write values). If you try to read or write specific fields in a list, when there is no current row, you will get a fault message with something like "there is no current row". So, to be sure you can access fields of a specific item in a list and to avoid this fault situation, you can check this using the IsOnRow function.
The list-node action Reset Row Position
will set the IsOnRow to false: there will be no specific row selected on the list. The assignment action Clear value
on a reference-field will clear the reference so it will no longer point to a specific row - the IsOnRow will in that case also yield false.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns True if the list has a specific row selected and the list-fields can be used to read/write values. Or - in case a reference-field is used - the reference field points to a specific row item in the list.
Returns False if the list has no current active row which can be used, or - in case a reference-field is used - the reference field is not yet set to point to a specific row (or has been cleared with an assignment node)
Name | Type | Required | Description |
---|---|---|---|
list
list
a list
reference
reference
a reference field pointing to a specific list
The NameOf()
function returns the name of an item from the data model.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the name of an item from the data model (the value as entered in the Name-property of the data-model item).
The Distinct()
function returns a list of unique values from a provided list of values. The list must contain only values of the same type, and they may be numbers, dates, concepts, texts, yes/no booleans.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a collection of values where duplicates are filtered out of.
The RowId()
function returns the ID of the current row of a list.
Any database list also has a numeric [ID] field which holds the numeric primary key value for each row and gets automatically incremented on each add new row action. When you use that ID field in your expressions, you will see it in the form [12345: ID]
, which does not make it immediately clear which field (or rather, which list) you are pointing to. Other fields use the Technical Name in expressions, which helps to understand where they are coming from. When using the RowId(list) function in expressions, you will see immediately to which list you are referring, so this makes it far more usable.
A RowId of a List-item has multiple forms:
directly displaying in a label, will use the ToString() version, and yields the combined identifying information for the List and the Row;
with the ToNumber() function, it will yield the numeric id value - same as the numeric [ID] field;
The Row ID value of one of the following:
The current row of a list (when using the List as parameter)
The referenced row of a reference field (when using a reference field as parameter)
Name | Type | Required | Description |
---|---|---|---|
Name | Type | Required | Description |
---|---|---|---|
This function is SQL compatible. For more information about SQL compatibility, see our .
Name | Type | Required | Description |
---|
data-item
field
a field from your data model
values
list
a list of values or elements of the same type.
| List | a list from the data-model |
| reference field | a reference field |
The IsNewRow()
function returns a boolean value that indicates if the specified row is newly created and not yet saved to the database.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns true if the specified row is not yet saved to the database. Returns false if the specified row is already saved to the database.
If the parameter is a list, then the current row of the list is taken.
If the parameter is a reference, then the referenced row is taken.
Name | Type | Required | Description |
---|---|---|---|
list
list
a database list
reference
reference
a reference to a row of a database list
The List
()
function creates a list-typed collection of the provided values so it can be used in other functions and features that work with a list. All values must be of the same type.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
A collection of same-typed values that can be used as a list in other functions or list-based features. This list can be iterated through, or a specific item can be accessed using its index-position, or using the Distinct function can be narrowed down to its unique values.
Returns Unknown
if one of the parameter values is unknown or outside the common valid boundaries.
Name | Type | Required | Description |
---|---|---|---|
value1
any
Accepts any (at least one) number of values of the same type.