Rowset.each()

note

This article is about the each() function of the Rowset object.

Rowset.each()

Iterates the execution of a function for each row set contained in the Rowset object.

Returns a Promise object or the 'this' object. From USoft 10.0.1I, returns a udbPromise instead of a Promise object.

Syntax  

*row-set*.each( function ( *index*, *row-set* ), *promise* )

*promise*    ::= { true | false }

The required function is the function to be executed.

The optional index is the index key of the item in the rowset collection for which the function is executed. The index is 0-based: the first item has index 0, not 1.

The optional row-set is the row set itself. Effectively, this is the same object as returned by 'this'.

If the optional promise has the value of 'true' (the default), a Promise object is returned. The .then() clause for this Promise is executed once all Promises created by the function passed to .each() have been settled. If promise has the value of 'false', the ‘this’ object is returned instead.

Example

This example shows the use of 'this' rather than the use of the index and rs parameters. For each of the specified rowsets, two actions are executed, of which the second is applied recursively to each record:

$.udb(["DEPT","EMP"]).rowSet('queried').each(
    function() {
        console.log(this.keysString());
        this.rows().each(function() {
            console.log(this.cols('NAME').val() );
            }
        }
);