Not able to set Alerts for some views in SharePoint list

If you notice, the user was not able to select some views while setting the alerts. The dropdown shows only few views from the list 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“

Automatically create Word documents which include list fields

http://blogs.technet.com/b/brenclarke/archive/2009/04/15/automatically-create-word-documents-which-include-list-fields.aspx

Filter item based on workflow status

numeric value for the workflow status

Not Started = 0

Failed on Start = 1

In Progress = 2

Error Occurred = 3

Canceled = 4 or 15

Completed = 5

Failed on Start(retrying) =6

Error Occurred (Retrying) = 7

Approved = 16