Bug #7672
closedSearching for report-related events does not work properly
0%
Description
"Search for all events related to report" button does not work properly. When you click on this button in this report, no event is shown. This does not seem to be related to #7671, as it also does not work on Hub.
Updated by Jakub Judiny 12 months ago
- Status changed from In Progress to Resolved
Updated by Rajmund Hruška 12 months ago
- Status changed from Resolved to Feedback
I think that 'st_from' and 'st_to' is not the only issue. I looked at the SQL query it produces:
SELECT * FROM events AS "_mentatq(155_prbzns)_" WHERE "detecttime" >= '2023-08-09T14:00:00'::timestamp AND "detecttime" <= '2023-08-16T14:00:00'::timestamp AND "storagetime" >= '2023-08-09T00:10:00'::timestamp AND "storagetime" <= '2023-08-09T02:10:00'::timestamp AND NOT ("category" && ARRAY['Test']) AND "eventseverity" = ANY(ARRAY['medium']) AND "resolvedabuses" && ARRAY['abuse@cesnet.cz','__GRID__'] ORDER BY "storagetime" DESC LIMIT 100
The query is also taking the detecttime into account and since this is not provided at URL, the default time window is used (which is one week ago from current time).
Updated by Jakub Judiny 11 months ago
- Status changed from Feedback to Resolved
Rajmund Hruška wrote in #note-3:
I think that 'st_from' and 'st_to' is not the only issue. I looked at the SQL query it produces:
[...]
The query is also taking the
detecttimeinto account and since this is not provided at URL, the default time window is used (which is one week ago from current time).
Now it should be fixed.
Updated by Rajmund Hruška 11 months ago
- Status changed from Resolved to In Review
Updated by Jakub Judiny 11 months ago
- Target version changed from Backlog to 2.12