Re: [orientdb] Re: Fetch plan: Return expanded resultset

2015-11-01 Thread Thomas Kennedy
xport-a-document-and-its-nested-documents-in-json > > > Best Regards, > > Luca Garulli > Founder & CEO > OrientDB <http://orientdb.com/> > > > On 31 October 2015 at 13:47, Thomas Kennedy <tomais....@gmail.com > > wrote: > >> Any help would be

[orientdb] Re: Fetch plan: Return expanded resultset

2015-10-31 Thread Thomas Kennedy
Any help would be much appreciated. On Wednesday, 28 October 2015 10:16:12 UTC, Thomas Kennedy wrote: > > I have a simple query > > select * from Questions fetchplan last_comment:0 order by createdAt desc > > I am looking for the resultset to return the last_comm

[orientdb] Fetch plan: Return expanded resultset

2015-10-28 Thread Thomas Kennedy
I have a simple query select * from Questions fetchplan last_comment:0 order by createdAt desc I am looking for the resultset to return the last_comment expanded along with the result of the questions class. I am using a Orientjs to interface with orient. It doesnt return the expanded

[orientdb] Querying Last Record LinkedList

2015-06-22 Thread Thomas Kennedy
I have a class User below and I'm storing profile pictures as a linkedlist to another class called ProfilePicture. I want to return all the columns in User and the last entry in the profile_picture. Any ideas how this query would look? [ { '@type': 'd', '@class': 'User',

[orientdb] Re: Querying Last Record LinkedList

2015-06-22 Thread Thomas Kennedy
I solved it like this Select email, last(profile_picture.filename) from User where username = 'tom' Is this the most efficient way though? On Monday, 22 June 2015 22:36:02 UTC+1, Thomas Kennedy wrote: I have a class User below and I'm storing profile pictures as a linkedlist to another

[orientdb] Time Series Last Node Link

2015-06-02 Thread Thomas Kennedy
I have a time series modelled in the graph way year(linkmap)-month(linkmap)-day(linkmap)-hour(linkmap) I have two other vertices which are events and users I want to join events to the time series. Is this best achieved by using an edge or a linkset?

[orientdb] Edge Query Issue

2015-06-02 Thread Thomas Kennedy
I have a time series model where I create an edge between a hour vertex and an event vertex. The edge is called registered_event. I have tried the following query but it is not giving me results. Any ideas? select expand(month[12].day[3].hour[23]).out('registered_event') from Year where year =

[orientdb] Re: Edge Query Issue

2015-06-02 Thread Thomas Kennedy
://localhost:2480/studio/index.html#/database/test/browse/edit/27:4 #27:5 http://localhost:2480/studio/index.html#/database/test/browse/edit/27:5 On Tuesday, 2 June 2015 23:39:55 UTC+1, Thomas Kennedy wrote: I have a time series model where I create an edge between a hour vertex and an event vertex

[orientdb] Activity Feed

2015-03-28 Thread Thomas Kennedy
Hi, Has anybody implemented an activity feed in Orient? Something like Linkedin or Twitter. I am looking for examples on how to do this? Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving

[orientdb] Extends OTriggered - Problem retrieving edge

2015-03-14 Thread Thomas Kennedy
I am having setting up a hook on a class. After altering the class to be OTriggered I am not able to retrieve any connected edges to that class. Does anybody know why this might be? Class A - Vertex Class B - OTriggered Class connected - Edge A-Connected-B If I convert B back to be a vertex

[orientdb] Functions Javascript Copy Object Value

2014-06-26 Thread Thomas Kennedy
Hi, I am using the graph API in Javascript and was wondering how to split a string, var dStr = r[key].getRecord().field(@Rid); dStr.slice(1,3) It gives an error Cannot find function slice in object #17:6 Any tips on how to best copy the value out of the orient object so I can edit?

[orientdb] Re: Functions Javascript Copy Object Value

2014-06-26 Thread Thomas Kennedy
Solved by creating a string Object. new String(OrientOBj); On Thursday, 26 June 2014 21:48:12 UTC+1, Thomas Kennedy wrote: Hi, I am using the graph API in Javascript and was wondering how to split a string, var dStr = r[key].getRecord().field(@Rid); dStr.slice(1,3) It gives

Re: [orientdb] Nodes and Edges

2014-06-10 Thread Thomas Kennedy
| #12:0 | | #11:1 | #11:0 Connects | #12:1 | | #11:2 | #11:1 Connects | #12:2 | | #11:3 | #11:2 On Monday, 9 June 2014 21:45:43 UTC+1, Lvc@ wrote: Hi Thomas, May you post here, given that domain, what's te result you want in terms of output? Lvc@ On 9 June 2014 20:20, Thomas Kennedy

Re: [orientdb] Nodes and Edges

