Small and medium business | Business Central, N...

Query as a smart list - how to get Top Number Of Rows?

(0) Share

Report

Posted on by greex

104

Hi. I add in my query parameter 'TopNumberOfRows = 10'. Unfortunatelly - Smart List based on this query display more results than 10. Can I get only top10 records?

And second question - in Smart List I can only use filters 'inside' Query object? I can't filter this list from other objects/files?

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 81,798 Super User 2025 Season 1 on at

Like (0)

Report

RE: Query as a smart list - how to get Top Number Of Rows?

Hi, here is a simple example from MS.

Query.TopNumberOfRows([Integer]) Method - Business Central | Microsoft Learn

Hope this helps.
Thanks.

ZHU
Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

RE: Query as a smart list - how to get Top Number Of Rows?

TopNumberOfRows should work if done properly.

Maybe you can share your code?

learn.microsoft.com/.../topnumberofrows-function

There should also be plenty of filtering options both inside the object and on the query result.

learn.microsoft.com/.../devenv-query-overview