Console - DISPLAYS RECORD

Displays details on the given record from the last returned result-set.

Syntax

DISPLAY RECORD <record-number>

<record-number> Defines the relative position of the record in the last result-set.

Example

Query the database on the class Person to generate a result-set:

orientdb> SELECT FROM Person

---+-----+--------+----------+-----------+-----------+------
 # | RID | PARENT | CHILDREN | NAME      | SURNAME   | City
---+-----+--------+----------+-----------+-----------+------
 0 | 5:0 | null   | null     | Giuseppe  | Garibaldi | -6:0
 1 | 5:1 | 5:0    | null     | Napoleon  | Bonaparte | -6:0
 2 | 5:2 | 5:3    | null     | Nicholas  | Churchill | -6:1
 3 | 5:3 | 5:2    | null     | Winston   | Churchill | -6:1
 4 | 5:4 | null   | [2]      | Barack    | Obama     | -6:2
 5 | 5:5 | 5:4    | null     | Malia Ann | Obama     | null
 6 | 5:6 | 5:4    | null     | Natasha   | Obama     | null
---+-----+--------+----------+-----------+-----------+------
7 item(s) found. Query executed in 0.038 sec(s).

With the result-set ready, display record number four in the result-set, (for Malia Ann Obama):

orientdb> DISPLAY RECORD 5

------------------------------------------------------------------------
Class: Person   id: 5:5   v.0
------------------------------------------------------------------------
  parent : Person@5:4{parent:null,children:[Person@5:5, Person@5:6],
           name:Barack,surname:Obama,city:City@-6:2}
 children : null
     name : Malia Ann
  surname : Obama
      city : null
------------------------------------------------------------------------

For more information on other commands, see Console Commands.

OrientDB

Console - DISPLAYS RECORD