Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Limiting the Number of Records in a Query

Help Topics...

Overview

You can place a limit on the number of records that NL will return by entering "Limit=" in one of the FilterField parameters and entering a maximum number in the corresponding Filter parameter.

Examples

With Dynamics NAV, the following example displays the Customers with the ten largest sales.

=NL("Table","Customer",{"Name","Sales ($)"},"-Sales ($)","*","Limit=",10)

With Northwind, the following example will print the OrderIDs of the ten largest orders.

=NL("Rows","Order Subtotals","OrderID","-Subtotal","*","Limit=",10)

Published:

Limiting the Number of Records in a Query

Help Topics...

Overview

You can place a limit on the number of records that NL will return by entering "Limit=" in one of the FilterField parameters and entering a maximum number in the corresponding Filter parameter.

Examples

With Dynamics NAV, the following example displays the Customers with the ten largest sales.

=NL("Table","Customer",{"Name","Sales ($)"},"-Sales ($)","*","Limit=",10)

With Northwind, the following example will print the OrderIDs of the ten largest orders.

=NL("Rows","Order Subtotals","OrderID","-Subtotal","*","Limit=",10)

For an optimal Community experience, Please view on Desktop