• State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 96 subscribers
  • Views 5856 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

PWOHelperPWO Insert event not fired (workaround?)

michele.polizio
over 8 years ago

Hi,

I noticed that I can create a process that run on the insert of the table PWOHelperPWO but only on the evente DECISIONREQUIRED.

But  I need to set an custom column on this table on the insert event.

There is any workaround? Can I listen to the event when from the PersonWantsORg table create all the entries in the PWOHelperPWo table?

Thanks Michele

  • 0 over 8 years ago
    I'm not sure, if I fully understand your question.
    To set a custom colulmn on the insert event, one needs to create a new process that gets triggered through the insert event. The table PWOHelperPWO does not have a this event defined, therefore this event needs to be created.
  • 0 over 8 years ago

    You can't create the "INSERT"event (I tried) it should be already present in the list of default events for the table (version 7.1).

  • 0 over 8 years ago

    What is denying the create?
    To create an event one needs to press the new-button on the Events tab in Designer. Then in the popup press again the new-button and type INSERT into the Object event. Or one can directly in ObjectBrowser insert a QBMEvent with EventName INSERT for the UID_DialogTable PWOHelperPWO.

    Figure 1: The new-button for creating a custom event

  • 0 over 8 years ago
    I already created the event INSERT in the event list of my process but the event is not triggered.
    I think is related to this other thread
    www.quest.com/.../17301

    Not all table has the INSERT or UPDATE or DELETE trigger defined and is that trigger that generate our event in the system
    So I'd like to create a trigger for insert event in table PWOHelperPWO but I don't know which procedure call to create INSERT event on 1IDM.