Query builder for Full Text Search #183

Closed
codeconsole opened this Issue Dec 7, 2012 · 4 comments

Comments

Projects
None yet
3 participants
@codeconsole
Contributor

codeconsole commented Dec 7, 2012

https://developers.google.com/appengine/docs/java/search/overview#Simple_Queries

search.execute {
    select author, subject, summary from User limit 100
}

from 'User' is search.index("User")
author, subject, summary are search.index("User").setFieldsToReturn("author", "subject", "summary")
limit is search.index("User").setLimit(limit)

// select the full document with all its properties
select all
// return just the ids of the documents matched by the query
select ids
// return one single entity if the query really returns one single result
select single
// return the count of entities matched by the query
select count
// return just a few properties 
select name, age

// from an index
from index

where EXPRESSION

// you can use "and" instead of "where" to add more where clauses

// ascending sorting
sort asc  by propertyName
// descending sorting
sort desc by propertyName

// limit to only 10 results
limit 10
// return the results starting from a certain offset
offset 100

// cursor handling
startAt cursorVariable
startAt cursorWebSafeStringRepresentation
endAt cursorVariable
endAt cursorWebSafeStringRepresentation
@glaforge

This comment has been minimized.

Show comment
Hide comment
@glaforge

glaforge Dec 7, 2012

Contributor

This would indeed be nice to support that syntax, in the same vein as the Gaelyk datastore queries syntax.
You're planning on implementing that?

Contributor

glaforge commented Dec 7, 2012

This would indeed be nice to support that syntax, in the same vein as the Gaelyk datastore queries syntax.
You're planning on implementing that?

@codeconsole

This comment has been minimized.

Show comment
Hide comment
@codeconsole

codeconsole Dec 9, 2012

Contributor

Still conceptualizing at this point... :)

Contributor

codeconsole commented Dec 9, 2012

Still conceptualizing at this point... :)

@musketyr

This comment has been minimized.

Show comment
Hide comment
@musketyr

musketyr Mar 14, 2013

Contributor

👍 the search API is so far so bad

Contributor

musketyr commented Mar 14, 2013

👍 the search API is so far so bad

@musketyr

This comment has been minimized.

Show comment
Hide comment
@musketyr

musketyr Mar 18, 2013

Contributor

we should also consider adding search expressions such as distance and geopoint

Contributor

musketyr commented Mar 18, 2013

we should also consider adding search expressions such as distance and geopoint

musketyr added a commit that referenced this issue Apr 28, 2013

musketyr added a commit that referenced this issue May 6, 2013

@musketyr musketyr closed this May 6, 2013

musketyr added a commit that referenced this issue May 6, 2013

musketyr added a commit that referenced this issue May 6, 2013

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment