SourceTableView Property (Pages)
Version: Available from runtime version 1.0.
Sets the key, sort order, and filter you want to use to determine the view of the source table presented to the user.
Applies to
- Pages
Example
page 50101 MyCustomers
{
PageType = List;
SourceTable = Customer;
// The view of the Customer table is sorted by the Name and "No." fields on descending order.
SourceTableView = sorting (Name, "No.") order(descending)
where ("Balance (LCY)" = filter (>= 50000), "Sales (LCY)" = filter (<> 0));
layout
{
area(Content)
{
repeater(MyRepeater)
{
field(Name; Name) { }
field(Address; Address) { }
field("Balance (LCY)"; "Balance (LCY)") { }
}
}
}
}
For more information on how you can scan, find, and limit records in a list, see Sorting, Searching, and Filtering Lists.
Remarks
When you combine a descending sort order on SourceTableView with overriding the OnFindRecord, you may experience that the page displays the last record instead of the first when the page opens. You can resolve this condition by adding Rec.FindFirst
in the OnOpenPage trigger, or using Find(-)
in the OnFindRecord trigger.
See Also
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho