Hello,
On this report "planning yearly project/resource", when the first month is not 1, the ressources details are not displayed, only the summarry on top is diplayed. When we indicate 1 for the first month, we have the details.
We use this planning for a 4+8 exercise.
Regards,
Hello
I do not reproduce.
Su what version of ProjeQtOr are you? Are you sure you haven't activated a filter on a project that contains no data? Do you have any errors in the solution logs? of the browser?
- v10.1.2
- I see a difference on console :
For first month=1
=> 1495ms | page='../report/yearlyPlanResource.php' | destination='detailReportDiv' | formName=reportForm' (server:1391ms, client:104ms)
[Violation] Forced reflow while executing JavaScript took 80ms
For first month=2
projeqtor.js?version=V10.1.2.0322:181 => 261ms | page='../report/yearlyPlanResource.php' | destination='detailReportDiv' | formName=reportForm' (server:239ms, client:22ms)
and indeed SQL Errors :
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
2023-05-16 11:07:44.648 ** ERROR ** [V10.1.2] For query : select * from work where ( ((idProject not in (0) or idProject is null ) and (idProject not in (0) or idProject is null or (1=4) ) and (idProject not in (0) or idProject is null or (1=3) )) or idProject in (0, 30, 17)) and ( year= '2023' or year = '2024') and month >= '202302' and month query called at [/u01/app/apache/www/html/projeqtor/model/persistence/SqlElement.php:2947]
2023-05-16 11:07:44.649 ** ERROR ** [V10.1.2] #1 SqlElement->getSqlElementsFromCriteria called at [/u01/app/apache/www/html/projeqtor/report/yearlyPlanResource.php:84]
2023-05-16 11:07:44.654 ** ERROR ** [V10.1.2] Exception-[42883] SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = '202302' and month = '202302' and month query called at [/u01/app/apache/www/html/projeqtor/model/persistence/SqlElement.php:2947]
2023-05-16 11:07:44.654 ** ERROR ** [V10.1.2] #1 SqlElement->getSqlElementsFromCriteria called at [/u01/app/apache/www/html/projeqtor/report/yearlyPlanResource.php:95]
Ticket #7141 recorded