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
Above works for simple search but not (as rg1 pointed out in advanced/faceted search) due to issue NXP-10995.