Move a cursor to beginning

Prerequisites:

Note

The listed prerequisites need to be run successfully before performing this procedure.

In the "getRecordsFromCursor" action, setting the "startFrom" property to true resets the cursor and moves it to the beginning of the recordset making it useful for rereading records from the beginning.

Note

The cursor is positioned before the beginning recordset so that you can fetch the next record and retrieve the first record in the recordset.

Behaviors of types of recordsets:

If the recordset is a table, it moves the cursor before the first record in the table.
If the recordset is an index, it moves the cursor before the first record in the index.
If the recordset is limited by a key range, it moves the cursor before the first record in the key range.

This procedure returns records in "id" order starting with the record that has the "id" field set to 4. A cursor that starts returning records can retrieve records from the "athlete" table in sorted order.

Note

The user has the ability to toggle between the property "startFrom" and "beforeFirstRecord" to position the cursor before the first record. In this procedure the index used is created using each athlete records "id", and will return all athletes that have an "id" greater than or equal to 4.

Paste this code into the API Request editor.

{
    "api": "db",
    "action": "getRecordsFromCursor",
    "params": {
        "cursorId": "clickApplyDefaultsToReplaceThisWithTheLastCreatedCursor",
        "fetchRecords": 1
    },
    "authToken": "clickApplyDefaultsToReplaceThisWithValidAuthToken"
}

Click Apply defaults to JSON request () to set the "authToken" to a valid value.
Click Send request ().
Verify the action completed successfully.
Note
"errorCode" with a value of 0 indicates success. "errorCode" with a non-zero value indicates a failure. See Errors and contact FairCom for more information about an error.