TopNumberOfRows Property
Version: Available or changed with runtime version 1.0.
Specifies the maximum number of rows to include in the resulting data set of a query.
Applies to
- Query
Property Value
An integer that specifies the maximum number of rows to include in the resulting dataset. The default value for this property is 0.
Note
A value of 0 is the same as leaving the property blank. If you set the value to 0, then there is no limit and all rows of the dataset are returned.
Syntax
TopNumberOfRows = 10;
Remarks
You use the TopNumberOfRows property to limit the resulting dataset to the first set of rows that are generated for the query. For example, you can include only the first 10 or first 100 rows in the resulting dataset. The TopNumberOfRows property is useful for key performance indicators such as the top number of customers or sales.
You can also specify the number of rows to include in the dataset by calling the TopNumberOfRows Method from AL. The TopNumberOfRows method will overwrite the TopNumberOfRows property setting.
See Also
Query Object
Linking and Joining Data Items
Aggregating Data in Query Objects
Filtering Data in Query Objects
Properties
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기