Consider the following scenario:
- A site based on any site template is created.
- A custom list is created with a column which looks up another list field.
- You create a view which filters items based on the lookup column value with > or < operators
- You create an immediate alert based on this view (For items which appear in this view)
- You add items to the list which ensures the items appear in this view.
This behavior is known to Microsoft at this time.
Article ID: 2901700 - Last Review: 5 Nov 2013 - Revision: 1