queryResult.getRowCount¶

Signature: queryResult.getRowCount()

Returns: Integer count - the number of rows in a result set

Get the number of rows in a result set.

Parameters¶

None

Example¶

// execute the query
var queryResult = qie.doSelectQuery("EMR Database", "select name, date_of_birth as dob from patient where patient_id = 1");
for (var i = 1; i <= queryResult.getRowCount(); i++) {
   qie.debug("User " + i + " has the name: " + queryResult.getNode("name", i));
}