23.12.2024
13:43
Hi,
We noticed some problems with vacation Gantt chart report with past vacations after update to 2024.
The problem occured on 2 versions 2024.1.1.130 and 2024.1.1.161.
2024.1.1.130:
#1 problem we noticed:
We cannot see any past data vacations, mainly on a simpified report (black/white one).
#2 problem we noticed:
On a advanced report with colors we can see past vacations but not all types.
2024.1.1.161:
All type of reports (simple/advanced) dont show any past vacations.
We updated to 2024.1.1.161 after finding changelog notice, that some problems with vacations report were repaired.
Our config:
We use a data source with SQL view with past vacations, and all type of data in columns are correct:
VAC_UserID <String>
VAC_From <Decimal>
VAC_To <Decimal>
VAC_VACTypeID <String>
SQL: select * from [V_Urlopy_Historia]
After some tests we've done:
After manually entering the sql query on TEST SERVER (2024.1.1.161) that indicates a specific time range, user and vac_type - data appears in the report. BUT ONLY if the query concerns a maximum of 2 days. If the query has more than 2 days - nothing appears in the report. But if data comes from SQL View - there's nothing on the report, even if time range is less than 2 days.
