Project

General

Profile

Actions

Bug #7672

closed

Searching for report-related events does not work properly

Added by Jakub Judiny 10 months ago. Updated 10 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Development - GUI
Target version:
Start date:
08/14/2023
Due date:
% Done:

0%

Estimated time:
To be discussed:
No

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.

Actions #1

Updated by Jakub Judiny 10 months ago

  • To be discussed changed from Yes to No
Actions #2

Updated by Jakub Judiny 10 months ago

  • Status changed from In Progress to Resolved
Actions #3

Updated by Rajmund Hruška 10 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).

Actions #4

Updated by Jakub Judiny 10 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 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.

Actions #5

Updated by Rajmund Hruška 10 months ago

  • Status changed from Resolved to In Review
Actions #6

Updated by Jakub Judiny 10 months ago

  • Target version changed from Backlog to 2.12
Actions #7

Updated by Rajmund Hruška 10 months ago

  • Status changed from In Review to Closed
Actions

Also available in: Atom PDF