add: Conditionals in Table Change Alerts

[emoss08]

Is your feature request related to a problem? Please describe.
The need for this feature arises from the requirement to have more control and flexibility in triggering alerts based on specific conditions and criteria within a database system.

Describe the solution you'd like
The proposed solution aims to enhance the alerting functionality within our system by introducing conditional logic and data joins to tailor alerts to specific use cases. This feature would empower users to set up alerts that trigger only when certain conditions are met, and also incorporate data from related tables when necessary.

1. Conditional Logic for Alerts:

   • When adding a table change alert, users should have the option to define conditional logic that dictates when the alert should trigger.
   • Conditions can be based on specific columns or fields in the database, such as customer information, actions (e.g., insert), and any other relevant criteria.
   • For example, if an alert is set to trigger on a database insert action, users can specify additional conditions like "only trigger for a specific customer" or "only trigger when a certain frequency is met."

2. Data Joins for Enhanced Information:

   • To add further depth and relevance to alerts, the feature should allow users to perform data joins with related tables.
   • For instance, if a customer requests equipment positions for a tractor, users can configure the alert to join data from tables like "order," "movement," and "equipment positions" to provide comprehensive information.
   • This feature would enable users to create more context-rich alerts that deliver valuable insights to external customers.

By implementing these enhancements, our system will provide a powerful and customizable alerting mechanism, improving user satisfaction and meeting the diverse needs of our customers.

[emoss08]

Passed first wave of test. Still have not worked on getting it to work with joins ,but it does work with simple conditions such as where a field equals a specific value.

[emoss08]

Going to start working on the client side implementation for this.

[repo-ranger]

Congratulations! This issue has been included in the next release! Closing in 15 seconds . . .