I'm trying to create a business event that triggers when a task has been open for more than 2 hours. I created a generic inquiry with the condition to include only tasks where the created date time is less than 2 hours ago. Then I set up the business event to trigger on record change, for each record, with the trigger condition set to "record inserted."
However, the business event isn't triggering. Any ideas what might be wrong?
!-->
Best answer by mohammadnawaz51
The "Trigger by Schedule" option will execute the event every 2 hours.
You can create a Generic Inquiry (GI) that lists records with a Last Modified Date within the past 2 hours. This approach may help you trigger a Business Event effectively.
+4
could you please provide the XML files of the Generic Inquiry (GI) and the Business Event (BE) so I can review and assist you further?
My recommendation is to ensure that all the key fields (highlighted in yellow) in each table are set as mandatory for the Business Event to trigger properly.
I've done more research, and I'm afraid this cannot be accomplished with the "Trigger by Record Change" business event type. since after the two hours pass, nothing changes in the task record itself—so there's nothing to trigger the system to check if the record meets conditions and fire the event. I believe this can only be accomplished with the "Trigger by Schedule" type.
Please confirm or suggest an alternative approach.
+4
The "Trigger by Schedule" option will execute the event every 2 hours.
You can create a Generic Inquiry (GI) that lists records with a Last Modified Date within the past 2 hours. This approach may help you trigger a Business Event effectively.
In addition to using Trigger by Schedule, ensure to check your condition to verify the Date function when applying time offsets. Pay attention to the UTC vs. local time to ensure your events align correctly.
I have a Business Event configured this way, and it’s been working successfully.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
