Skip to content

Draft: Expand Issue's pg_full_text_search to include captured text from Notes

Joe Snyder requested to merge gitlab-community/gitlab:add_comments_issue_search_data into master

What does this MR do and why?

This merge request will extend the pg_full_text_searchable capability for the Issue model to take advantage of a new notes_content attribute. This attribute will gather the Note.note text where the noteable_id is equal to the ID of the issue. It will then absorb all text into the search_vector

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests. Searching for the text "yeti" in my GDK instance returns an issue:

image

where the text is found in a reply to a comment: image

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Edited by Joe Snyder

Merge request reports