Uestion about internal DB Reports - Item Statistics reporting period

English mAirList 8.x
1

Hi everyone,

I have a question about how the internal DB Reports function works in mAirList.

I am trying to generate a report using:

Report type: Item Statistics
Filter: Item type = Music

The issue is that no matter which Reporting period I select, for example Today, Yesterday, This week, Last week, etc. I always get the same result.

It looks like the report is showing statistics from the beginning of logging/database history, going back years, instead of only the selected reporting period.

So I would like to understand how this report is supposed to work.

Does the Reporting period filter apply to the Item Statistics report at all?
Or is Item Statistics based on the complete database history regardless of the selected period?

Maybe I am misunderstanding the purpose of this report, or perhaps there is another setting/filter that needs to be used in order to get item statistics only for a specific time period.

Any clarification would be appreciated.

2

Anyone tried to use the log editor? The reporting period never filters the required time, i always get some kind of “select * from public.playlistlog” with no starttime defined as a result whatever i choose from the Reporting period drop down selection.

3

The period parameter should work with all kinds of reports.

We will try to reproduce. Can you please give me:

  • Exact version number/build?
  • What kind of database, local or SQL, and if SQL, which kind of server?
  • DBServer/DBClient is not involved, I suppose?
4

Can also confirm this is a bug.

Version: 8.0.7

Build: 6037

DB: PostgreSQL Direct Connection

5

mAirList v 8.0.7 build 6040
local network Ubuntu Linux 24.04.4 server with PostgreSQL version 16.13

DBServer/DBClient excluded.

6

Now fixed in version 8.0.8, thank you.

2 Likes
7

Great news ! Thank u.