[orientdb] Re: [HELP] find document inside list
This does not work, I need to find a field inside a json value, which inside has more nested fields and values, but I do not know the path El viernes, 2 de diciembre de 2016, 11:51:36 (UTC+1), user.w...@gmail.com escribió: > > Hi, > > try this: > > select from EHR where compositionsList.class contains "composition" > > Hope it helps > > Regards, > Michela > -- --- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: [HELP] find document inside list
yes are list embedded
El jueves, 1 de diciembre de 2016, 15:03:58 (UTC+1), Oleksandr Gubchenko
escribió:
>
> What is a type of compositionList? Is it an embedded list?
>
> Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning Centro
> de inglés y de formación ha scritto:
>>
>> Hi, I want to look for a document within a list, but I can not find the
>> way, I'm trying this but it gives me error
>>
>> *select from object where compositionsList traverse ( class =
>> 'composition' ),*
>>
>> but this not working
>>
>> *select from EHR where compositionsList['class'] like 'comp%'*
>>
>> { "object" :{
>>
>> "compositionList" : [
>>{"class" : "composition"},
>>{"class" : "example"}
>>
>> ]
>> }
>>
>
--
---
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: [HELP] find document inside list
not working
El jueves, 1 de diciembre de 2016, 15:06:34 (UTC+1), Oleksandr Gubchenko
escribió:
>
> Try this one:
>
> select from EHR where 'composition' in compositionList.class
>
> Il giorno giovedì 1 dicembre 2016 15:03:58 UTC+1, Oleksandr Gubchenko ha
> scritto:
>>
>> What is a type of compositionList? Is it an embedded list?
>>
>> Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning
>> Centro de inglés y de formación ha scritto:
>>>
>>> Hi, I want to look for a document within a list, but I can not find the
>>> way, I'm trying this but it gives me error
>>>
>>> *select from object where compositionsList traverse ( class =
>>> 'composition' ),*
>>>
>>> but this not working
>>>
>>> *select from EHR where compositionsList['class'] like 'comp%'*
>>>
>>> { "object" :{
>>>
>>> "compositionList" : [
>>>{"class" : "composition"},
>>>{"class" : "example"}
>>>
>>> ]
>>> }
>>>
>>
--
---
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: [HELP] find document inside list
Try this one:
select from EHR where 'composition' in compositionList.class
Il giorno giovedì 1 dicembre 2016 15:03:58 UTC+1, Oleksandr Gubchenko ha
scritto:
>
> What is a type of compositionList? Is it an embedded list?
>
> Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning Centro
> de inglés y de formación ha scritto:
>>
>> Hi, I want to look for a document within a list, but I can not find the
>> way, I'm trying this but it gives me error
>>
>> *select from object where compositionsList traverse ( class =
>> 'composition' ),*
>>
>> but this not working
>>
>> *select from EHR where compositionsList['class'] like 'comp%'*
>>
>> { "object" :{
>>
>> "compositionList" : [
>>{"class" : "composition"},
>>{"class" : "example"}
>>
>> ]
>> }
>>
>
--
---
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: [HELP] find document inside list
What is a type of compositionList? Is it an embedded list?
Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning Centro
de inglés y de formación ha scritto:
>
> Hi, I want to look for a document within a list, but I can not find the
> way, I'm trying this but it gives me error
>
> *select from object where compositionsList traverse ( class =
> 'composition' ),*
>
> but this not working
>
> *select from EHR where compositionsList['class'] like 'comp%'*
>
> { "object" :{
>
> "compositionList" : [
>{"class" : "composition"},
>{"class" : "example"}
>
> ]
> }
>
--
---
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
