I'm wondering if someone has already found an appropriate approach for dealing with search/score for names like these below with CMIS, such that a search phrase "jon doe" or "john doe" returns all three phrases (i.e. all documents that have cmis:name of any of these 3):
- Jon Doe
John P. Doe
Using a query with the CONTAINS() is not working out as expected, although if I only search for the first name 'john', I'll get two, but all other scenarios I'll only get 1 of the 3 in this example. (wrapping phrase in quotes allowed spaces for those reviewing this thread for usage of CONTAINS).
ItemIterable<QueryResult> results = session.query("SELECT * FROM cmis:document WHERE CONTAINS ( 'cmis:name: \"" + fullname + " \"')", false);
(* for brevity, would include SCORE() and other specific fields if possible)
standard CMIS would be preferred, but if not, that's fine too just trying to figure out appropriate approach.