Forum

Planning details no...
 
Notifications
Retirer tout

Planning details not displayed when first month is not 1

5 Posts
3 Utilisateurs
0 Reactions
1,229 Vu
(@hervec)
Posts: 39
Trusted Member
Début du sujet
 
[#8899]

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,


 
Posté : 16/05/2023 12:09 pm
(@marylene)
Posts: 592
Membre Admin
 

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?


 
Posté : 16/05/2023 12:59 pm
(@hervec)
Posts: 39
Trusted Member
Début du sujet
 

- 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)


 
Posté : 16/05/2023 1:09 pm
(@hervec)
Posts: 39
Trusted Member
Début du sujet
 

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]


 
Posté : 16/05/2023 1:10 pm
(@babynus)
Posts: 14952
Membre Admin
 

Ticket #7141 recorded


 
Posté : 16/05/2023 9:58 pm
Share:
Retour en haut