ITableOperationsSearchRecords Method

Object[] SearchRecords(
	string sortField,
	bool ascending,
	string searchText,
	StringComparison comparison = StringComparison.OrdinalIgnoreCase
)

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

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

abstract SearchRecords : 
        sortField : string * 
        ascending : bool * 
        searchText : string * 
        ?comparison : StringComparison 
(* Defaults:
        let _comparison = defaultArg comparison StringComparison.OrdinalIgnoreCase
*)
-> Object[] 

function SearchRecords(sortField, ascending, searchText, comparison);

Parameters

sortField  String

Field name to order-by.

ascending  Boolean

Sort ascending flag; set to false for descending.

searchText  String

Text to search.

comparison  StringComparison  (Optional)

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

Return Value

This function searches records locally after query from database, this way SearchableAttribute functionality will work even with fields that are modeled with the EncryptDataAttribute and use the LikeExpression. 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, String). 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