2014-06-09 Thread Thomas Kennedy
start? If you don't have a root vertex, you could do: select *, outE() from A Or even: select *, inV() from Connects Lvc@ On 8 June 2014 18:20, Thomas Kennedy tomais@gmail.com javascript: wrote: Hi, I have a node A and these are connected by an edge called connects. I want

Re: [orientdb] Nodes and Edges

2014-06-09 Thread Thomas Kennedy
Can anybody help here? On Monday, 9 June 2014 08:17:20 UTC+1, Thomas Kennedy wrote: The Root Node is #11:0 But I need both Class's V and E returned. And I only need the edge connect. select outE('connects') from A It also sees to only go one level. I need all the connected edges

[orientdb] Nodes and Edges

2014-06-08 Thread Thomas Kennedy
Hi, I have a node A and these are connected by an edge called connects. I want to return Both Vertex and Edge in the Query? Any help would be grateful? A RID Name - #11:0 | Link1 #11:1 | Link2 #11:2 | Link3 #11:3 | Link4 Connects RIDOut In --

Re: [orientdb] Re: Javascript JSON Marshalling

2014-05-21 Thread Thomas Kennedy
Kennedy tomais@gmail.com javascript:wrote: JSON.parse fixed this. On Tuesday, 20 May 2014 23:40:36 UTC+1, Thomas Kennedy wrote: I have a server side with javascript function one parameter called Data. The value of Data is {test:5}. This is passed in as a string. in the javascript

[orientdb] Data Modelling Question (Linkmap, Edge, Embeddedmap....)

2014-05-21 Thread Thomas Kennedy
I have a question about how to store some instances of meta data in a class. I have a class called Foo which stores instances of data. I have another class called properties that stores meta data of fields that can be stored in Foo.Properties. class Foo Name | String Properties | ? class

[orientdb] Re: Data Modelling Question (Linkmap, Edge, Embeddedmap....)

2014-05-21 Thread Thomas Kennedy
? Any thoughts? On Wednesday, 21 May 2014 19:52:48 UTC+1, Thomas Kennedy wrote: I have a question about how to store some instances of meta data in a class. I have a class called Foo which stores instances of data. I have another class called properties that stores meta data of fields

[orientdb] Re: Javascript JSON Marshalling

2014-05-20 Thread Thomas Kennedy
JSON.parse fixed this. On Tuesday, 20 May 2014 23:40:36 UTC+1, Thomas Kennedy wrote: I have a server side with javascript function one parameter called Data. The value of Data is {test:5}. This is passed in as a string. in the javascript function I want to access the value of test

Re: [orientdb] SQL Batch HTTP API

