How can I limit the number of records returned from a glide query?

[mpsteve137]

Obvious answer is the add the property:

But even after adding this and running this fixed script:

I'm getting over 10 results:

Am I doing something wrong here?

[Allen Andreas]

Hi,

To limit records returned in a query, you can use:

gr.setLimit(number);

That system property isn't going to affect that query.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hi,

Can you also add in a getProperty line to see what it's reporting back?

So like: var prop = gs.getProperty('glide.db.max_view_records');

Please mark reply as Helpful/Correct, if applicable. Thanks!

[mpsteve137]

gs.info(gs.getProperty('glide.db.max_view_records')); is returning 10

[Allen Andreas · Accepted solution]

This system property only works when querying a database view table.

Not normal tables.

Please mark reply as Helpful/Correct, if applicable. Thanks!