SELECT SecLink FROM Security WHERE SecLink=43 AND UserLink=;OUTPUT NIL DELETE FROM DataEntryToDo WHERE DataEntryToDoID= AND FirstBy=;FINISHSuggestion Deleted.
  Data Entry To Do List
Our Campaigns is a work in progress. Members are constantly adding data.

On the left is a list of data entry projects that have been completed and the dates they were completed on, newest first, since this feature was added (7/22/2010). On the right is a list of data entry projects that require attention when people have time. Members with data entry access may add to, modify or mark as complete items in this list.


- Randy Parker

SELECT * FROM DataEntryToDo WHERE CompleteDate != '0000-00-00 00:00:00' ORDER BY CompleteDate DESC;OUTPUT
Completed Data Entry
Complete Date Description
,Safe>  :
SELECT UserID SgUserID,Nym SgNym,DataEntryToDoID,Title,FirstBy,FirstEnter FROM DataEntryToDo,User WHERE CompleteDate='0000-00-00 00:00:00' AND UserID=FirstBy ORDER BY FirstEnter;OUTPUT
To-Do Data Entry
Suggested Date Suggested By Description
,Safe>  : [X]