Query with fuzzy matching on a field

[rbkreisberg]

Can there be a way to search a field in a collection/table for a substring?

Use case:

Autocomplete widget
It is representing a column in a 600,000 row table
If the user types "chor" in the widget, then a query would be sent to Addama requesting all rows in the table that have a matching string in the requested field.

eg.
feature_matrix?name=[chor]&type=CLIN

This substring would need to be searched against the entire string, not just the beginning of the string.

[hrovira]

If you mean for the queries to Mongo through the PyMongo API, I believe the answer is yes through the use of regular expressions. However, it would probably make sense to use a search engine for this particular need. A quick search revealed solutions using jQuery and SOLR, so that may be a better option considering the size of our data, and the technologies we are already using.

[hrovira]

implemented search on a field

Some Examples

• http://csacr.systemsbiology.net/staging/genespot/svc/datastores/dev_ffn_20140520/STAD/feature_matrix/search/label?term=Asia
• http://csacr.systemsbiology.net/staging/genespot/svc/datastores/dev_ffn_20140520/STAD/feature_matrix/search/label?term=asia
• http://csacr.systemsbiology.net/staging/genespot/svc/datastores/dev_ffn_20140520/STAD/feature_matrix/search/tags?term=TNKS1BP1
• http://csacr.systemsbiology.net/staging/genespot/svc/datastores/dev_ffn_20140520/STAD/feature_matrix/search/tags?term=TNK*BP1