ITableOperationsQueryRecord(String, RecordRestriction) Method

Object? QueryRecord(
	string? orderByExpression,
	RecordRestriction? restriction
)

Function QueryRecord ( 
	orderByExpression As String,
	restriction As RecordRestriction
) As Object

Object^ QueryRecord(
	String^ orderByExpression, 
	RecordRestriction^ restriction
)

function QueryRecord(orderByExpression, restriction);

Parameters

orderByExpression  String

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

restriction  RecordRestriction

Record restriction to apply.

Return Value

If no record is found for specified restriction, null will be returned.

This is a convenience call to QueryRecords(String, RecordRestriction, Int32) specifying the RecordRestriction parameter with a limit of 1 record.

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