AnsweredAssumed Answered

Create a sql to update open for time entry

Question asked by donkoller1319120 on Mar 8, 2012
Latest reply on Mar 8, 2012 by donkoller1319120
I have a PPM Manager that would like to reduce the amount of application investments that appear in the other time listing that have a description that includes the word "Support". There are over 1700 applications and 200 resources. That would be a large amount to update manually through the Staff Members Property screen. He would like a sql that would update open for time entry flag to closed for applications that contain the description the word "Support". What table or tables would need to be updated to remove the Support application from appearing from the other time. I appreciate your help.