ITableOperationsSearchRecords Method

Object?[]? SearchRecords(
	string sortField,
	bool ascending,
	StringComparison comparison = StringComparison.OrdinalIgnoreCase,
	params IRecordFilter?[]? recordFilter
)

Function SearchRecords ( 
	sortField As String,
	ascending As Boolean,
	Optional comparison As StringComparison = StringComparison.OrdinalIgnoreCase,
	ParamArray recordFilter As IRecordFilter()
) As Object()

array<Object^>^ SearchRecords(
	String^ sortField, 
	bool ascending, 
	StringComparison comparison = StringComparison::OrdinalIgnoreCase, 
	... array<IRecordFilter^>^ recordFilter
)

function SearchRecords(sortField, ascending, comparison, ... recordFilter);

Parameters

sortField  String

Field name to order-by.

ascending  Boolean

Sort ascending flag; set to false for descending.

comparison  StringComparison  (Optional)

StringComparison to use when searching string fields; defaults to ordinal ignore case.

recordFilter  IRecordFilter

Record Filters to be applied.

Return Value

This function searches records locally after query from database, this way Search functionality will work even with fields that are modeled with the EncryptDataAttribute and use restrictions not being = or =/=. Primary keys for this function will not be cached server-side and this function will be slower and more expensive than similar calls to QueryRecords(String, Boolean, Int32, Int32, IRecordFilter). Usage should be restricted to cases searching for field data that has been modeled with the EncryptDataAttribute.

This function does not paginate records, instead a full list of search records is returned. User can cache returned records and page through them using the GetPageOfRecords(Object, Int32, Int32) function. As a result, usage should be restricted to smaller data sets.

Reference