RE: Ticket tracking system

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Tue, 02 Apr 2002 13:08:28 -0800
Message-ID: <F001.0043939B.20020402130828@fatcity.com>

Manager to David...

"David, this is your manager speaking. Larry says he opened 10 tickets last month to get the Brady report fixed. Is that true?"

ok enough of that let's ponder some possible solutions...

1. Have everyone print out a copy of their ticket and then submit it back to you to re-enter if they want to re-open it.
2. Use log miner to log your archive logs. Find the SQL to recreate the ticket then run it again against the database.
3. This one is really just a better idea for #1...have everyone do a print screen of each ticket then create a database that allows people to upload the picture of the ticket. Save those and you can refer to them if you need to re-create a ticket.
4. This last solution is really dumb but also might work...instead of deleting the record perhaps you could just add a status column to the table and then mark it as closed. Then you could re-open it using an update statement.
   • Ethan

-----Original Message-----
Sent: Tuesday, April 02, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L

I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise.

Thanks,
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nguyen, David M
  INET: david.m.nguyen_at_xo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 02 2002 - 15:08:28 CST