Hi Luigi,
thanks for the information. Unfortunately I can't use the select+where
statement you proposed as in my case
"inE('commented')[comment.in('deleted').size()=0].comment"
is actually part of a select statement of a bigger query.
But I'm happy to hear that this is being fixed in the coming releases!
Until then I'll probably have to do multiple queries and manually combine
the result sets.
Best regards,
Jonathan
On Monday, May 25, 2015 at 10:46:09 AM UTC+2, Luigi Dell'Aquila wrote:
>
> Hi Jonathan,
>
> I'm afraid here the problem is in the current executor, that is failing to
> correctly evaluate the expression between square brackets. We are working
> on it, so you can expect fixes to this in next releases.
>
> In the meantime you can achieve the same result with the following query
>
> select from (
> select inE("commented").comment from Message
> ) where in("deleted").size() = 0
>
> Luigi
>
>
>
> 2015-05-24 13:16 GMT+02:00 Jonathan Kienzle <[email protected]
> <javascript:>>:
>
>> Hello,
>>
>> I have the following structure:
>> User --commented--> Message
>> User --deleted--> Comment
>>
>> The "commented" edge has a property "comment" which is a LINK to a
>> Comment vertex.
>>
>> Now I would like to get messages along with their comments that have not
>> been deleted.
>>
>> I tried the following query, but it returns no results:
>> SELECT inE('commented')[comment.in('deleted').size()=0].comment FROM
>> message
>>
>> Any ideas on how to achieve this?
>> I didn't find much documentation regarding the "filter by edge property"
>> functionality.
>>
>> Best regards,
>> Jonathan
>>
>> --
>>
>> ---
>> 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] <javascript:>.
>> 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.
