How to Limit the Amount of Rows in Google Apps Script?

Question

Similar to the limit formula in Google Sheets:

=query(F1:F, "select F where F contains '5' limit 10")

How would I limit the amount of returning rows in Google Apps Script, when I want to limit the results? Here is what I have where it pastes my return rows, and the function works correctly, but I need to limit the results to 20:

 ws.getRange(6, 11, rows.length, rows[0].length).setValues(rows);

Any suggestions?

Answer 1

Limiting Rows

var r=rows.slice(0,20);
ws.getRange(6, 11, r.length, r[0].length).setValues(r);

Array.slice