Even more infraction search improvements about bot HOT 6 CLOSED

Comment from Johannes Christ:

Should probably be postponed until infractions use the Django website's API

from bot.

@jchristgit You worked on updating the bot side of things to work with the new API, right? IIRC the API itself does support querying for more fields now. Have these new capabilities been transferred to the bot commands too?

from bot.

As far as I know, the implementation in the moderation cog hasn't changed: a moderator can search for infractions based on the user or the reason (with regex support). @scragly is planning on rewriting the moderation cog, which is probably a good time to look into improving the search capabilities as well.

from bot.

There's two ways to approach this (or a mix of both I suppose):

1. A generic search command which will support partial matches on user and actor names along with the reason. It will also support exact matches for IDs. This is easier to implement and easier to use (just a single command covers everything) but at the cost of less control over the search query. For example, if one wishes to search for an actor by name, if their name appeared in an unrelated infraction's reason, that would also show up in the search result. On the site, the implementation would utilise the SearchFilter and search_fields. The date range would still need to be a separate command.
2. Specific commands for each field. User IDs and names could likely be grouped into one command, and the field to search inferred by whether search query represents a valid user ID.

from bot.

We do not support searching by agent yet, adding that as a sub command would be nice.
You can get stats about the infractions through grafana and have fancy graph, I don’t think a command for that is much needed.

from bot.

All parts for this are done save for the statistics command, and like mentioned we have grafana for this. If a need arises for seeing the actual infractions in the timespan via a command we can open a separate issue.

from bot.