Hi,
Thank you!
Thought that it could not be easy :-) Meantime realized that there are
nodes and egdes in chain :-) but not projected result sets like in rdbms
world.
Unfortunately I am not a developer, but a guy in business side with some it
skill, so somehow I need to make it with out of the box solution to proof
that it worth to spend time on it. So maybe javascript function can be the
answer somehow.
@Andrey, could you please share your use case and solution with me?
Orientdb lacks of complete, step by step tutorial, or at least I did not
find too many.
Thx!
L.
2014.03.27. 2:08 ezt írta ("Andrey Yesyev" <[email protected]>):
> Hi there,
>
> I have the similar problems. I solved them using Gremlin-Groovy.
> I doubt you can do what you need using SQL.
>
>
> -Andrey
>
> On Tuesday, March 25, 2014 3:58:06 PM UTC-4, László Rékasi wrote:
>>
>> Hi,
>>
>> I have the following datastructure (every entity has its own class):
>> vertexes : vA, vB, vC, vD, vE
>> there is eAB between vA and vB with one to many relation
>> eBC between vB and vC with one to many relation
>> eDC between vD and vC with one to many relation from D to C (so vC is a
>> for resolving many to many between vB and vD, but having lots of properties)
>> eED between vE and vD with one to many relation from E to D
>>
>> Now I would like to find vA and vD nodes where there is a path between
>> with the following conditions and expectations:
>>
>> - I need the ID and some fields from both vA and vD
>> - want to know the number of path between vA and vD
>> - want to sum() some fields in vC as weight
>> - want to filter on fields of all vertexes (vA.fld='X', vB.fld_b =
>> 'Y', etc
>>
>> Basically the situation is something like:
>> [person] - (having)->[user accounts]
>> [user account]-(post)->[message]-(to)->[recepients' account]
>> [recepient's account]-(belongs to)->[user]
>>
>> So want to know who sent messages in certain time to X type of user and
>> how many times. Wants to know the first and last date. The sender belongs
>> to Y domain.
>> person.domain = 'Y'
>> message.sent_date between D1 and D2
>> user.type = 'hacker'
>>
>> I need it in SQL.
>>
>> Any suggestion is very appreciated!
>> Thank you in advance!
>> L.
>>
> --
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "OrientDB" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/orient-database/IKbefI2QA3M/unsubscribe.
> To unsubscribe from this group and all its topics, 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.
