Perfect,
with few case correction it runs
SELECT EXPAND( out('hasProperty') ) FROM Module WHERE code = '001' order
by order ASC
I'm new with orientDB, and i'm doing some tests in order to understand if
it's the right db for my needs
Thanks a lot
Il giorno giovedì 28 maggio 2015 11:43:12 UTC+2, Giulia Brignoli ha scritto:
>
> try this:
>
> SELECT EXPAND( out('HasProperty') ) FROM module WHERE Code = '001' order
> by order ASC
>
> bye, Giulia
>
>
> Il giorno giovedì 28 maggio 2015 11:07:21 UTC+2, Giovanni Adobati ha
> scritto:
>>
>> Hy,
>>
>> I have a query like this:
>>
>> SELECT EXPAND( out('hasProperty') ) FROM Module WHERE code = '001' order
>> by ModuleProperty.order ASC
>>
>> The results are not ordered by my specific field ModuleProperty.order
>> Is this query correct ?
>>
>> This is there result
>> {
>> "result": [
>> {
>> "@type": "d",
>> "@rid": "#15:0",
>> "@version": 5,
>> "@class": "ModuleProperty",
>> "name": "Nome",
>> "type": "string",
>> "in_hasProperty": [
>> "#14:0"
>> ],
>> "order": "1",
>> "@fieldTypes": "in_hasProperty=g"
>> },
>> {
>> "@type": "d",
>> "@rid": "#15:1",
>> "@version": 4,
>> "@class": "ModuleProperty",
>> "name": "Descrizione",
>> "type": "string",
>> "in_hasProperty": [
>> "#14:1"
>> ],
>> "order": "3",
>> "@fieldTypes": "in_hasProperty=g"
>> },
>> {
>> "@type": "d",
>> "@rid": "#15:2",
>> "@version": 3,
>> "@class": "ModuleProperty",
>> "name": "Cognome",
>> "type": "string",
>> "in_hasProperty": [
>> "#14:2"
>> ],
>> "order": "2",
>> "@fieldTypes": "in_hasProperty=g"
>> },
>> {
>> "@type": "d",
>> "@rid": "#15:3",
>> "@version": 4,
>> "@class": "ModuleProperty",
>> "name": "Attività",
>> "type": "string",
>> "in_hasProperty": [
>> "#14:3"
>> ],
>> "order": 0,
>> "@fieldTypes": "in_hasProperty=g"
>> }
>> ],
>> "notification": "Query executed in 0.05 sec. Returned 4 record(s)"
>> }
>>
>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
