TableOperationsTQueryRecords(String, RecordRestriction, Int32) Method

public IEnumerable<T> QueryRecords(
	string? orderByExpression = null,
	RecordRestriction? restriction = null,
	int limit = -1
)

Public Function QueryRecords ( 
	Optional orderByExpression As String = Nothing,
	Optional restriction As RecordRestriction = Nothing,
	Optional limit As Integer = -1
) As IEnumerable(Of T)

public:
IEnumerable<T>^ QueryRecords(
	String^ orderByExpression = nullptr, 
	RecordRestriction^ restriction = nullptr, 
	int limit = -1
)

function QueryRecords(orderByExpression, restriction, limit);

Parameters

orderByExpression  String  (Optional)

Field name expression used for sort order, include ASC or DESC as needed - does not include ORDER BY; defaults to primary keys.

restriction  RecordRestriction  (Optional)

Record restriction to apply, if any.

limit  Int32  (Optional)

Limit of number of record to return.

Return Value

If no record restriction or limit is provided, all rows will be returned.

If any of the restriction parameters reference a table field that is modeled with either an EncryptDataAttribute or FieldDataTypeAttribute, then the function GetInterpretedFieldValue(String, Object) will need to be called, replacing the target parameter with the returned value so that the field value will be properly set prior to executing the database function.

Reference