Query Log doesn't show date #1112

Closed
opened 2026-03-04 01:04:42 -05:00 by deekerman · 2 comments
Owner

Originally created by @Ultrabenosaurus on GitHub (Nov 24, 2019).

Originally assigned to: @ArtemBaskal on GitHub.

Prerequisites

Please answer the following questions for yourself before submitting an issue. YOU MAY DELETE THE PREREQUISITES SECTION.

  • I am running the latest version
  • I checked the documentation and found no answer
  • I checked to make sure that this issue has not already been filed

Problem Description

Now that AGH supports logging more than 24 hours of data the Query Log should display the date as well as the time for each row, at least for any request not made on the current day. At the moment the date is only shown in a tooltip when hovering over the time no matter how wide you drag the column. In the screenshot below I have filtered the log based on the IP address of a relative's smartphone, who last visited a few days ago.

image

Proposed Solution

Show the date for requests not made on the current day or for all requests, with a default column width suitable for displaying both date and time. This could be enabled for all users or dynamic based on the chosen data retention period, e.g. it's not entirely necessary for people who have their AGH set to 24 hours.

Alternatives Considered

It may also be nice to have a toggle setting for "always show date" vs. "show date for requests not made today" so people can choose how they want it displayed. I can't speak for everybody but I would find it much easier to notice when I reach the end of today's data while flicking through my Query Log if one request only shows a time and the next also shows the date. This would be beneficial when looking for suspect, missing, or expected requests, or when investigating a sudden increase in requests.

Originally created by @Ultrabenosaurus on GitHub (Nov 24, 2019). Originally assigned to: @ArtemBaskal on GitHub. <!-- As an open-source project with a dedicated but small maintainer team, it can sometimes take a long time for issues to be addressed so please be patient and we will get back to you as soon as we can. --> ### Prerequisites Please answer the following questions for yourself before submitting an issue. **YOU MAY DELETE THE PREREQUISITES SECTION.** - [x] I am running the latest version - [x] I checked the documentation and found no answer - [x] I checked to make sure that this issue has not already been filed ### Problem Description <!-- Is your feature request related to a problem? Please add a clear and concise description of what the problem is. --> Now that AGH supports logging more than 24 hours of data the Query Log should display the date as well as the time for each row, at least for any request not made on the current day. At the moment the date is only shown in a tooltip when hovering over the time no matter how wide you drag the column. In the screenshot below I have filtered the log based on the IP address of a relative's smartphone, who last visited a few days ago. ![image](https://user-images.githubusercontent.com/1901532/69492100-bf435b80-0e95-11ea-8b8a-59513fa59b29.png) ### Proposed Solution <!-- Describe the solution you'd like in a clear and concise manner --> Show the date for requests not made on the current day or for all requests, with a default column width suitable for displaying both date and time. This could be enabled for all users or dynamic based on the chosen data retention period, e.g. it's not entirely necessary for people who have their AGH set to 24 hours. ### Alternatives Considered <!-- A clear and concise description of any alternative solutions or features you've considered. --> It may also be nice to have a toggle setting for "always show date" vs. "show date for requests not made today" so people can choose how they want it displayed. I can't speak for everybody but I would find it much easier to notice when I reach the end of today's data while flicking through my Query Log if one request only shows a time and the next also shows the date. This would be beneficial when looking for suspect, missing, or expected requests, or when investigating a sudden increase in requests.
deekerman 2026-03-04 01:04:42 -05:00
Author
Owner

@ghost commented on GitHub (Nov 24, 2019):

https://github.com/AdguardTeam/AdGuardHome/issues/624 (v0.101)

@ghost commented on GitHub (Nov 24, 2019): https://github.com/AdguardTeam/AdGuardHome/issues/624 (v0.101)
Author
Owner

@Ultrabenosaurus commented on GitHub (Nov 24, 2019):

@ArchiveBase I feel that this is different now. #624 is about Chinese localisation and was opened before AGH could support more than 24 hours of log retention. Now the log can contain more than 24 hours this should be high priority.

I almost opened this as a bug instead of feature request as it feels like it was "missed" or "forgotten" when extended log retention was added. It's very annoying when viewing the Query Log, especially when filtering the data, that it is not obvious what day a request was made.

@Ultrabenosaurus commented on GitHub (Nov 24, 2019): @ArchiveBase I feel that this is different now. #624 is about Chinese localisation and was opened before AGH could support more than 24 hours of log retention. Now the log can contain more than 24 hours this should be high priority. I almost opened this as a bug instead of feature request as it feels like it was "missed" or "forgotten" when extended log retention was added. It's very annoying when viewing the Query Log, especially when filtering the data, that it is not obvious what day a request was made.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/AdGuardHome#1112
No description provided.