Hi
Can someone help with the UNWIND syntax for orientdb.
On Tuesday, April 18, 2017 at 6:07:35 PM UTC+5:30, Luigi Dell'Aquila wrote:
>
> OK, got it, if you only need the RIDs of the involved elements, you can do
> the following:
>
>
> MATCH
> {as:user} -Performs-> {as:process} -Uses->
> {class:Application, as:app, where:(applicationName = ?)} -RunsOn->
> {class:Server, as:server, where:(osType = ?)}
> RETURN user, process, app, server
>
> If you also want all the details in line, you can use an outer SELECT:
>
> SELECT user.* as user_, process.* as process_, app.* as app_, server.* as
> server_ FROM (
> MATCH
> {as:user} -Performs-> {as:process} -Uses->
> {class:Application, as:app, where:(applicationName = ?)} -RunsOn->
> {class:Server, as:server, where:(osType = ?)}
> RETURN user.name, process.id, app.name, server.url, server.name
> )
>
> The "as xxx_" will add a prefix to attributes, this is useful to avoid
> collisions, eg. if you have user.name and server.name, this way you will
> have "user_name" and "server_name"
>
> If you don't need all the patterns, but you only need single records that
> are part of the result, you can try the following:
>
>
> MATCH
> {as:user} -Performs-> {as:process} -Uses->
> {class:Application, as:app, where:(applicationName = ?)} -RunsOn->
> {class:Server, as:server, where:(osType = ?)}
> RETURN $elements
>
> Thanks
>
> Luigi
>
>
> 2017-04-18 14:30 GMT+02:00 Chaitanya deep singh Jhala <[email protected]
> <javascript:>>:
>
>> Hi Luigi
>>
>> Thanks for your quick response.
>>
>> Actually I don't want to mention any details related to the Vertex.
>> Suppose for User vertex I have 5 attributes, same as for Process vertex I
>> have 3 attributes, So, If these two Vertex are related to osType and
>> applicationName then i want all the details of Vertex attributes without
>> mentioning attribute details.
>> Example :
>> In simple sql query we are writing Select * from User and we will get all
>> the details of User.
>>
>> Hope you are understand what I am actually looking for.
>>
>> Thanks
>> Chaitanya
>>
>> On Tuesday, April 18, 2017 at 5:42:31 PM UTC+5:30, Luigi Dell'Aquila
>> wrote:
>>>
>>> Hi,
>>>
>>> A MATCH statement is what you need:
>>>
>>> MATCH
>>> {as:user} -Performs-> {as:process} -Uses->
>>> {class:Application, as:app, where:(applicationName = ?)} -RunsOn->
>>> {class:Server, as:server, where:(osType = ?)}
>>> RETURN user.name, process.id, app.name, server.url, server.name
>>> /* just add here all the info you need */
>>>
>>> Full reference here http://orientdb.com/docs/2.2.x/SQL-Match.html
>>>
>>> I hope it helps
>>>
>>> Thanks
>>>
>>> Luigi
>>>
>>>
>>>
>>>
>>> 2017-04-18 14:00 GMT+02:00 Chaitanya deep singh Jhala <
>>> [email protected]>:
>>>
>>>> Hi
>>>>
>>>> I have some doubts related to the queries in orientdb. I have below
>>>> scenario :
>>>>
>>>> Example :
>>>>
>>>> Performs Uses RunsOn
>>>> User --> Process --> Application --> Server
>>>>
>>>> Here , User/Process/Application/Server are Vertex Names
>>>> Performs/Uses/RunsOn are Edge Names
>>>>
>>>> Now, I want all the related combination result as per the input.if
>>>> input is like osType of Server and applicationName of Application then i
>>>> want all the details related to this two inputs like user and process and
>>>> whatever is related to this applicationName and osType.
>>>>
>>>> It is possible in orientdb to fetch out all this details in a single
>>>> query ??
>>>>
>>>>
>>>> Thanks & Regards
>>>> Chaitanya
>>>>
>>>> --
>>>>
>>>> ---
>>>> 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] <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.
