Re: [orientdb] OrientDB sql query involving multiple classes

2018-03-28 Thread Ersin Sevinc
Yeahh!! it worked. Really thanks about that. "databasename": { "mapping": { "fromTable": "source table", "fromColumns": ["source field"], "toTable": "destination table", "toColumns": ["destination table"], "direction": "direct"

Re: [orientdb] OrientDB sql query involving multiple classes

2018-03-28 Thread Luigi Dell'Aquila
Hi Ersin, The problem seems to be in the python driver, did you try to run the queries in Studio and see if they work fine? If you are using OrientDB v 3.0 RC you can write a query as follows: MATCH {class:Company, as:company} <-PersonnelRelation- {as:person} RETURN company:{*}, person:{*}

Re: [orientdb] OrientDB sql query involving multiple classes

2018-03-27 Thread Ersin Sevinc
Thanks alot Luigi. You guys are really helping all developers. But i' ve an extra question for you :/ We have some problems about OrientObject is not Json serializable Error. Let me explain our code in simple way. We have Customers,Admins(Company),Product,Personel classes and CRUD for all of

Re: [orientdb] OrientDB sql query involving multiple classes

2018-03-03 Thread Ersin Sevinc
Hi there, m new at orient db trying to figure out something about relations , In this code Line => create edge owns from (select from Person where name = 'Matt') to (select from Car where model = 'Ferrari') We have edge between record to record. Its fine for few records. But what will happen

Re: [orientdb] OrientDB SQL

2016-11-22 Thread 'Hans-Jürgen Otto' via OrientDB
Hi Luigi, thank you! That was the problem. Regards, Hans. Am Dienstag, 22. November 2016 12:21:28 UTC+1 schrieb Luigi Dell'Aquila: > > Hi, > > by default OrientDB Studio Graph panel displays only 20 records. You can > override this behavior adding a "limit" at the end of the query, eg. > >

Re: [orientdb] OrientDB SQL

2016-11-22 Thread Luigi Dell'Aquila
Hi, by default OrientDB Studio Graph panel displays only 20 records. You can override this behavior adding a "limit" at the end of the query, eg. SELECT FROM V LIMIT -1 Thanks Luigi 2016-11-22 12:03 GMT+01:00 'Hans-Jürgen Otto' via OrientDB < orient-database@googlegroups.com>: > Hey guys, >

Re: [orientdb] Orientdb SQL query to check edge properties

2015-07-14 Thread Riccardo Tasso
Hi, for sensors I would say: SELECT FROM Sensor WHERE isDeleted = true AND 1 in in('DeviceHasSensors').in('UserHasDevices').userId For devides it's simpler: SELECT FROM Device WHERE isDeleted = true AND 1 in in('UserHasDevices').userId Cheers, Riccardo 2015-07-13 23:25 GMT+02:00 Yasith

Re: [orientdb] OrientDB sql query involving multiple classes

2014-03-27 Thread Andrey Lomakin
Hi, Could you try select name from Person where gender = 'M' and out('owns')[0].model = Ferrari and out('likes')[0].mov_name = Need For Speed On Thu, Mar 27, 2014 at 5:13 AM, Joel Mathew meetj...@gmail.com wrote: Hi group, I have below schema with three classes orientdb {demo1} select from