Add new note search file types (module, flash), optimize search query, and add translation entries for UI dropdown (resolves #920)
What does this MR do?
Adds two new options to the note search's "file type" filter: "Module" and "Flash". The former searches for module tracker files, and the latter for executable flash programs. Additionally, a GIN index is added to note.attachedFileTypes and the file type query is modified to use array operations. This allows for a fast intersection search between note.attachedFileTypes and a list of MIME types using only indexes. The SQL LIKE and Meilisearch implementations are de-duplicated to ensure consistent logic and results between the two modes. Finally, the file type search UI is now translatable.
Contribution Guidelines
By submitting this merge request, you agree to follow our Contribution Guidelines
-
I agree to follow this project's Contribution Guidelines -
I have made sure to test this merge request
Edited by Hazelnoot