Row and rowList operations

If you need to add the rows of one rowList to the rows of another rowList, they are added just like list using listAdd:

=: listAdd(list: $row1; list: $row2)

row1: selectRowList(table: 'table_1'; field: 'field_1'; field: 'field_2')

row2: selectRowList(table: 'table_2'; field: 'field_1'; field: 'field_2')

This is often required in select codes:

=: listAdd(list: $row1; list: $row2)

row1: selectRowListForSelect(table: 'table_1'; field: 'title'; bfield: 'uiid')

row2: selectRowListForSelect(table: 'table_2'; field: 'title'; bfield: 'uiid')

rowListAdd — is used when you need to add a column with values to an existing rowList.

The column with values is passed as a list with the desired order of elements.

They will be added to the rowList in this order, so set the sorting accordingly. If there are no sorts, the result will differ from time to time:

=: rowListAdd(rowlist: $rowList; field: "field_3" = $list)

rowList: selectRowList(table: 'table_1'; field: 'field_1'; field: 'field_2'; order: 'field_1' asc)

list: selectList(table: 'table_2'; field: 'field_3'; order: 'field_1' asc)

If you need to add more than one column:

=: rowListAdd(rowlist: $rowList_1; rowlist: $rowList_2)

rowList_1: selectRowList(table: 'table_1'; field: 'field_1'; field: 'field_2'; order: 'field_1' asc)

rowList_2: selectRowList(table: 'table_2'; field: 'field_3'; field: 'field_4'; order: 'field_1' asc)

If you have a row and need a list of values contained in it, rowValues does this:

For example, let's take the field values in a list from 5 fields in the current row:

=: rowValues(row: $row)

row: selectRow(table: $#ntn; field: 'field_1'; field: 'field_2'; field: 'field_3'; field: 'field_4'; field: 'field_5'; where: 'id' = #id)

There is a similar function rowKeys, which takes the key names from row.

It is usually used together with listFilter, which can filter row (i.e., leave only those columns that meet the condition):

Get the names of all fields where the value is greater than 10:

=: rowKeys(row: $filter)

filter: listFilter(list: $row; key: "value" > 10)

row: selectRow(table: $#ntn; field: 'field_1'; field: 'field_2'; field: 'field_3'; field: 'field_4'; field: 'field_5'; field: 'field_6'; field: 'field_7'; field: 'field_8'; field: 'field_9'; field: 'field_10'; field: 'field_11'; field: 'field_12'; where: 'id' = #id)

Let's complicate this task: for example, these are months and we need to get the numbers of the months where the value is greater than 10.

=: listReplace(list: $keys; action: $new_value; value: "value")

        new_value:  strReplace(str: $#value; from: "field_"; to: "")
        // To get the numbers, we replace field_ with an empty string in each element of the list

keys: rowKeys(row: $filter)
// Here we get a list of string field names

filter: listFilter(list: $row; key: "value" > 10)

row: selectRow(table: $#ntn; field: 'field_1'; field: 'field_2'; field: 'field_3'; field: 'field_4'; field: 'field_5'; field: 'field_6'; field: 'field_7'; field: 'field_8'; field: 'field_9'; field: 'field_10'; field: 'field_11'; field: 'field_12'; where: 'id' = #id)

This task is performed by rowKeysRemove. You pass it a row or rowList and the names of the columns to be removed.

If you pass a rowList, you will need to specify recursive: true!

The task of renaming columns is solved using rowKeysReplace.

If you pass rowList instead of row, you will need to specify recursive: true!