**
Kathy, Another trick is to create a view form to
the arschema table. You can probably figure out what to do from there. No SQL
involved. Just need to be careful. HTH, Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-267-6628 sf49fanv AIM IM RogerNall Yahoo IM From: Action Request
System discussion list(ARSList) [mailto: Here's the SQL that we use to reset the
request id: update ARAdmin.arschema set nextId = 1763 where name
= 'FormName'; From: Action Request System
discussion list(ARSList) [mailto: ** Hi all, Because some workflow had the wrong
qualification from a previous developer, 15,000 tickets were generated.
We left off at 7,000 and now we are at 22,000. Isn't there a way thru
SQL to reset the value of the HPD to 7,000 so Remedy goes to set the next
ID, it will think the last ID is 7,000. We also want to rename the HPD
tickets created today with a 7,000 value within the database. Our case ID is C1, I can find out the t
table, I am just not sure which command I would enter to modify the rows in the
database. And if this will present problems later. I know the users
will be referencing the wrong ticket number. We definitely do not want to
be at 22,000. __20060125_______________________This
posting was submitted with HTML in it___ |
- Created 15,000 tickets Kathy Morris
- Re: Created 15,000 tickets Kemes, Lisa
- Re: Created 15,000 tickets Kemes, Lisa
- Re: Created 15,000 tickets Nall, Roger
- Re: Created 15,000 ticke... Susan Palmer
- Re: Created 15,000 t... Susan Palmer
- Re: Created 15,000 tickets John Sundberg
- Re: Created 15,000 tickets Will Du Chene
- Re: Created 15,000 tickets McKenzie, James J C-E LCMC HQISEC/L3
- Re: Created 15,000 tickets Kathy Morris
- Re: Created 15,000 tickets McKenzie, James J C-E LCMC HQISEC/L3
- Re: Created 15,000 tickets Nall, Roger
- Re: Created 15,000 ticke... Susan Palmer