Querying using Inheritance

[akshatkhareCCOMTL]

Hello Everyone, I am new to ArcadeDB. So help me out on querying using inheritance(labels). Below is the the whole schema and data, along with the whole graph of the data for reference .

Now for the question
I want to query g.V().outE().inV().hasLabel("EMPLOYEE"). But this results in zero rows, while g.V().outE().inV().hasLabel("SENIOR") results in one row. If ArcadeDB follows inheritance as the schema described below, both query results should be the same as "SENIOR" inherits from "EMPLOYEE". I tried to do chatGPT on this(not sure how accurate the answer is) and it suggested

Edges Are Between Subclasses, Not "EMPLOYEE" Directly
Your schema defines EMPLOYEE as a base class.
However, all your vertices have subtypes (JUNIOR, SENIOR, etc.).
The edges are not connecting EMPLOYEE directly but its subclasses.

 database.command("sql", "CREATE VERTEX TYPE EMPLOYEE IF NOT EXISTS;")
  // Define subclasses
  database.command("sql", "CREATE VERTEX TYPE JUNIOR EXTENDS EMPLOYEE;")
  database.command("sql", "CREATE VERTEX TYPE SENIOR EXTENDS EMPLOYEE;")
  // Further subclassing
  database.command("sql", "CREATE VERTEX TYPE MANAGER EXTENDS SENIOR;")
  database.command("sql", "CREATE VERTEX TYPE TEAMLEAD EXTENDS SENIOR;")
  database.command("sql", "CREATE EDGE TYPE COLLEAGUE;")
  database.command("sql", "CREATE EDGE TYPE WORKS_UNDER EXTENDS COLLEAGUE;")
  database.command("sql", "CREATE EDGE TYPE OVERLOOKS EXTENDS COLLEAGUE;")
  database.command("sql", "CREATE EDGE TYPE MANAGES EXTENDS OVERLOOKS;")
  var JOHN = graph.addVertex("JUNIOR")
  JOHN.property("Name", "JOHN")
  var BOB = graph.addVertex("JUNIOR")
  BOB.property("Name", "BOB")
  var CHRIS = graph.addVertex("SENIOR")
  CHRIS.property("Name", "CHRISTOPHER")
  var TOM = graph.addVertex("TEAMLEAD")
  TOM.property("Name", "TOM")
  var LEO = graph.addVertex("MANAGER")
  LEO.property("Name", "LEO")

  JOHN.addEdge("COLLEAGUE", BOB)
  BOB.addEdge("COLLEAGUE", JOHN)
  BOB.addEdge("WORKS_UNDER", CHRIS)

  JOHN.addEdge("WORKS_UNDER", CHRIS)
  CHRIS.addEdge("WORKS_UNDER", TOM)
  LEO.addEdge("MANAGES", TOM)

Any and every answers or guidance will be appreciated. Thanks :))

[lvca]

Hi, that gremlin query could be shortened to g.V().out().hasLabel("EMPLOYEE"). It looks like the hasLabel() in Gremlin doesn't consider inheritance for that case. Since inheritance is a concept that doesn't exist in Gremlin, we hooked up the concept of label with ArcadeDB types.

The opposite query should work, can you try it?

g.V().hasLabel("EMPLOYEE").in()`

[akshatkhareCCOMTL]

It works!!!
Thank you so much!!