GhostManager / Ghostwriter

The SpecterOps project management and reporting engine
https://ghostwriter.wiki
BSD 3-Clause "New" or "Revised" License
1.23k stars 174 forks source link

Oplog Entry full-text searching #422

Closed ColonelThirtyTwo closed 2 months ago

ColonelThirtyTwo commented 2 months ago

Use Django's and PostgreSQL's full text search (FTS) functionality for better searching.

Currently the Oplog Entry search just filters for substrings on the clientside, which is pretty limiting, especially with large logs. These patches add a full-text-search index to the oplog entries, adds support to the websocket protocol to specify a full-text-search filter, and adjusts the frontend to pass the filter up and reload the query when entries are added, edited, or deleted.