HTML5 Data Bindings Support Product Page

Answered

Multi-word searches don't work unless query has an exact match

Asked 11 Sep 2014 23:02:44
1
has this question
11 Sep 2014 23:02:44 Steve Skinner posted:
I've built a new contact database for a customer using the HTML5 DB and related extensions. They love it. The only complaint they have is this inability to accurately search using more than one word. The HTML5 DB requires an exact match within each field it searches. It's not able to pull results where matches occur in the same field but not exactly as typed, or when a two word search has results with the words in different fields.

This is also one of those situations where it makes perfect sense to use a single search field to query 10 or more database fields at once.

To illustrate my point....
A search for IBM will show all people who have IBM in the company field, which is perfect. In this case, there are many people from IBM in this database and many have the same last name (smith). So, if you want to see all the people with a last name of "Smith" at IBM, getting those results with HTML5 DB is impossible unless you create multiple search fields that are isolated to specific db fields, and that's something I haven't seen done for 10+ years. That's archaic.

The old search that was just replaced (which I also programmed with DW using someone else's extension) allows you to type in "IBM Smith", and all people at IBM with the last name of smith are listed. I really need to be able to do this with HTML5 DB.

Is there a way to develop a more capable search tool that can do this using HTML5 DB?

Replies

Replied 12 Sep 2014 09:46:50
12 Sep 2014 09:46:50 Teodor Kuduschiev replied:
Hello Steve,
unfortunately fulltext search is not supported in HTML5 Data Bindings. Also there are no plans of implementing such feature in the near future.
Replied 12 Sep 2014 15:05:40
12 Sep 2014 15:05:40 Steve Skinner replied:
Noted.

If you are building a full text search then, what would you be using?

Reply to this topic