Do Subscription Notifications take Application recalculations into consideration?
I have a daily subscription notification setup for our Metrics Results Application to send out a Digest of records if they are approaching their due dates. The Applications recalculates at 3:00 AM and the Subscription Notification is scheduled daily at 8:00 AM. The filter criteria on the notification uses a calculated field (Approaching Due Date). First test, this did not generate a notification. I then changed the filter criteria to say 2 days prior to the due date instead of using the calculated field. Still no notification was sent. If I do not include a calculated field or use a date, I don't have any problems with the notification. All of our other Subscription Notifications do not use dates or calculated fields in the filter criteria so I do not have anything to compare to. For Subscription Notifications, are Application recalculations not taken into consideration before the notifications are queued? Do Subscription Notifications not work with dates? Is there any suggestions on how to leverage a calculated field or date for Subscription Notifications that will work? The troubleshooting documents do not have any information regarding filter criteria except for reminder notifications.
- Community Thread
- filter criteria
- Forum Thread
- RSA Archer
- RSA Archer Suite
- subscription notifications
Notifications do not consistently trigger when filtered on calculated fields. You could try creating a report that filters on your Approaching Due Date field and then use a scheduled report distribution to disseminate the records returned as an attachment.
You should also check the recalculation schedule. If you have set the time for recalculate at 12:00 AM then Archer will recalculate it at approximately 12:01 AM. Your notification triggering time should be after that. If everything is alright then try creating a off-layout calculate field with will calculate the number of days for your Approaching Due Date and Today using DATEDIF function. Then use this field in the subscription notification filter criteria, for example if your Approaching Due Date is 01-03-2019 and Today is 01-01-2019 then DATEDIF will give you 2 as output. Then you can set the filter criteria to the off-layout field=2. This will trigger the notification 2 days prior to the due date. I also have a same kind of scenario and this solution works for me.
Thanks for this information. Based on this information, our initial configuration for the Subscription Notification is similar to what your describing and did not return expected results. The Applications recalculation occurs at 3:00 AM and the Subscription Notification is scheduled for 8:00 AM which should be plenty of time for the calculation to complete. We do use a calculated field that is "off-layout" for the filter criteria.
You need to check one more thing. The users which are going to receive the notification should have read access to the Application. Also the try changing User Subscription to Required. I'm still figuring out the Control Panel fix.