Currently I have been trying with a trigger but the problem is at the db level there is no way to capture the username actually logged into PPM clicking the button.
DROP TRIGGER PPMDEV.KCRT_REQUEST_DELETE
CREATE OR REPLACE TRIGGER PPMDEV.KCRT_REQUEST_DELETE
request-listener-type should point to the java class you created for handle the event,
please see the attachment for reference , set the event listener xml and extract the zip, put penoles folder under itg.war/web-inf/classes folder, restart the server, if someone delete the request, you can find error info in log/serverLog.txt
the java source file as following, It was a very simple implementation, you can change according to you own requirement.
for question1, I have no idea why the username is showing up with null since I haven't got this. I 'm working on ppm9, maybe we are on different version. another way to get user name is call context.getServerConnection().getLogonPacket().getUser().getUserName(), this should work.
As the code I given is just POC that can track the delete request event, if you have some knowledge of java programming, that's not a question for question 2 and 3, if you haven't , you may need find someone to help you to write a piece of code.
I appreciate all your assistance. I did get the new call to work properly for the username. Maybe it is a difference between 8 and 9. I have very limited JAVA experience.
If you could just entertain one more question for me on this. Where is it or how do you find all of the calls that can take place in the different contexts. I.E. Is there a file I can look at like a tag library or something in the PPM file system that will tell me all the different items I can pull from context. Example, instead of context.ReqID() can I pull context. ReqDescription().
There is a trigger on the knta_user_security table that records all inserts, updates and deletes in the knta_user_security_hist table. The information that is logged includes the user id that performed the function. You may be able to use this trigger as a model for one tracking deletes of requests.
Thank you for trying, but just like most of the stuff in the database, HP is taking a short cut. Anytime there is a delete they just default the value to 1, instead of actually capturing who did the delete.
knta_classes.jar, it can be found in itg.war/web-inf/lib, but keep in mind, it does not contain source code but the binary class files; but you can get all the functions which can be called from a class.