TableOperationsTQueryRecordsAsync(String, Boolean, Int32, Int32, CancellationToken, IRecordFilter) Method

public IAsyncEnumerable<T> QueryRecordsAsync(
	string? sortField,
	bool ascending,
	int page,
	int pageSize,
	CancellationToken cancellationToken,
	params IRecordFilter?[]? recordFilters
)

Public Function QueryRecordsAsync ( 
	sortField As String,
	ascending As Boolean,
	page As Integer,
	pageSize As Integer,
	cancellationToken As CancellationToken,
	ParamArray recordFilters As IRecordFilter()
) As IAsyncEnumerable(Of T)

public:
IAsyncEnumerable<T>^ QueryRecordsAsync(
	String^ sortField, 
	bool ascending, 
	int page, 
	int pageSize, 
	CancellationToken cancellationToken, 
	... array<IRecordFilter^>^ recordFilters
)

function QueryRecordsAsync(sortField, ascending, page, pageSize, cancellationToken, ... recordFilters);

Parameters

sortField  String

Field name to order-by.

ascending  Boolean

Sort ascending flag; set to false for descending.

page  Int32

Page number of records to return (1-based).

pageSize  Int32

Current page size.

cancellationToken  CancellationToken

Propagates notification that operations should be canceled.

recordFilters  IRecordFilter

Record Filters to be applied.

Return Value

This function is used for record paging. Primary keys are cached server-side, typically per user session, to maintain desired per-page sort order. Call ClearPrimaryKeyCache to manually clear cache when table contents are known to have changed.

If the specified sortField has been marked with EncryptDataAttribute, establishing the primary key cache operation will take longer to execute since query data will need to be downloaded locally and decrypted so the proper sort order can be determined.

This is a convenience call to QueryRecords(String, Boolean, Int32, Int32, RecordRestriction) where restriction is generated by GetSearchRestrictions(IRecordFilter) using recordFilters.

Reference