Does anyone know of a workaround to trigger a Business Event based on a Parent GI? In reality, I want to do it based on a schedule, so I can send an email regarding the status of our Daily Field Reports. However, an email of just info from the top-level DFR table isn’t particularly helpful; it would provide a lot more value if I can present some statistics about the DFR (but since the DFR data comes from a bunch of different tables, I grouped child queries by table and joined them to a parent table, hoping that I could send an email based on a schedule for the Parent GI Data; but was shot down).
Essentially, I want to send a Daily Report summarizing the DFRs to our management staff (with a link to the actual PDFs) rather than sending individual emails when the DFRs are approved.
