HELP to Query with json attributes

[Academia Learning Centro de inglés y de formación]

EDIT: Solved, thank

[Luigi Dell'Aquila]

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 <learning...@gmail.com>:

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

METADATA			PROPERTIES			IN
@rid	@version	@class	name	version	value	Has
#25:0	7	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 orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.