Like Gal said, you would need to make your own full-text search. You
don't need an OR query if all values are in a single multi-valued
property. You could do this by creating an index entity:
CandidatesSearch
{
@Parent Candidate source;
List<String> words;
}
It is a child of the Candidate so you can store and update both in a
transaction
Add every word in name, skills etc then just do
datastore.store(candidateSearch);
datastore.find()
.type(CandidatesSearch.class)
.filter("words", EQUAL, searchcontents)
.fetchNoFields()
.returnParentsNow();
This is ObjectDatastore query syntax from Twig but the same concept
would work in JDO, Objectify, SimpleDS etc
John
On 1 Apr 2010, at 22:27, Gal Dolber wrote:
There is no easy way to do that.
Problems:
Appengine do not support fulltext queries
Appengine do not support OR
Solutions:
Make your own fulltext search implementation
Use IN operand
2010/4/1 Manjoor <[email protected]>
I have a simple java class with following attributes
Candidates.java
name
skills
education
currentEmployer
I need app-engine java equevalent code of the following SQL query
Select * from Candidates
where (name like '%searchcontent%') OR
(skills like '%searchcontent%') OR
(education like '%searchcontent%') OR
(currentEmployer like '%searchcontent%')
--
You received this message because you are subscribed to the Google
Groups "Google App Engine for Java" group.
To post to this group, send email to [email protected]
.
To unsubscribe from this group, send email to [email protected]
.
For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en
.
--
You received this message because you are subscribed to the Google
Groups "Google App Engine for Java" group.
To post to this group, send email to [email protected]
.
To unsubscribe from this group, send email to [email protected]
.
For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en
.
--
You received this message because you are subscribed to the Google Groups "Google
App Engine for Java" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
