Hi Sean,
perhaps this is the query you were looking for:
- insert with json parameters
INSERT INTO PersonJson (my_prop) values ({"name": "James", "age": 23})
- get parameters in json format
SELECT my_prop FROM PersonJson --> Result: {"age":23,"name":"James"}
Bye,
Luigi S.
Il giorno sabato 30 maggio 2015 17:54:49 UTC+2, Sean ha scritto:
>
> I'm just not getting this. I can do simple querys as long as everythings
> in the same document or vertex, the second I have an edge or a #R:ID
> instead of an actual value..I'm flat on my face. For example;
>
> I've set up a very simple two class, one entry each Document Database(I've
> got a second identical graph database set up with Vertices and Edges
> instead)
>
> First Class is Issue with one Record(using my old comic book collection as
> data) so, and I'm using the Web Studio to see the Raw JSON data returned
>
> Select * from Issue
>
> results in..
>
> }
>
> "@type": "d",
> "@rid": "#10:0",
> "@version": 8,
> "@class": "Issue",
> "issue_number": 1,
> "issue_name": "Man of Steel",
> "publisher": "#11:0"
> }
>
>
> and the same for publishers..
>
> {
> "@type": "d",
> "@rid": "#11:0",
> "@version": 5,
> "@class": "publisher",
> "name": "DC Comics"
> }
>
>
>
> So what I'm trying to do is get the "Select from * issue" JSON to display
> something like this...
>
> }
>
> "@type": "d",
> "@rid": "#10:0",
> "@version": 8,
> "@class": "Issue",
> "issue_number": 1,
> "issue_name": "Man of Steel",
> "publisher": "#11:0"
> "name": "DC Comics"
> }
>
>
> Which is what I need to start playing around with the web site side or
> things, getting JSON queries and displaying them.
>
> Which seems like it should be the EASIEST THING IN THE WORLD TO DO. But
> I've spend hours trying to suss this out, numerous reads of the
> documentation, google searches up the wazoo..nothing. I'm 99% certain the
> records ARE joined, because in Studio when I do the "select * from issue*
> query, the result shows the #11:0 RID and I can click it to open the
> property's of #11:0. However I just cannot figure out how to query through
> it by SQL and get the contained information.
>
>
>
--
---
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.
