I would like to know where I would go about editing the listview (View Project List) query in projects. I do not want to show the records that have the status of Completed. I am NOT referring to the Project tasks, I want the Projects that have the status of Completed to not be displayed in the ‘View Project List’.
If I could make this dynamic (check box) that the user could toggle that would be even better. But that is secondary.
I don’t want it coded in such a way that ‘Completed’ Projects are never shown… only in the default View Project List and not when an Advanced Search is done.
How do I edit the SQL query that gets this data to omit these records?
SELECT * FROM Projects WHERE status <> ‘Completed’