Forum

How to remove a tic...
 
Notifications
Retirer tout

How to remove a ticket with Real Work?

3 Posts
2 Utilisateurs
0 Reactions
3,122 Vu
 Carl
(@carlc)
Posts: 18
Eminent Member
Début du sujet
 
[#5326]

Hello, I'm stuck trying to remove some tickets which were imported from a spreadsheet with actual time.
Attached is a screenshot showing the problem.
I've tried setting the Assign Work (Dispatch Work) to 0, deleting the values, setting it from the ticket page - i've tried every combination of values (or blanks) to remove these but nothing seems to work.
Is there anywhere i can simply rip the values out of a DB table or another page i should be looking at for removing Real Work from an item?
Thanks

Additional: The same error message appears when i try and assign a time entry (ticket) to a task (activity) although the work hours values haven't changed.


 
Posté : 02/08/2018 2:49 pm
(@babynus)
Posts: 14952
Membre Admin
 

Only solution is to set realWork to zero in table workelement where refType='Ticket' and id=ids of the imported tickets.

NB : I recorded ticket #3519 to avoid this issue on import


 
Posté : 03/08/2018 8:41 pm
 Carl
(@carlc)
Posts: 18
Eminent Member
Début du sujet
 

Thank you, that worked perfectly! 🙂

After editing a few rows manually it seems to have unlocked something else as i'm no longer having a problem setting the Actual Work to 0 hours from the UI.
Hopefully i won't come across this problem again but it's nice to know there's an easy fix if it does happen.


 
Posté : 07/08/2018 1:33 pm
Share:
Retour en haut