View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Planning details not displayed when first month is not 1 - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Planning details not displayed when first month is not 1

More
16 Mai 2023 10:09 #1 by hervec
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,
Attachments:

Please Connexion or Create an account to join the conversation.

More
16 Mai 2023 10:59 #2 by Arkhanje
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?

Please Connexion or Create an account to join the conversation.

More
16 Mai 2023 11:09 #3 by hervec
- 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)

Please Connexion or Create an account to join the conversation.

More
16 Mai 2023 11:10 #4 by hervec
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 <= 202401
2023-05-16 11:07:44.648 ***** ERROR ***** [V10.1.2] Strack trace :
2023-05-16 11:07:44.648 ***** ERROR ***** [V10.1.2] #0 Sql->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 <= integer
LINE 1: ...or year = '2024') and month >= '202302' and month <= 202401
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
2023-05-16 11:07:44.654 ***** ERROR ***** [V10.1.2] For query : select * from plannedwork 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 <= 202401
2023-05-16 11:07:44.654 ***** ERROR ***** [V10.1.2] Strack trace :
2023-05-16 11:07:44.654 ***** ERROR ***** [V10.1.2] #0 Sql->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]

Please Connexion or Create an account to join the conversation.

More
16 Mai 2023 19:58 #5 by babynus
Ticket #7141 recorded

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.036 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.