Hello, I'm running OrientDB 2.2.12 on Mac/Linux
I'm trying to perform a simple out() lookup from a class and get all
properties of another class. I can get all properties except @rid. I tried
different ways, but nothing seem to work or return the @rid. How do I get
the @rid as a property? Here is what I tried:
My class:
orientdb {db=Customers}> info class SellCampaign
CLASS 'SellCampaign'
Records..............: 1
Super classes........: [V]
Default cluster......: sellcampaign (id=149)
Supported clusters...: sellcampaign(149), sellcampaign_1(150),
sellcampaign_2(151), sellcampaign_3(152)
Cluster selection....: round-robin
Oversize.............: 0.0
PROPERTIES
+----+------------+----+-----------------+---------+--------+--------+----+----+-------+-------+
|# |NAME |TYPE|LINKED-TYPE/CLASS|MANDATORY|READONLY|NOT-NULL|MIN
|MAX |COLLATE|DEFAULT|
+----+------------+----+-----------------+---------+--------+--------+----+----+-------+-------+
|0 |leadCategory|LINK|LeadCategory |true |false |true | |
|default| |
+----+------------+----+-----------------+---------+--------+--------+----+----+-------+-------+
Here are the queries I tried:
// returns only leadCategory property
select expand(out('Sell')) from Account where @rid = #25:0
// returns only leadCategory property
select expand(out('Sell').include('@rid','leadCategory')) from Account where
@rid = #25:0
// results in error
select expand(out('Sell').include(@rid.asString(),'leadCategory')) from
Account where @rid = #25:0
Error on execution of command: sql.select
expand(out('Sell').include(@rid.asString(),'leadCategory')) from Account
where @rid = #25:0
DB name="Customers"
DB name="Customers"
If I simply run a select statement with @rid.asString() it works fine:
select @rid.asString(), leadCategory from SellCampaign
How do I get the @rid of the class when I traverse to it?
Please help.
--
---
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.
