Retrieve an ordered or reversed record collection
- Last UpdatedApr 08, 2026
- 1 minute read
This scenario guides you through the steps required to retrieve an ordered or reversed record collection for an analog table in the RealTime database (RTDB).
To identify the code associated with each step, see the code comments in the Example code section.
- RecordOrderCollection methods can be called with a record number to specify the starting record to create the collection from.
- To get the record collection in reverse order, use the GetReverseRecordOrderCollection method and ReverseRecordOrderCollection class.
To retrieve an ordered record collection
- Open the Program.cs file from the created project.
- Open the RTDB.
- Access the analog table.
- Lock the analog table for reading.
- Lock the record.
- Get an ordered record collection.
- Process the ordered record collection.
- Unlock the record.
- Unlock the analog table.
Example code
IRealTimeDatabase database = new RealTimeDatabase();
try
{
// Open the RTDB.
if (!database.IsOpen())
{
database.Open();
}
// Access the analog table.
using (IRealTimeTable table = new RealTimeTable("analog"))
{
ITableLockRequestType lockRequest = new TableLockRequestType();
IRecordLockRequestType recordLockRequest = new RecordLockRequestType();
// Lock the analog table for reading.
table.Lock(lockRequest.SAFE_READ);
// Get an ordered record collection.
var orderCollection = table.GetRecordOrderCollection();
// Process the ordered record collection.
foreach (var rtRecord in orderCollection)
{
// Lock the record for reading.
rtRecord.Lock(recordLockRequest.SAFE_READ);
Console.WriteLine(quot;Name: {rtRecord.ReadString("name")} has ptnum: {rtRecord.RecordNumber}");
rtRecord.UnLock();
} // Leaving scope releases the record lock.
} // Leaving scope releases the analog table lock.
}
catch (Exception ex)
{
Console.WriteLine(quot;Error occurred while getting the RecordOrderCollection: {ex.Message} has been raised");
}