Project and Portfolio Management Practitioners Forum
cancel

any way to CANCEL a requests in backend?

Highlighted
Rashraj
Respected Contributor.

any way to CANCEL a requests in backend?

Hi friends,

Is there a possible way to cancel an Request in backend or something? as we get 1000's of request to cancel at same time. we use version 6.0. Any help please?

Regards,
Rajesh
4 REPLIES
Raj Ghimire
Outstanding Contributor.

Re: any way to CANCEL a requests in backend?

Should be a very easy thing to do by simply updating the status_id and status_code value in KCRT_REQUESTS table. please verify the Status_id value for your instance.
=====================
UPDATE KCRT_REQUESTS
SET status_id=4 , status_code='CANCELLED'
where
request_id in (select kr.request_id from kcrt_requests kr where....)
====================
if you wish, you can even enter notes for those cancelled reqeusts using the same script.


Thanks.
-Raj
Rashraj
Respected Contributor.

Re: any way to CANCEL a requests in backend?

Hi Raj,
Thanks for the note. But i tried this earlier , but i could see all the action buttons still visible in front end, while only the status is changed to CANCEL :-(
Rashraj
Respected Contributor.

Re: any way to CANCEL a requests in backend?

Hi Dude,
This one worked :) Thanks a lot

Cheers
Rajesh
Rashraj
Respected Contributor.

Re: any way to CANCEL a requests in backend?

This one worked on above help.

Thanks
Rajesh