Gemstone Data Library
Show/Hide TOC

# ITableOperationsQueryRecord(String, RecordRestriction) Method

Queries database and returns a single modeled table record for the specified restriction, execution of query will apply orderByExpression.

## Definition

Namespace: Gemstone.Data.Model
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.160 -- Release Build+0b65775365098d82320afec1fcaed7affaca67e3
C#
View Source Request Example

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

VB
View Source Request Example

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

C++
View Source Request Example

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

JavaScript
View Source Request Example

    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

Object
A single modeled table record for the queried record.

## Remarks

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.

## See Also

#### Reference

ITableOperations Interface
QueryRecord Overload
Gemstone.Data.Model Namespace