Forum

[SOLVED] import ass...
 
Notifications
Retirer tout

[SOLVED] import assignments with real work ==> the real work of activity not updated

8 Posts
2 Utilisateurs
0 Reactions
8,058 Vu
(@yelazhari)
Posts: 35
Active Member
Début du sujet
 
[#2513]

Hi ,

I have a question about importing assignements :
When assignments are imported with a real work filled,the real work of the related activity is not updated, is that normal ? In my opignon , once the assignment is imported with real work , the real work of the actifity must be also recalculated and updated

Thanks.


 
Posté : 14 Août PM 15:088
(@babynus)
Posts: 14952
Membre Admin
 

When assignments are imported with a real work filled,the real work of the related activity is not updated, is that normal ?

Yes, it is normal.
The real work is calculated from work in db, so each time you add assignment, without work item, real work is automatically updated to zero.

In my opignon , once the assignment is imported with real work , the real work of the actifity must be also recalculated and updated

Same thing as real work for activity is sum of real work for all assignments on the activity.


 
Posté : 14 Août PM 15:088
(@babynus)
Posts: 14952
Membre Admin
 

When assignments are imported with a real work filled,the real work of the related activity is not updated, is that normal ?

Yes, it is normal.
The real work is calculated from work in db, so each time you add assignment, without work item, real work is automatically updated to zero.

In my opignon , once the assignment is imported with real work , the real work of the actifity must be also recalculated and updated

Same thing as real work for activity is sum of real work for all assignments on the activity.


 
Posté : 14 Août PM 15:088
(@yelazhari)
Posts: 35
Active Member
Début du sujet
 

So , you confirm if assignments are imported with a real work value ,the real work of the related activity will be also updated ?


 
Posté : 14 Août PM 16:088
(@babynus)
Posts: 14952
Membre Admin
 

So , you confirm if assignments are imported with a real work value ,the real work of the related activity will be also updated ?

No, because real work of assignment will previously be set to zero, as there is no real work input (object work) on this assignement in the db.


 
Posté : 14 Août PM 16:088
(@yelazhari)
Posts: 35
Active Member
Début du sujet
 

may be I did not understand well your explanation "as there is no real work input (object work) on this assignement in the db" , but looking at the assignment table I found that there's indeed a real work field in DB ( see the screen attached)?

could you explain me more?

Thanks a lot for your support and help


 
Posté : 15 Août AM 00:088
(@babynus)
Posts: 14952
Membre Admin
 

Yes, there is realWork in assignement, but it is always automatically updated as sum of work for each work.
It could be interpreted as :
assignment.realWork=select sum(work) from work where work.idAssignment=assignment.id
(it is not done this way but result is equivalent)


 
Posté : 15 Août AM 02:088
(@yelazhari)
Posts: 35
Active Member
Début du sujet
 

After test , I confirm.
Thanks.


 
Posté : 15 Août PM 17:088
Share:
Retour en haut