Alerts – a simple notification mechanism supported by all the share point lists & Libraries. And one special thing is that we can set alerts for different views of the system. It acts only on the columns of that particular view. This can be done by selecting the appropriate view while setting the alert. That’s great!
One of the business user raised an issue that he is not able to set alerts for some of the views of the list.
If you see the screen shot above there are 7 different views created for the list.
If you notice here, the user was not able to select some views while setting the alerts. The dropdown shows only two views. Where the other views gone??
Digging more into it, I found out that, in the views that were not appearing in the alert dropdown, there was filtering done based on the workflow columns.
Conclusion : “Alerts will not work for the views if there is a filtering based on System Generated / Calculated columns“