vanstyn / RapidApp

Turnkey ajaxy webapps
http://rapi.io
Other
48 stars 15 forks source link

Add 'quick_search_exact_only' column opt as default for numeric columns #52

Closed vanstyn closed 10 years ago

vanstyn commented 10 years ago

Databases like PostgreSQL do not like WHERE clauses using 'LIKE' on numeric columns, which is the default mode used by grid Quick Search for all columns. Since it doesn't make sense to search sub-strings of numbers anyway, there should be an option to force "Exact" mode on a per-column basis (i.e. '=' instead of 'LIKE') and make this the default for all numeric columns. We will call this new TableSpec column option quick_search_exact_only