SQL - FIND REFERENCES

Searches records in the database that contain links to the given Record ID in the database or a subset of the specified class and cluster, returning the matching Record ID’s.

Syntax

  1. FIND REFERENCES <record-id>|(<sub-query>) [class-list]
  • <record-id> Defines the Record ID you want to find links to in the database.
  • <sub-query> Defines a sub-query for the Record ID’s you want to find links to in the database. This feature was introduced in version 1.0rc9.
  • <class-list> Defines a comma-separated list of classes or clusters that you want to search.

This command returns a document containing two fields:

Field Description
rid Record ID searched.
referredBy Set of Record ID’s referenced by the Record ID searched, if any. In the event that no records reference the searched Record ID, it returns an empty set.

Examples

  • Find records that contain a link to #5:0:

    1. orientdb> FIND REFERENCES 5:0
    2.  
    3. RESULT:
    4. ------+-----------------
    5.  rid  | referredBy      
    6. ------+-----------------
    7.  #5:0 | [#10:23, #30:4] 
    8. ------+-----------------

  • Find references to the default cluster record

    1. orientdb> FIND REFERENCES (SELECT FROM CLUSTER:default)

  • Find all records in the classes Profile and AnimalType that contain a link to #5:0:

    1. orientdb>  FIND REFERENCES 5:0 [Profile, AnimalType]

  • Find all records in the cluster profile and class AnimalType that contain a link to #5:0:

    1. orientdb> FIND REFERENCES 5:0 [CLUSTER:profile, AnimalType]

For more information, see