Thanks for your quick response.Somewhere I am looking for the same result
down the line.One small doubt if we have more then one dependent Vertex
then how we will put it into the same query like Server IsMountedOn Storage
and Server IsConnectedTo Network.
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.
