8/25/2025 12:28:20 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Create Ticket ID
Posted: 04 Mar 07 6:10 AM
|
fiogf49gjkf0d Hi,
how to create a Ticket ID.
A Ticket ID consists out of 2 values. The Alternatekeyprefix and to Alternatekeysuffix. Alternatekeysuffix is an autonumber value. But how to generate the Alternatekeyprefix? Or is this an autonumber value too?
So that :
001-00-999999
following by
001-01-000000
And
001-99-999999
following by
002-00-000000
|
|
|
| |
|
Re: Create Ticket ID
Posted: 05 Mar 07 9:48 AM
|
fiogf49gjkf0d Based on the format you have provided, I think that you must be on the newer version of SLX that utilizes the application.basicfunctions.getprettykeysuffix and prefix.
However, to do what you have posted would not be available in the results returned from those functions. The results of those functions returns the first 001-00 portion of the key, is based upon the site code and key base of the system generating the ID. The last part of the ID is based on a numeric equivalent of the right 5 digits of the hexidecimal TICKETID primary table key generated by SalesLogix.
In order for you to increment with your desired sequencing you would need to develop a counter function and call upon that instead. You solution would have problems if remote or remote office users were creating tickets, as their "counters" would be disparate from the other counters on the central or other remote user's databases. |
|
|
|
Re: Create Ticket ID
Posted: 24 Apr 08 3:53 PM
|
Which keydesc value in sitekeys holds the hexadecimal value for this or, if it's easier, how do you get Scribe to put this data in when inserting into ticket? When I insert new records via Scribe it calculates the ticketid, but leaves alternatekeyprefix and suffix empty. Or, is there a place where we can track down the code behind GetPrettyKeySuffix and Prefix?
This is for 7.0.1. Because Scribe isn't generating that for me when inserting I'm looking to either get it to somehow or do it in a trigger once it's inserted.
TIA |
|
|
|
Re: Create Ticket ID
Posted: 15 Aug 08 5:02 PM
|
Just a follow up to my post. The first part of the prefix (i.e. 001 of the 001-00) is based of the following query
SELECT SITEOPTIONS.KEYPREFIX,SITEOPTIONS.SITECODE,SYSTEMINFO.SYSTEMINFOID FROM SITEOPTIONS, SYSTEMINFO WHERE SITEOPTIONS.SITECODE = SYSTEMINFO.SITECODE AND SYSTEMINFO.SYSTEMINFOID = 'PRIMARY'
The second part of the prefix is based off the remote's Keybase (i.e. a keybase of A1 = 01, A2 = 02, etc.) |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|