select * from Issue fetchPlan:-1
On Monday, June 1, 2015 at 12:10:14 PM UTC+5:30, SavioL wrote:
>
> 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.
