So sorry for my mistake, have you try this one? I'am not sure if you want this.
select title from books where in().s IN ['elephant','fence'] this will print out all books vertex records which have a relationship with word vertex that got properties s='elephant' and s='fence' I haven't try this yet but the result should be what your want I hope. XD เมื่อ วันพุธที่ 26 สิงหาคม ค.ศ. 2015 15 นาฬิกา 28 นาที 31 วินาที UTC+7, MV-dev1 เขียนว่า: > > Thank you, that does help. That's a pretty advanced query! > > Everything is starting to look like regular expressions! > > I also found this article and discussion about PIVOT classes and switching > the pivot within a query helpful but I don't think I get it 100% yet... > > https://orientdb.com/docs/last/Pivoting-With-Query.html > > I'm still learning to better articulate my query because I see that I > wasn't clear in my example. > > Here goes another try.... > > #1. I have a vertex for each Book > #2. I have a vertex for each Word that might appear in a book > #3. I have a single edge (word_book) from word to book when a word appears > somewhere in the book > > > * at least once>> I want to find all the books that contain the word > 'elephant' and 'fence' in them.* > -- --- 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.
