mardi 5 mai 2015

orientdb search by traversing through fields

The problem is basically searching inside a multi-level embedded document. Let me explain,

I have three orientDB classes - Feedback, File, and FileContent.

Feedback ODocument has an embedded field reference to File ODocument, and File has an embedded reference to FileContent.

FileContent has a field 'content' that basically has text for the file where I want to search.

Use Case: Write a select query on Feedback class so that it gives me all Feedback ODocuments that have the search keyword.
That is,
If I want to search for the keyword 'progress' in the file content, and fetch all feedbacks that have this keyword, the sql would look like:

select * from Feedback where any() like '%progress%'

But this query doesn't search through file content.
Any help is appreciated.

Aucun commentaire:

Enregistrer un commentaire