[orientdb] Re: Create a graph model on orientDB

2017-08-18 Thread alessandrorota04
Hi, I hope this can help you. To create the graph you could use these query create class Tag extends v create property Tag.name String create class Place extends v create property Place.name String insert into Tag set name="tag01" insert into Tag set name="tag02" insert into Tag set

[orientdb] Re: How do I get just the record id as a string from a query?

2016-12-07 Thread alessandrorota04
Hi , have you a small dataset to reproduce quickly the problem ? Alessandro -- --- 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

[orientdb] Re: How do I get an embedded Object in a select query using ObjectApi?

2016-11-23 Thread alessandrorota04
Hi, could you post your code ? Alessandro -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options,

[orientdb] Re: How to get the value of a vertex in json, java graph api?

2016-11-22 Thread alessandrorota04
Hi, you could use Iterable resultEhr = g.command( new OCommandSQL("select @this.toJSON() as this from EHR where ehrId = '" + ehrId + "'") ).execute(); if (resultEhr.iterator().hasNext()){ Vertex ehr = (Vertex) resultEhr.iterator().next(); System.out.println(ehr.getProperty("this")); }

[orientdb] Re: How to insert JSON with Java Graph API?

2016-11-21 Thread alessandrorota04
You could use alter class yourclass superclasses v -- --- 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 orient-database+unsubscr...@googlegroups.com. For more

[orientdb] Re: Can't create edge within a transaction that creates a document

2016-11-17 Thread alessandrorota04
Hi Borov, you are right. If a document have a temporary id you can't create an edge from or to that document. -- --- 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

[orientdb] Re: How to insert JSON with Java Graph API?

2016-11-17 Thread alessandrorota04
Hi, you could try with OrientGraph g=new OrientGraph(yourPath); ODocument pruebaJson = new ODocument("Person"); JSONObject json = new JSONObject(); json.put("name","someone"); json.put("address","somewhere");

[orientdb] Re: Is it possible to get records without meta-information?

2016-11-17 Thread alessandrorota04
Hi, you can see tha answer by @tglman No is not possible to get out record without metadata, this are needed to reassociate the persistent data in case of update. Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To

[orientdb] Re: Can't create edge within a transaction that creates a document

2016-11-17 Thread alessandrorota04
Hi, have you seen the documentation ? Best regards, Alessandro -- --- 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

[orientdb] Re: creating records with rid #-1:-2 orientdb graph database?

2016-11-15 Thread alessandrorota04
Could you post more code ? Thanks -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit

[orientdb] Re: Live query getting stuck

2016-11-15 Thread alessandrorota04
Hi, could you share logs ? -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit

[orientdb] Re: Can't create edge with OCommandSQL

2016-11-14 Thread alessandrorota04
You should use ORecordId ORecordId rid1 = new ORecordId("9:0"); ORecordId rid2 = new ORecordId("10:0"); String sql = "create edge SentDirectPost from ? to ?"; graph.command(new OCommandSQL(sql)).execute(rid1, rid2); Best regards, Alessandro -- --- You received this message because you are

[orientdb] Re: Can't create edge with OCommandSQL

2016-11-14 Thread alessandrorota04
Hi, I have tried creating new vertex and it worked, but creating new edge it didn't work. String sql = "insert into v(name,surname) values (?,?)"; graph.command(new OCommandSQL(sql)).execute("John","Snow"); Hope it helps. -- --- You received this message because you are subscribed to the

[orientdb] Re: creating records with rid #-1:-2 orientdb graph database?

2016-11-14 Thread alessandrorota04
Hi, which version are you using ? -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit

[orientdb] Re: How do i add gremlin output as vertex property?

2016-11-11 Thread alessandrorota04
Hi, you could use g.V.map('id','age') For more infomation you could see this link . Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Re: Recover all embedded records in any class

2016-11-10 Thread alessandrorota04
>From previous versions to 2.2 if you created a database as document you had not the classes V and E. Instead starting from version 2.2 if you create a document database you have the classes V and E, and if your classes inherit from class V, you have a graph model otherwise you have a document

[orientdb] Re: Recover all embedded records in any class

2016-11-09 Thread alessandrorota04
Hi, you could use this javascript function var db=orient.getDatabase(); var classes=db.query('select name from (select expand(classes) from metadata:schema) where name not in ["_studio","OUser","OSchedule","E","V","OFunction","OIdentity","OTriggered","ORole","ORestricted","OSequence"]' ); var

