I have realized that the was in () JQL search seems to have a bug. In JIRA server performs well as expected so that if I search:
Jira server: returned only the issues that was in in progress during today. Basically the issues I have in progress today.
project = MyProject AND issuetype = TaskType1 and status was "in_progress" DURING (2022-12-26,2022-12-27)
The same search in JIRA Clouds return all the issues that were in a moment on time in in progress state and seems not to take care of the DURING.
So, to sum-up completely different behaviour in JIRA Cloud and JIRA server. JIRA servers seems fine because I only expect to see the issues that were in that state during that time (not that have been before in that past state).
Any info or feedback from atlassian will be appreciated.
Thanks a lot,