samwoo Posted November 4, 2016 Share Posted November 4, 2016 Hello, I went into the My Activities area and amended by default View to hide Tasks that are Closed or Cancelled. Upon making the change I noticed that there were lots of Outstanding tasks on the list that I wasn't aware of. Going into the call related to the Tasks I can see that the call is Cancelled... but the Tasks still remain open on the right hand side. I then attempt to delete them... but I cannot (throws out an error). So I manually complete them one-by-one. Going back to the My Activities area these Tasks have now disappeared from the list. Aren't Tasks supposed to be cancelled when a Request is? What can we do to resolve this? To check with you (Hornbill Guru's) first - I was thinking of an Update SQL script using similar to select criteria as below... but I do not know what field in the h_sys_tasks table relates to whether a Task is cancelled or not (I'm guessing it's h_state but the numbers are not very clear to what they are). I am also not sure of the implications of running this update script hence the reason I am checking on here. SELECT * FROM h_sys_tasks WHERE h_obj_ref_urn in ( SELECT 'urn:sys:entity:com.hornbill.servicemanager:Requests:' || h_pk_reference FROM h_itsm_requests WHERE h_Status = 'status.cancelled' ) Could someone look into this and advise please? Thanks, Samuel Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now