Hi,
for sensors I would say:
SELECT
FROM Sensor
WHERE isDeleted = true AND
1 in in('DeviceHasSensors').in('UserHasDevices').userId
For devides it's simpler:
SELECT
FROM Device
WHERE isDeleted = true AND
1 in in('UserHasDevices').userId
Cheers,
Riccardo
2015-07-13 23:25 GMT+02:00 Yasith Lokuge yasi...@gmail.com:
I have a Graph database with three simple Vertex types, User, Device and
Sensor. The relationship goes as,
Edges: UserHasDevices, DeviceHasSensors
Each edge has a property name isDeleted. When deleting a Vertex, I don't
make it deleted permanently but make the isDeleted property of the Edge
as true. Please let me know How to query a list of deleted sensors, and /
or deleted list of devices, which belongs to a particular user, identified
by user id.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an
email to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.