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

[rcontiuk]

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

API call 02

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

• Read our Contributing Guidelines.
• Follow our Security Policy.
• Check that there isn't already an issue that reports the same bug to avoid creating duplicates.
• The provided steps to reproduce is a minimal reproducible of the Bug.