[orientdb] Re: Recover all embedded records in any class

2016-11-09 Thread alessandrorota04
Hi, I think there isn't such command available to get all your documents with a query. Could be useful to you a javascript function? Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop

[orientdb] Re: Recover all embedded records in any class

2016-11-08 Thread alessandrorota04
Hi, you could use this query select expand($c) let $a = ( select expand(City) from v), $b = ( select from city ), $c = unionAll($a,$b) Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group

[orientdb] Re: Urgent:-OrientDB Java connection problem

2016-11-07 Thread alessandrorota04
Hi, I tried your code and it worked correctly. When you add your libraries, you can add all the libraries under the folder lib of your version of OrientDb. Kind regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To

[orientdb] Re: traverse in a graph with a restricted cluser throws a security exception rendering traverse unusable

2016-11-03 Thread alessandrorota04
Hi, what version are you using ? Alessandro -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options,

[orientdb] Re: select @rid from expand() not working

2016-10-28 Thread alessandrorota04
Yes, for any update etc you can use the @rid. Example update #12:1 set column1 = "value" Alessandro -- --- 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

[orientdb] Re: select @rid from expand() not working

2016-10-27 Thread alessandrorota04
Hi, subscription.fieldNames() returns only the properties and not the @rid that is a metadata. If you want to obtain the @rid you can use subscription.getIdentity(). If you print the result of subscription.toJSON() you can see the @rid. Esample

[orientdb] Re: Property Enums Support?

2016-10-24 Thread alessandrorota04
Hi, there is already an old issue on github Thanks, Alessandro -- --- 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

[orientdb] Re: "out_" array empty when there's too many outgoing edges

2016-10-12 Thread alessandrorota04
Hi Alexandre, could you post your code to replicate your problem ? Thanks, Alessandro -- --- 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

[orientdb] Re: How to merge multiple json files into one

2016-10-06 Thread alessandrorota04
Hi, why do you want to do it? However I don't think you can do it. Best regards, Alessandro -- --- 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

[orientdb] Re: Query for filter based on date of birth.

