Full-text prefix search with PostgreSQL
On the demo.nuxeo.com Advanced Search page, a query with Title = 'Work*' returns no results. A query with Title = 'Workspaces' returns two folders with that precise title. Is it the expected behavior for the query with Title = 'Work*' to return no results?
Also, when I search for Workspace Retail using 'Reta*' or Workspace Finance using 'Fin%' or Folder Headquarters/Test using 'Te*', no results are returned. Is this expected?
Finally, I created a Folder on demo.nuxeo.com named 'Workspaces' within the 'Retail' Workspace. A query with Title = 'Work*' again returned no results. Thoughts?
Generally speaking a search for 'Work*' should return documents with words that begin with Work, however, it looks as though the WorkspaceRoot document Workspaces itself is excluded from the search. If you create a Workspaces workspace or folder (under the WorkspaceRoot) then searching for 'Work*' returns the expected results.
The answer to your revised questions is Yes, that is expected behavior. Have you tried 'Fin%'?
Above works for simple search but not (as rg1 pointed out in advanced/faceted search) due to issue NXP-10995.
 |
bruce Grant
Member (7.6K) 2 7 6 |
07/26/2013 ( History) |