I implemented (almost) such a solution for two of our schema. My users
want to have only the current year included in the ID. So they'd like
something like HD2007xxx
Very easy to implement.
The only problem I have is that I don't get it automatic so every year I
have to produce the same manual hadling.
This is how I do:
- wait for first ticket to be created with whatever => either the ID
xxxxxxx by default or with some attributes defined so for ex. HDxxxxxx
Then export the data. Edit and change the HD00001 for HD200700001. Then
the system builts the next ID's itself.
I created a filter with a read value from SQL "select
convert(char(4),getdate (), 112)" which is suppose to set the problem
number=$1.
But for some reasons this doesn't work.
As my users and management and God are all very happy with this, then I
leave it as it is.
Hope this could help.
Serouche
Steven Pataray wrote:
** My managment would like to have a date included our HelpDesk Case
number i.e. HD20070420xxxxx. The xxxxx would be the actual sequential
case number. They would use this so they know what day a ticket was
created. I really don't want to create another field with this number
appended to each other since a lot of the reports and table queries
are based on the Case number. Does anyone have any advise how I can
achieve this?
Thanks
Steve
ARS/HelpDesk 6.3 patch 19
Oracle 10g R1 Clustered
Application server Windows 2003
__20060125_______________________This posting was submitted with HTML
in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
