If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: mail trigger-previous month  (Read 4126 times)

Offline priya@90

  • Senior Member
  • ****
  • Join Date: Jan 2016
  • Posts: 55
  • Forum Citizenship: +0/-0
mail trigger-previous month
« on: 01 Aug 2019 03:26:00 am »
Hello Everyone,

I have zero knowledge in Event studio. Can anyone has done before?

The Event condition is when count of record in the FACT table is zero for previous month, then email has to be triggered to clients.


Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 828
  • Forum Citizenship: +30/-1
Re: mail trigger-previous month
« Reply #1 on: 01 Aug 2019 10:17:29 am »
Event Studio runs the event on a schedule and will trigger an action based on comparison of the last two runs of the query.  If the results change, the action is fired.  (OK, you can set it to run every time, too...)

Craft your query such that the logic causes a new row to appear at the appropriate time.