Database Methods

View

db._view(view-name)

Returns the view with the given name or null if no such view exists.

arangosh> view = db._view("example");
........> // or, alternatively
arangosh> view = db["example"]

Show execution results

[ArangoView 88610, "example" (type arangosearch)]
[ArangoView 88610, "example" (type arangosearch)]

Hide execution results

db._view(view-identifier)

Returns the view with the given identifier or null if no such view exists.Accessing views by identifier is discouraged for end users. End users shouldaccess views using the view name.

Examples

Get a View by name:

arangosh> db._view("demoView");

Show execution results

[ArangoView 100, "demoView" (type arangosearch)]

Hide execution results

Unknown View:

arangosh> db._view("unknown");

Show execution results

null

Hide execution results

Create

db._createView(name, type, properties)

Creates a new View.

name is a string and the name of the View. No View or collection with thesame name may already exist in the current database. For more information onvalid View names please refer to the naming conventions.

type must be the string "arangosearch", as it is currently the onlysupported View type.

properties is an optional object containing View configuration specificto each View-type. Currently, only ArangoSearch Views are supported. SeeArangoSearch View definition fordetails.

Examples

arangosh> v = db._createView("example", "arangosearch");
arangosh> v.properties()
arangosh> db._dropView("example")

Show execution results

[ArangoView 88602, "example" (type arangosearch)]
{ 
  "writebufferIdle" : 64, 
  "writebufferActive" : 0, 
  "primarySort" : [ ], 
  "writebufferSizeMax" : 33554432, 
  "commitIntervalMsec" : 1000, 
  "consolidationPolicy" : { 
    "type" : "tier", 
    "segmentsBytesFloor" : 2097152, 
    "segmentsBytesMax" : 5368709120, 
    "segmentsMax" : 10, 
    "segmentsMin" : 1, 
    "minScore" : 0 
  }, 
  "cleanupIntervalStep" : 2, 
  "links" : { 
  }, 
  "consolidationIntervalMsec" : 10000 
}

Hide execution results

All Views

db._views()

Returns all views of the given database.

Examples

List all views:

arangosh> db._views();

Show execution results

[ 
  [ArangoView 100, "demoView" (type arangosearch)], 
  [ArangoView 88613, "exampleView" (type arangosearch)] 
]

Hide execution results

Drop

db._dropView(name)

Drops a view named name and all its data. No error is thrown if there isno such view.

db._dropView(view-identifier)

Drops a view identified by view-identifier with all its data. No error isthrown if there is no such view.

Examples

Drop a view:

arangosh> db._createView("exampleView", "arangosearch");
arangosh> db._dropView("exampleView");
arangosh> db._view("exampleView");

Show execution results

[ArangoView 88607, "exampleView" (type arangosearch)]
null

Hide execution results