Bola, You could export your application and all its workflow to a definition file. Then delete the objects in the admin tool and re-import the definition file. That will start you from scratch for all things associated with the new application. There was a definition file that used to be in the Developer community that showed you the next ID of every Schema and had workflow attached to a button that would reset the next ID of the selected schema. It used the Direct SQL action to perform an update on the table that holds the nextID field for each schema. It's a powerful tool and should be used with extreme caution. If I can find a copy of the file I'll send it to you.
John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 11:41 AM To: [email protected] Subject: Re: Starting a new ID ** Obviously, this has to be done at the database level. I am not the database administrator. Is there a way to do it on my end without contacting the administrator. Thanks. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, November 05, 2007 9:38 AM To: [email protected] Subject: Re: Starting a new ID Bola, Find out the schema ID of that form, you will be able to find this from the table arschema.. Corresponding to that row in the arschema table, modify the nextid value to 1. Also make sure that you have deleted all related tickets in case you have related information stored in other tables. Reset those ID's as well. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 9:33 AM To: [email protected] Subject: Starting a new ID ** Hello everyone, I created some tickets on a new application that I am implementing tomorrow. I will be deleting all these tickets, but I want the user to begin with Case ID "00000000001". Any quick idea on how to do this? Thanks all. Bola Oyefeso __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<attachment: image001.gif>>
