Solved

SharePoint 2007 Alert Based on Date Filter

Posted on 2011-02-15
3
922 Views
Last Modified: 2012-06-21
I have a SharePoint View on a list that calculates when the list item was last updated using [Today]-1 based on the default field "Modified".  The filter is typed out below also.  The view works perfectly but I am unable to send an email alert if anything pops up in this view.  I believe that in order for an email alert to work, a list item has to be modified.  In this filter, nothing is being modified, it is just a list item that is aging and eventually meets the criteria to show up in this view if it is not touched within 24 hours.  

Is there any way to send an email to a person when items show up in this view?  

Show the items when column "Modified" is less than [Today]-1
and
When Column "Status" is not equal to "Resolved" 
and 
When Column "Status" is not equal to "Closed"

Open in new window

0
Comment
Question by:tresmanos
3 Comments
 
LVL 14

Accepted Solution

by:
KoenVosters earned 300 total points
ID: 34900408
You can create a custom timer job that sends out alerts. The job runs once a day and checks the list to see if an item is expired:
http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx

There is also a full code example here:
http://www.codeproject.com/KB/sharepoint/SPScheduedReminders.aspx
0
 
LVL 11

Assisted Solution

by:FastFngrz
FastFngrz earned 200 total points
ID: 34902708
You could also write a workflow with sharepoint designer that waits 'x' days and then sends an email.  No code!
0
 

Author Closing Comment

by:tresmanos
ID: 34970908
Both are good ideas, I will look into these.  Thanks for your input, much appreciated.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now