Bug #7672
closed
Searching for report-related events does not work properly
Added by Jakub Judiny over 1 year ago.
Updated about 1 year ago.
Category:
Development - GUI
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.
- To be discussed changed from Yes to No
- Status changed from In Progress to Resolved
- 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).
- 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 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).
Now it should be fixed.
- Status changed from Resolved to In Review
- Target version changed from Backlog to 2.12
- Status changed from In Review to Closed
Also available in: Atom
PDF