Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

How to remove a tic...
 
Notifications
Clear all

How to remove a ticket with Real Work?

3 Posts
2 Users
0 Reactions
3,137 Views
 Carl
(@carlc)
Posts: 18
Active Member
Topic starter
 
[#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.


 
Posted : 02 Aug 2018 14H49
babynus
(@babynus)
Posts: 14966
Main Contributor 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


 
Posted : 03 Aug 2018 20H41
 Carl
(@carlc)
Posts: 18
Active Member
Topic starter
 

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.


 
Posted : 07 Aug 2018 13H33
Share:

Scroll to Top