Solved

SharePoint 2007 Alert Based on Date Filter

Posted on 2011-02-15
3
937 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

911 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

23 Experts available now in Live!

Get 1:1 Help Now