Hi Nicolas,
The work-around for this is to use a SELECT as follows:
SELECT parent, child, child.out("contains") as file FROM (
MATCH
{class: Folder, as: parent}-parent_of->{class: Folder, as: child,
optional: true}
RETURN parent, child
) UNWIND file
Thanks
Luigi
2017-04-13 14:09 GMT+02:00 nicolas treiber <[email protected]>:
> Thanks Luigi, that works. Also I have another question about optionals.
> Starting with the same example, let's say that Folders may contain Files
> and I want to get the files of the children folders (not the current folder
> (of course that's just an example, it's pretty useless because we would
> usually get the files of the parent folder...). I'd like to do something
> like:
> MATCH {class: Folder, as: parent}-parent_of->{class: Folder, as: child,
> optional: true}->contains->{class: File, as: file, optional: true} RETURN
> parent, child, file
> But it does not wok because "optional" must be at the end of a match
> chain... Any idea of a workaround for that ?
>
> Le dimanche 2 avril 2017 11:24:34 UTC+2, Luigi Dell'Aquila a écrit :
>>
>> No, sorry, you don't need the SELECT and the UNWIND, you can just use the
>> inner match:
>>
>> MATCH {class: Folder, as: parent}.outE("parent_of"){as: theEdge,
>> optional: true} RETURN parent, theEdge, theEdge.inV() as child
>>
>> (there was also a mistake in my previous answer, it was inV(), not in() )
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2017-04-02 11:22 GMT+02:00 Luigi Dell'Aquila <[email protected]>:
>>
>>> Hi Nicolas,
>>>
>>> I'm afraid it's not supported yet, you can work around it with a
>>> SELECT/MATCH like follows:
>>>
>>> SELECT FROM (
>>> MATCH {class: Folder, as: parent}.outE("parent_of"){as: theEdge,
>>> optional: true} RETURN parent, theEdge, theEdge.in() as child
>>> ) UNWIND child
>>>
>>> I hope it helps
>>>
>>> Thanks
>>>
>>> Luigi
>>>
>>>
>>>
>>> 2017-03-31 14:20 GMT+02:00 nicolas treiber <[email protected]>:
>>>
>>>> Hello,
>>>>
>>>> I'm facing a problem with a MATCH query in orientDB 2.2. I have a
>>>> folder tree structure (a 'Forlder' node, and a 'parent_of' edge) and I have
>>>> data on the relationships. What I try to achieve is to get all the tree at
>>>> once with the relationships data. I successfully got the tree without the
>>>> data that way:
>>>> MATCH {class: Folder, as: parent}-parent_of->{class: Folder, as: child,
>>>> optional: true} RETURN parent, child
>>>> (I need the optional set to true to get the folders with no child)
>>>>
>>>> To get the edges' data I proceeded that way:
>>>> MATCH {class: Folder, as: parent).outE('parent_of'){as:
>>>> edge}.inV(){class: Folder, as child, optional: true} RETURN parent, edge,
>>>> child
>>>> But it acts like there were no "optional", and folder without any child
>>>> are ignored.
>>>> I tried to add "optional: true" to the edge, but it unauthorized.
>>>> And finally i tried:
>>>> MATCH {class: Folder, as: parent).(outE('parent_of'){as:
>>>> edge}.inV()){class: Folder, as child, optional: true} RETURN parent, edge,
>>>> child
>>>> With that i have all the folders but edge is always empty, like if the
>>>> aliases in parenthesis were ignored.
>>>>
>>>> How can I fix that ?
>>>>
>>>> --
>>>>
>>>> ---
>>>> 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.
>>>>
>>>
>>>
>> --
>
> ---
> 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.
>
--
---
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.
