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.