matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.92k stars 2.66k forks source link

[Bug] Live.getLastVisitsDetails with visitStartServerHour returns different server time #22752

Open rcontiuk opened 1 week ago

rcontiuk commented 1 week ago

What happened?

Running the following API call, Live.getLastVisitsDetails with segment=visitStartServerHour==XX does not return visits with XX server time for initial few rows:

https://demo.matomo.cloud/index.php?module=API&method=Live.getLastVisitsDetails&idSite=1&period=day&date=yesterday&format=JSON&token_auth=anonymous&segment=visitEndServerDate==2024-11-11;visitStartServerHour==20

This was tested with other Cloud instances and produces similar results. See two examples below:

API call 01 image

image

API call 02 image

image

What should happen?

The API call should return all visits that matches the criteria segment=visitStartServerHour==XX.

How can this be reproduced?

Can be reproduced in several Cloud instances.

Matomo version

Cloud

PHP version

No response

Server operating system

No response

What browsers are you seeing the problem on?

Not applicable (e.g. an API call etc.)

Computer operating system

No response

Relevant log output

No response

Validations