Viewing edge property data issue in ArcadeDB

Question

I recently migrated over to Arcadedb from Orientdb. I'm having some issues viewing the values of edge properties.

Having typed in these commands (#632:2 is a correct rid for a ViewIncludes edge):

CREATE PROPERTY ViewIncludes.order INTEGER;
UPDATE #632:2 SET order = 1;
SELECT from `ViewIncludes` WHERE @rid = #632:2

I can't then see the order property in the result under Properties (graph view), nor is it an option in the label drop down nor does it appear in the json result. When I go to the database schema it does show a property called 'order'.

The purpose of this property is to order the returned vertices.

It worked fine in OrientDB. What am I doing wrong?

Answer 1

Congrats on your porting from OrientDB to ArcadeDB!

First of all, to add a property to an edge, you don't need to define a property. This is valid with both OrientDB and ArcadeDB.

What'd the result of this command?

UPDATE #632:2 SET order = 1;

Little thing, with both OrientDB and ArcadeDB you can replace this:

SELECT from `ViewIncludes` WHERE @rid = #632:2

Into this:

SELECT from #632:2