January 25, 2015 at 10:03 pm
I have a status matrix for sending email. With few status like Activated, completed Etc. Users are allowed to change the status For example. User can change Activated status to complete based on some conditions. (For example -: Once the action is finished,the user can change the status to completed) When they edit the status email will be send.
I have a status table with statusID and Status Description.(1 Activated, 2 Completed) .How can I store above highlighted condition in sql database. can it is stored as stored procedures. If so how can I write it.I am new to stored procedure.
Thanks
January 26, 2015 at 4:06 pm
What are you using to show your status matrix? Are you successfully retrieving tasks (the objects you are setting the status for) from an SQL query? Have you written an SQL query to save the change in status to the database?
Are you also asking how to send these status change notification emails in an SQL stored procedure?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply