AnsweredAssumed Answered

Brainstorming with Requisitions

Question asked by Chris_Shaffer_hcsc on Nov 20, 2008
Latest reply on Nov 24, 2008 by federico
I appreciate everyone's help with all of my various posts lately! Thank you! Right now I am playing around with some ideas for the Requisition object. My goal is to have a process fire off when a resource is assigned to the requisition. Sounds simple right?  Well the problem I am finding is that the resources are handled in a different table thus the process engine cannot see them to fire off with any logic. I thought about using a trigger on the resource table to update a custom attribute on the main requisition table (odf_ca_Requisition) and then have the process fire off on the update of that field. However I got too ahead of myself and realized that the process engine does not pick up simple table updates but rather updates made through the application.  So with that being said, can you think of any way that I can capture the event of a resource being added to a req and be able to fire off a process?