I just saw that my doubt is when there is more than one level for example:
select * from CompositeVersion where value.name = "Roberto"
{
"nombre": "Roberto",
"edad": 28
}
It´s ok but:
select * from CompositeVersion where value.name.en = "Roberto"
{
"nombre": {
"es": "Roberto",
"en": "Roberto"
},
"edad": 28
}
This no working
El miércoles, 16 de noviembre de 2016, 11:02:39 (UTC+1), Luigi Dell'Aquila
escribió:
>
> Hi
>
> That's the right syntax, it's supposed to work fine.
> Could you please post a simple script to create a db that reproduces the
> problem?
>
> Thanks
>
> Luigi
>
> 2016-11-16 10:58 GMT+01:00 Academia Learning Centro de inglés y de
> formación <[email protected] <javascript:>>:
>
>> Hi,
>>
>> I have this vertex of class CompositeVersion,
>>
>> How can I get all the vertices whose value has the property name equal to
>> Laboratory
>> report?
>>
>> I had tried with select from CompositeVersion where value.name.value =
>> 'Laboratory report' but not working
>>
>> select from CompositeVersion
>> METADATAPROPERTIESIN
>>
>> @rid
>> @version
>> @class
>> name
>> version
>> value
>> Has
>> #25:0
>> <http://localhost:2480/studio/index.html#/database/EHC_Vertices/browse/edit/25:0>
>> 7
>> CompositeVersion
>> <http://localhost:2480/studio/index.html#/database/EHC_Vertices/schema/editclass/CompositeVersion>
>> Composicion1-Version1
>> 1
>> {"@class":"COMPOSITION",
>> "
>>
>> *name":{"@class":"DV_TEXT","value":"Laboratory report"*},
>> "uid":{"@class":"OBJECT_VERSION_ID","value":
>> "4288d24d-e176-48ba-b85a-4b80523b07d2::demo::1"},"archetype_details":{
>> "@class":"ARCHETYPED","archetype_id":{"@class":"ARCHETYPE_ID","value":
>> "openEHR-EHR-COMPOSITION.report-mnd.v1"},"template_id":{"@class":
>> "TEMPLATE_ID","value":"Laboratory Report"},"rm_version":"1.0.1"},
>> "archetype_node_id":"openEHR-EHR-COMPOSITION.report-mnd.v1","language":]}
>>
>>
>> --
>>
>> ---
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
---
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.
