Hi;
I have a Document database with 2 classes - Pool and ID.
One Pool can have many ID. ID belongs only to one Pool.
create class Pool
create class ID
create property ID.Poolname link Pool --> Poolname property in ID class
points to the Pool class.
insert into Pool (Poolname, pooltype, selectioncriteria,
heartbeatinterval, commtimeoutinterval, hold, update_ts)
VALUES
("UserNamePool", 1, "blahblah", 90, 1200, 0, "2009-12-10
10:00:00")
insert into ID ( idname, Poolname,sessiontype, allocated, timedout, hold,
username, update_ts)
VALUES
( "idname121", *(select @RID from Pool where Poolname="UserNamePool")*,
"alc", 0, 0, 0, "PeggySue", "2010-07-06 10:00:000")
Is "bold" section the correct way of storing reference to the Pool class?
Now I want to write a query which will select everything from ID class
where Poolname="UserNamePool".
I tried :
select from ID where ID.Poolname='UserNamePool'
and
select from ID where ID.Poolname = (select @RID from Pool where
Poolname='HostAddressPool')
Both return 0 items found.
should I use "traverse"?
Thanks for your help!
-Galina
--
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