2016-09-29 Thread alessandrorota04
Hi, could you try with select dob, anniversary_date from (select expand(out('store_customer')) from #48:843) where is_deleted = 0 and in_store_customer['out = #48:843'].is_active = 1 and dob.format('-MM-dd') between '2016-09-29' to '2017-01-31' desc skip 0 limit 11 Best regards,

[orientdb] Re: How to import server side function and schema from one database to another?

2016-09-28 Thread alessandrorota04
Hi, have you already looked at the documentation ? Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails

[orientdb] Re: Limit Skip Query Issue

2016-09-26 Thread alessandrorota04
Hi, the problem occurs with the order by. Could you open an issue on github ? Thanks, Alessandro -- --- 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

[orientdb] Re: Limit Skip Query Issue

2016-09-26 Thread alessandrorota04
Hi, I have tested it on version 2.2.6 and it works. Example

[orientdb] Re: Wrong result with simple query

2016-09-26 Thread alessandrorota04
Hi, I've unswered you on stackoverflow with a workaround. Best regards, Alessandro -- --- 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

[orientdb] Re: Calling a custom function from the console?

2016-09-22 Thread alessandrorota04
Hi, in your function createSameDayOfYearEdges you must insert g.commit() and it works also from console. Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from

[orientdb] Re: Error on unmarshalling field

2016-09-22 Thread alessandrorota04
Hi, could you try this command from console repair database Thanks. -- --- 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

[orientdb] Re: Error on unmarshalling field

2016-09-22 Thread alessandrorota04
Hi, could you try this command delete from #33:2073 unsafe Thanks -- --- 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

[orientdb] Re: Error on unmarshalling field

2016-09-22 Thread alessandrorota04
Hi, we have done some tests but without success. How can we reproduce your problem ? Thanks -- --- 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

[orientdb] Re: Error on unmarshalling field

2016-09-22 Thread alessandrorota04
Hi, is your record a vertex or a document ? Thanks -- --- 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 orient-database+unsubscr...@googlegroups.com. For more

[orientdb] Re: How to setup distributed orientDB (Enterprise edition 2.2.9) in Sharding mode

2016-09-20 Thread alessandrorota04
Hi, have you seen the official documentation ? Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from

[orientdb] Re: How to remove outdated edges while importing data through etl in Orientdb?

2016-09-19 Thread alessandrorota04
Hi, can you explain better what you do with your update ? In any case when you delete a vertex the edges coming in and out of vertex are deleted. Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from

[orientdb] Re: decode RID from LinkBag in pyorient

2016-09-16 Thread alessandrorota04
Hi, you could use these commands requiredObj = client.command(' select expand(out("Eat")[0]) from Animal') print(requiredObj[0]._rid) For more information you can see this link Hope it helps. Alessandro -- --- You received this message

[orientdb] Re: Set cluster conflict strategy via Java API

2016-09-15 Thread alessandrorota04
Hi, what version of OrientDb are you using ? Thanks, Alessandro -- --- 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 orient-database+unsubscr...@googlegroups.com.

[orientdb] Re: Set cluster conflict strategy via Java API

2016-09-14 Thread alessandrorota04
Hi, you could use : OClass cl=g.createVertexType("Customer", "V"); cl.createProperty("name", OType.STRING); cl.addCluster("usa_customer"); cl.addCluster("china_customer"); cl.setClusterSelection("Round Robin") Hope it helps. Best regards, Alessandro -- --- You received this message

[orientdb] Re: Order BY @RID DESC stops working in 2.2

2016-09-14 Thread alessandrorota04
Hi Hartmut, I opened an issue to your problem (link ) Kind regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving

[orientdb] Re: Console gobbles up the semi-colon character - OrientDB version 2.2.9

2016-09-09 Thread alessandrorota04
Hi, you could use this command js; var i = 1; print(i); end; Hope it helps. -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: Looking for some help to query paths...

2016-09-09 Thread alessandrorota04
Hi, have you seen the aswer by Ivan Mainetti at this link ? Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: Using jdbc driver retrieve records

2016-09-09 Thread alessandrorota04
Hi, could you try with ResultSet rs = stmt.executeQuery("select in('employee_has_store_service').@rid as employee_id from (traverse out('service_has_pricing') from (traverse out('service_group_has_store_service') from (select from (select expand(out('store_has_service_group')['is_deleted =

[orientdb] Re: Using REST with Distributed Graph

2016-09-06 Thread alessandrorota04
Hi, I think you should check the connection to the node1 and if it were not online, you can connect to node2 Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails

[orientdb] Re: Will find the percentage of two values in query itself?

2016-08-31 Thread alessandrorota04
Thanks Scott, to help people with the queries, I use the documentation. For example in this case I used http://orientdb.com/docs/2.2/SQL-Functions.html#eval. Thanks for your advice, we will try to improve the documentation. Best regards, Alessandro -- --- You received this message because

[orientdb] Re: ORecordDuplicatedException with UNIQUE_HASH_INDEX and collate=ci

2016-08-30 Thread alessandrorota04
Hi, this will not solve the problem but I think the correct command for creating an index with case insensitive is collate CREATE INDEX [ON (prop-names [COLLATE ])] [] [METADATA Metadata Document} {JSON Index] Example: create index User.name on User (name collate ci) UNIQUE Kind regards,

[orientdb] Re: Best query to get all related vertices through an Edge?

2016-08-30 Thread alessandrorota04
Hi, you could use select *,$a.rid from (SELECT EXPAND(OUT('HasComments')) FROM #10:1) let $a= (select @rid from #10:1) Hope it helps -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails

[orientdb] Re: Will find the percentage of two values in query itself?

2016-08-29 Thread alessandrorota04
Hi, you could use select eval('customer_reach / is_used * 100')as percentage from (select in( 'customer_has_custom_offer').size() as customer_reach, in( 'customer_has_custom_offer') ['is_used=true'].size().asFloat() as is_used from (select expand(out( 'store_has_custom_offer')) from #32:0) where

[orientdb] Re: Pass special character string to Orient DB funcation

2016-08-29 Thread alessandrorota04
Hi, you could use var db = orient.getGraph(); var id= 1000; var mydesc = "Bollywood Superstar \"Akshay Kumar\", Ileana D'Cruz"; var desc=JSON.stringify(mydesc); var vkQuery = 'CREATE VERTEX post CONTENT {"id":'+ id+',"desc":'+ desc +'}'; var vkInsert = db.command("sql",vkQuery);

[orientdb] Re: Paging doesnt work with @rid > lower rid

2016-08-29 Thread alessandrorota04
Hi, could you explain better, what you want to achieve? Thanks -- --- 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 orient-database+unsubscr...@googlegroups.com.

[orientdb] Re: Using jdbc driver getting error java.lang.NoClassDefFoundError: com/orientechnologies/orient/core/db

2016-08-29 Thread alessandrorota04
Hi, could you post your code ? Thanks. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit

[orientdb] Re: Pass special character string to Orient DB funcation

2016-08-19 Thread alessandrorota04
Hi, you could use var db = orient.getGraph(); var id= 1000; var desc = "Bollywood Superstar Akshay Kumar, Ileana D'Cruz" var vkQuery = 'CREATE VERTEX post CONTENT {"id":'+ id+',"desc":"'+ desc + '"}'; var vkInsert = db.command("sql",vkQuery); Best regards, Alessandro -- --- You received

[orientdb] Re: Pass special character string to Orient DB funcation

2016-08-19 Thread alessandrorota04
Hi, I tried it and I did not have errors -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Re: Pass special character string to Orient DB funcation

2016-08-19 Thread alessandrorota04
Hi, could you post an example of your query to update input string special characters ? Thanks -- --- 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

[orientdb] Re: Pass special character string to Orient DB funcation

2016-08-18 Thread alessandrorota04
Hi, did you mean update the records ? If yes, you could use update Post set `desc`="yourDesc" where id=1000 beacuse desc is a reserved word and you must use `desc` Thanks, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To

[orientdb] Re: Pass special character string to Orient DB funcation

2016-08-18 Thread alessandrorota04
I'm sorry, I don't understand what you mean, could you explain better? Alessandro -- --- 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

[orientdb] Re: Pass special character string to Orient DB funcation

2016-08-18 Thread alessandrorota04
Hi, could you try with desc = 'WhatsApp funny Videos 2016\\nTry not to grin or Laugh Hardest\\n'; var vkQuery = "CREATE VERTEX post CONTENT {'id':"+ id+", 'desc':'"+ desc + "'}"; Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: Orient DB funcation has error when it call form node js Unhandled rejection OrientDB.RequestError

2016-08-18 Thread alessandrorota04
Hi, you could use var vkQuery = "CREATE VERTEX post CONTENT { 'thumbnail' : '" + vkString.thumbnail +"','comments' : '"+ vkString.comments + "','origin' : '"+vkString.origin + "','"; vkQuery = vkQuery + "userFullName' : '"+ vkString.userFullName +"','title' : '"+ vkString.title +"','userId'

[orientdb] Re: Javascript function - how to parse query result ?

2016-08-18 Thread alessandrorota04
Hi, you could use var name=record.getProperty("EMPRID").getId()+"--"+record.getProperty( "postRID").getId(); Best regards, Alessandro -- --- You received this

[orientdb] Re: Javascript function - query result

2016-08-17 Thread alessandrorota04
Hi, you could use var rs = db.query("select Name,Surname,Address from Person"); for(i=0;i

[orientdb] Re: Javascript function - how to parse query result ?

2016-08-17 Thread alessandrorota04
Hi, you can use getProperty("yourproperty") Example var g=orient.getGraph(); var b=g.command("sql","select from persona"); for(i=0;i

[orientdb] Re: Best query to get all related vertices through an Edge?

2016-08-16 Thread alessandrorota04
Hi, I think that SELECT EXPAND(OUT('HasComments')) FROM #10:1 is the best query to get all Comments from a Post through HasComments Kind regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and

[orientdb] Re: How to get specific edges counts from vertices with specific condition?

2016-08-11 Thread alessandrorota04
Hi, you could use this query select post._id ,post.title as title, post.in("UserLikes").size() as totalLikes, if(eval(" $a.size()==0 "),"false","true") as hasloggedUserLikedThisPost from (select out("UserPosts") as post,@rid from User where _id="1" unwind post) let $a= (select from

[orientdb] Re: How to get specific edges counts from vertices with specific condition?

2016-08-11 Thread alessandrorota04
Hi I have created the function named myFunction Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: How to get specific edges counts from vertices with specific condition?

2016-08-11 Thread alessandrorota04
Hi, I have created this javascript function with parameters rid1 and rid2 var g=orient.getGraph(); var b=g.command("sql","select from "+ rid1 + " where in('UserLikes') contains " + rid2); if(b.length==0) return false; return true; and I have used this query select post._id ,post.title as

[orientdb] Re: How to get specific edges counts from vertices with specific condition?

2016-08-11 Thread alessandrorota04
Hi, you could use select _id as postId, title, in("UserLikes").size() as totalLikes from ( select expand(out("UserPosts")) from User where _id="1") where type="technical post" -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe

[orientdb] Re: How to get specific edges counts from vertices with specific condition?

2016-08-11 Thread alessandrorota04
Hi, I have tried to reproduce your graph With this query I have obtained select _id as postId, title, in("UserLikes").size() as totalLikes from ( select

[orientdb] Re: Is it possible to create a class extending an existing class via the HTTP REST API?

2016-08-08 Thread alessandrorota04
Hi Mike, you could see http://orientdb.com/docs/2.2/OrientDB-REST.html Example : http://localhost:2480/command/MyDb/sql/create class YourClass extends v Kind regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To

[orientdb] Re: Estimated release date of v3.0?

2016-07-27 Thread alessandrorota04
Hi, you could see http://orientdb.com/docs/2.2/Roadmap.html Hope it helps. -- --- 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

[orientdb] Re: Functions in Oreintdb

2016-07-25 Thread alessandrorota04
Hi, you can use "select from V where out('E').out('E').in('E').name contains '" + nameinput + "'" Hope it helps. -- --- 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

[orientdb] Re: What does the transient field type do, what is it use and what is its purpose?

2016-07-25 Thread alessandrorota04
The transient keyword in Java is used to indicate that a field should not be serialized. Best regards, Alessandro -- --- 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

[orientdb] Re: Get return value

2016-07-22 Thread alessandrorota04
Hi, are you using studio, console or other ? Alessandro -- --- 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 orient-database+unsubscr...@googlegroups.com. For

[orientdb] Re: Functions in Oreintdb

2016-07-21 Thread alessandrorota04
Hi, in a function you can't use Java code Best regards, Alessandro -- --- 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

[orientdb] Re: help traversal and fetching child

2016-07-20 Thread alessandrorota04
I connected two new asset as you can see in the picture

[orientdb] Re: convert gremlin to java

2016-07-20 Thread alessandrorota04
With OSQL you can use this query SELECT dijkstra($a, $b,"","BOTH") LET $a = (select from V where name = "test"), $b = (select from V where name = "pavani") Hope it helps. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe

[orientdb] Re: help traversal and fetching child

2016-07-20 Thread alessandrorota04
Could you post a graph as example for this situation ? -- --- 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 orient-database+unsubscr...@googlegroups.com. For more

[orientdb] Re: help traversal and fetching child

2016-07-20 Thread alessandrorota04
Hi, I created this graph and I used this query select from asset where out("E").out("E").out("E").name contains "person 1" and out("E").in("E").in("E").name

[orientdb] Re: convert gremlin to java

2016-07-20 Thread alessandrorota04
What do you mean with how we can capture nodes while filtering ? -- --- 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 orient-database+unsubscr...@googlegroups.com.

[orientdb] Re: Need Unique value

2016-07-20 Thread alessandrorota04
Hi, I created this graph I used this

[orientdb] Re: convert gremlin to java

2016-07-20 Thread alessandrorota04
Hi, could you post you structure ? Best regards, Alessandro -- --- 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 orient-database+unsubscr...@googlegroups.com. For

[orientdb] Re: Need Unique value

2016-07-20 Thread alessandrorota04
Hi, could you explain better your structure and what you want ? Best regards, Alessandro -- --- 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

[orientdb] Re: Graph Traversal

2016-07-19 Thread alessandrorota04
You could use g.V.has('@class',T.in,['A','B','C','D','E','F']) Hope it helps. -- --- 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

[orientdb] Re: Graph Traversal

2016-07-19 Thread alessandrorota04
Hi, with g.V.has('@class','V') it get all vertices of class "V" while with has('name',T.in,['A','B','C','D']) it get all the previous vertices where the field "name" is one of A,B,C,D. The equivalent OSQL query is : select from v where name contains ["A","B","C","D"] -- --- You received

[orientdb] Re: Graph Traversal

2016-07-19 Thread alessandrorota04
I have replicated your structure. You could use this query g.V.has('@class','V').has('name',T.in,['A','B','C','D']) Kind regards, Alessandro -- --- You

[orientdb] Re: Graph Traversal

2016-07-19 Thread alessandrorota04
Hi, do you want all paths from A - D or the shortest path or other ? Best regards, Alessandro -- --- 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

[orientdb] Re: Find all in and out edges from a nodes using gremlin and java

2016-07-05 Thread alessandrorota04
Hi, you could try with this code GremlinPipeline sources =new GremlinPipeline().start((g. getVertices("name", "HEY BO DIDDLEY"))).bothE().outV().path(); List fls3 = sources.toList(); for(int i=0;i

[orientdb] Re: Gremlin and OrientDB

2016-06-21 Thread alessandrorota04
Hi Amrutha, when you create a class, that class has already a unique id field. Hope it helps -- --- You received this message because you are subscribed to the Google

[orientdb] Re: How to safely iterate through very large dataset with pagination?

2016-06-17 Thread alessandrorota04
Hi, you could see the roadmap . Kind regards, Alessandro -- --- 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

[orientdb] Re: RETURN @rid doesn't work as documented

2016-06-06 Thread alessandrorota04
Hi Eric, you can look this link . Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop

[orientdb] Re: RETURN @rid doesn't work as documented

2016-06-06 Thread alessandrorota04
Hi Eric, I hope that this javascript function could be helpful for you. var g=orient.getGraph(); var b=g.command("sql","INSERT INTO VMenu CONTENT {'Main':'PM', 'Timeout':'PT', 'Error':'PE'} RETURN @rid"); g.commit(); var query="update "+ b.getId().toString() + " set newProperty='NP'";

[orientdb] Re: RETURN @rid doesn't work as documented

2016-06-06 Thread alessandrorota04
Hi Eric, you should use this query INSERT INTO VMenu CONTENT {"Main":"PM", "Timeout":"PT", "Error":"PE"} RETURN @rid.asString() Kind regards, A -- --- You

[orientdb] Re: UPSERT PUT to a LINKMAP property

2016-06-01 Thread alessandrorota04
Hi Eric, according to the documentation http://orientdb.com/docs/2.2/SQL-Update.html you shoud use where condition after return. If the condition is not satisfied the update will not be executed so it will not return anything. Kind regards, Alessandro -- --- You received this message

[orientdb] Re: Not able to load data using OrientDB ETL

2016-05-25 Thread alessandrorota04
Hi, I have tried with your conf file with same version of client(2.1.10) and server and it works. Kind regards, Alessandro -- --- 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,

[orientdb] Re: Profile query inside Java ?

2016-05-17 Thread alessandrorota04
Hi, you can use this code OrientVertex result=g .command(new OCommandSQL("explain select from v")). execute(); for(String property:result.getPropertyKeys()){ System.out.println(property + "=" + result.getProperty(property)); } Best regards, Alessandro -- --- You received this message because

[orientdb] Re: Profile query inside Java ?

2016-05-12 Thread alessandrorota04
Hi, you can use Iterable result=g.command(new OSQLSynchQuery("select from V ")).execute(); for(Vertex v:result){ } Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving

[orientdb] Re: [Errno 111] Connection refused. while Connecting to orientdb using pyorient

2016-05-11 Thread alessandrorota04
Hi Learner, I launched it from terminal with this command sh mypath/bin/server.sh Best regards, Alessandro. -- --- 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

[orientdb] Re: [Errno 111] Connection refused. while Connecting to orientdb using pyorient

2016-05-11 Thread alessandrorota04
Hi Lerner, I launched the server and I tried this code import pyorient db_name='python_test' print("connection to the server...") client=pyorient.OrientDB("localhost",2424) client.set_session_token(True) session_id=client.connect("root","root") print("OK - sessionID: ",session_id,"\n")

[orientdb] Re: Embedded 2.1.16 - stuck on OServerMain.create()

2016-05-09 Thread alessandrorota04
Hi, it is correct, you must import com.orientechnologies.orient.server.OServer and com.orientechnologies.orient.server.OServerMain Best regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and

  1   2   3   4   >