2014-05-11 Thread Thomas Kennedy
OrientDB console v.1.7-rc2 (build UNKNOWN@r${buildNumber}; 2014-03-25 15:54:54 On Sun, May 11, 2014 at 8:20 AM, Thomas Kennedy tomais.kenn...@gmail.comwrote: Hi, I am executing the following using HTTP interface { transaction: true, operations: [ { type

[orientdb] Re: SQL Batch HTTP API

2014-05-11 Thread Thomas Kennedy
OrientDB console v.1.7-rc2 (build UNKNOWN@r${buildNumber}; 2014-03-25 15:54:54 On Sunday, 11 May 2014 08:20:56 UTC+1, Thomas Kennedy wrote: Hi, I am executing the following using HTTP interface { transaction: true, operations: [ { type: script

[orientdb] Re: SQL Batch HTTP API

2014-05-11 Thread Thomas Kennedy
/orientechnologies/orientdb-community/1.7-SNAPSHOT/ Erik On Sunday, May 11, 2014 1:22:31 AM UTC-6, Thomas Kennedy wrote: OrientDB console v.1.7-rc2 (build UNKNOWN@r${buildNumber}; 2014-03-25 15:54:54 On Sunday, 11 May 2014 08:20:56 UTC+1, Thomas Kennedy wrote: Hi, I am executing

[orientdb] Re: OrientDB official Node.js driver

2014-05-08 Thread Thomas Kennedy
This is really great Luca. Hopefully the community can be active to post examples and provide code snippets to help others. On Wednesday, 7 May 2014 23:56:42 UTC+1, Lvc@ wrote: Hi, We decided to adopt the Oriento driver as the official *Node.js* driver for OrientDB. Now you can find it

[orientdb] Php Rest - Batch

2014-04-22 Thread Thomas Kennedy
Hi, I am trying to use the batch interface to insert records. I have attached a simple one record insert. It is giving me an error string(78) java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Map Any suggestions? Regards, Tom ?php $url =

[orientdb] Re: Php Rest - Batch

2014-04-22 Thread Thomas Kennedy
There URL was incorrect. Issue: fixed On Tuesday, 22 April 2014 21:21:58 UTC+1, Thomas Kennedy wrote: Hi, I am trying to use the batch interface to insert records. I have attached a simple one record insert. It is giving me an error string(78) java.lang.ClassCastException

[orientdb] Re: Php Rest - Batch

2014-04-22 Thread Thomas Kennedy
Correction the POSTFIELDS parameter was incorrect. On Tuesday, 22 April 2014 21:55:48 UTC+1, Thomas Kennedy wrote: There URL was incorrect. Issue: fixed On Tuesday, 22 April 2014 21:21:58 UTC+1, Thomas Kennedy wrote: Hi, I am trying to use the batch interface to insert records. I have

[orientdb] Re: console - embedded maps

2014-04-07 Thread Thomas Kennedy
I expect to see {Name:List} On Monday, 7 April 2014 18:13:09 UTC+1, Thomas Kennedy wrote: Hi, I trying t use the console to insert some value into an embedded map type. I input {Name:List} into the textbox and save and get {Name:{List:null}} instead. Can anybody help me with what im

[orientdb] Re: Does OrientDB has collections?

2014-03-25 Thread Thomas Kennedy
Kevin, Orient has Classes which can be either a vertex or an edge if you want to use graph approach or you can just create a class which is the same a document collection. These classes are like documents in Mongo and can be schemaless. The studio is great to quickly create your data models.

[orientdb] Re: New node.js driver - Oriento

2014-03-20 Thread Thomas Kennedy
Excellent. I use node in my project. Will be sure to give it a try. On Thursday, 20 March 2014 01:49:52 UTC, Charles Pick wrote: Hi, I'd like to announce a new binary protocol client for nodejs - Orientohttps://github.com/codemix/oriento While it is descended from the great work Giraldo

[orientdb] PHP Driver

2014-03-12 Thread Thomas Kennedy
Hi, Is the orient PHP driver still under active development? https://github.com/AntonTerekhov/OrientDB-PHP Im trying to use it with 1.7rc1. Regards, Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop

[orientdb] Re: PHP Driver

2014-03-12 Thread Thomas Kennedy
Also if anybody knows if graphs are supported. On Wednesday, 12 March 2014 19:02:39 UTC, Thomas Kennedy wrote: Hi, Is the orient PHP driver still under active development? https://github.com/AntonTerekhov/OrientDB-PHP Im trying to use it with 1.7rc1. Regards, Tom -- --- You

[orientdb] Re: Retrieving JSON Tree From Graph

2014-03-09 Thread Thomas Kennedy
Are there any other ways than bringing back the relationships from my edge relationship and building it in Php or Node? Suggestions welcome.. Im just looking for tips on the most efficient way with OrientDB On Friday, 7 March 2014 00:35:09 UTC, Thomas Kennedy wrote: Hi, I have a tree

[orientdb] Retrieving JSON Tree From Graph

2014-03-06 Thread Thomas Kennedy
Hi, I have a tree structure in orient that I want to transform into the JSON format like below. I am using D3.js and would like the data returned in the correct format. Does anybody the correct way to do this in Orient? TIA Tom Orient Tree node1 node2 node3 node4 ... .. JSON

[orientdb] Re: Timeseries use case and insert command.

2014-03-02 Thread Thomas Kennedy
Hi Nikolas, Did you manage to get an example? Regards, Tom On Friday, 21 February 2014 16:46:40 UTC, Nikolas wrote: Hello, I'm totally newbie to OrientDB and i'm playing with the time series use case. I'don't understand how to populate a LINKMAP field with SQL to create years[2014],

[orientdb] Re: Timeseries use case and insert command.

2014-03-02 Thread Thomas Kennedy
It would be great if anybody who had an example could post one here. On Sunday, 2 March 2014 21:25:30 UTC, Thomas Kennedy wrote: Hi Nikolas, Did you manage to get an example? Regards, Tom On Friday, 21 February 2014 16:46:40 UTC, Nikolas wrote: Hello, I'm totally newbie to OrientDB

[orientdb] Server Side Function

2014-02-19 Thread Thomas Kennedy
Hi, I am using the 1.7-rc1 version and have attempted to access an element on JSON object that is returned and receive a blank value. I execute the code on the studio thru the function section. var test = db.query(select from OUser); var thename = test[0][name]; //also tried this //var

Re: [orientdb] Server Side Function

2014-02-19 Thread Thomas Kennedy
, Luigi Dell'Aquila wrote: Hi Thomas, test[0] is actually an ODocument (a Java object). Just try this: test[0].field(name) Luigi 2014-02-19 3:23 GMT+01:00 Thomas Kennedy tomais@gmail.comjavascript: : Hi, I am using the 1.7-rc1 version and have attempted to access an element

Re: [orientdb] Server Side Function

2014-02-19 Thread Thomas Kennedy
, but inside the function you are using native OrientDB API: the db object an instance of the Java class OScriptDocumentDatabaseWrapper, that is a wrapper of ODatabaseDocumentTx, so when you work with it you will get Java objects. Luigi 2014-02-19 9:32 GMT+01:00 Thomas Kennedy tomais