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