topic Re: Full-text prefix search with PostgreSQL in Nuxeo Forum

Full-text prefix search with PostgreSQL

rg1_ — Fri, 26 Jul 2013 16:46:35 GMT

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?

Re: Full-text prefix search with PostgreSQL

bruce_Grant — Fri, 26 Jul 2013 22:24:15 GMT

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.

Re: Full-text prefix search with PostgreSQL

rg1_ — Fri, 26 Jul 2013 23:46:32 GMT

See updated question.

Re: Full-text prefix search with PostgreSQL

bruce_Grant — Fri, 26 Jul 2013 23:59:15 GMT

I assume by by revised question above that the names of the Workspaces are Retail and Finance. Is that correct?

Re: Full-text prefix search with PostgreSQL

rg1_ — Sat, 27 Jul 2013 12:57:59 GMT

Please try logging in to demo.nuxeo.com as Administrator and try the Advanced Search. Word-based searches work but prefix-based wildcard searches do not, regardless of whether I use an asterisk or a percent as the wildcard. This does not seem correct to me.

Re: Full-text prefix search with PostgreSQL

bruce_Grant — Tue, 30 Jul 2013 23:35:43 GMT

You're correct. When I was testing I was using one of my own 5.6 instance and simple search works for workspaces, folders, etc..

Re: Full-text prefix search with PostgreSQL

rg1_ — Tue, 06 Aug 2013 16:07:48 GMT

See http