View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - The problem with the assignments - Page 2 - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

15 et 16 avril 2025 (9h-12h30)

14 et 15 mai 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

23 et 24 avril (9h-12h30)

20 et 21 mai (9h-12h30)

 

 

 

The problem with the assignments

More
23 Mai 2023 03:28 #7 by Tatiana
What does it mean that toy cannot link the real time which is indicated for the activity and what was informed on a ticket. Cannot you calculate that the sum of tickets does not equal to 12 thousands hours?!

All advice is superficial. I did everything what you said again, nothing changed

Please Connexion or Create an account to join the conversation.

More
23 Mai 2023 08:28 #8 by babynus
User can input real time on activity. Let say they enter X days of real work on Activity A.
If then users link tickets to this Activity A as planning activity, and enter real work on the tickets, let say total of Y days, then real work on the activity is X + Y.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
23 Mai 2023 13:26 #9 by Tatiana
Yes, I do understand that. However, the developer enter the real time in 1 ticket, estimated time was 7 hours, he finished the task for 6,5 hours (screenshot attached). So, the overall real time for the ticket is 6,5 hours. The ticket is linked to the activity. There is only one ticket which is linked to that activity. Our developers dont have rights for the timesheet section to put the real time data to the activity. 

Taking into account this information, the overall real time shoud be 6,5 hours for the activity. Is that right? 
However, the real time for that activity is almost 18 thousands hours. My question is how is that possible? 
Attachments:

Please Connexion or Create an account to join the conversation.

More
23 Mai 2023 14:17 #10 by babynus
Can you please try this query on the DB
select * from work where refType='Activity' and refId=6761
What is the result ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
24 Mai 2023 04:09 #11 by Tatiana
The result in the attached file
Attachments:

Please Connexion or Create an account to join the conversation.

More
24 Mai 2023 09:07 #12 by babynus
You only get one Row ?
To be sure, please execute
select count(*), sum(work), min(workDate) as start, max(workDate) as end from work where refType='Activity' and refId=6761

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.045 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.