Knowledge is a wonderful tool for gathering, organizing and sharing documentation with colleagues. With this module, people can easily create rich documents that help them in their day-to-day jobs.

Currently, Knowledge lacks an effective search feature. The existing search functionality only searches documents based on their titles and cannot search within the document content.

This PR will implement a new search feature for Knowledge that will enable people to quickly find the information they need within a large collection of documents. This new feature will save a significant amount of time for users who are unsure which specific document contains the information they need.

The search feature will work like a small search engine: People will have to type a few words or a sentence and the system will retrieve the documents that match the most with those keywords.

To implement that search feature, we will use the build-in "Full Text Search" feature of PostgreSQL. By leveraging this feature, the database will do all the heavy lifting for us: It will be able to automatically encode the documents in a vector space, apply stemming on the words, include statistical measures to evaluate the similarity between a document and a query, strip the html tags, highlight the piece of text containing the search terms, etc.

Reference: https://www.postgresql.org/docs/15/textsearch.html

task-3071299