Sort Alert Groups

[jakubvojacek]

Hello

would it be please possible to add the ability to sort the alerts by

• created date
• updated date

As of now, the created date is shown on the grid but its not sortable. But sometimes the updated date is much more interesting to see & sort by (when one alert has multiple subalerts grouped together). Right now when an alert was received yesterday and again today, I wont see it at the top of the list but on yesterdays date.

Thanks Jakub

[Matvey-Kuk]

Not sure if it will be easy to add "Updated" column, but we def need to add sorting for "Created"

[jakubvojacek]

not sure how its handled internally but just add a datetime column into the alert table and everytime you add a new groupped alert update the datetime column? It sure would be interesting for us to see which of the silence issues could be unsilenced based on the last updated time

[vadimkerr]

This will probably require adding/modifying existing indices on the alert group table, which should be handled very carefully, since the alert group table can be huge on some instances. When I last checked this, I found out that just adding an order_by on started_at causes huge latency increase for instances with lots of alerts groups, so some in-depth investigation is needed for this issue.

[Matvey-Kuk]

@vadimkerr @Ferril @teodosii I propose to postpone this one because of the problem @vadimkerr mentioned above.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had activity in the last 120 days.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had activity in the last 120 days.