Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

full text search $q #3

Open
timwis opened this issue Jan 13, 2017 · 0 comments
Open

full text search $q #3

timwis opened this issue Jan 13, 2017 · 0 comments
Labels
help wanted query-support
Projects
Reverse Proxy Implementation

Comments

@timwis
Copy link
Contributor

timwis commented Jan 13, 2017

Socrata supports full text search via $q=foo bar. Postgres and carto support it in the following format:

SELECT * FROM crimes_2015_to_oct_2016 WHERE (crimes_2015_to_oct_2016::text ILIKE '%foo%')

Interesting that this one requires the table name in the where clause.

Skipped test added.
@timwis timwis changed the title full text search full text search $q Jan 13, 2017
@zingbot zingbot moved this from Next to MVP in Reverse Proxy Implementation Feb 16, 2017
@zingbot zingbot moved this from MVP to Go-live in Reverse Proxy Implementation Feb 16, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
help wanted query-support
Projects
Reverse Proxy Implementation
Go-live
Milestone
No milestone
Development

No branches or pull requests
1 participant
@timwis