Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings

Sitekeys modification

Status: Comments Requested
by Bronze Super Contributor on ‎06-04-2012 09:01 AM

Add a column that stores the value for the first digit of a SalesLogix id.

 

Stored procedures to create SalesLogix keys or similar type functionality have to be updated everytime a new keytype comes out.

 

Here is an example:

 

-- Procedure Name: SPR_GetNextKey 
-- Date Created: 08/05/2004 
-- By: John Ostheimer - From code provided on CRM message board
.
.
.
SELECT @NewKey = CASE @KeyType 
WHEN 1 THEN 'A' 
WHEN 2 THEN 'O' 
WHEN 3 THEN 'C' 
WHEN 4 THEN 'B' 
WHEN 5 THEN 'V' 
WHEN 6 THEN 'H' 
WHEN 7 THEN 'E' 
WHEN 8 THEN 'n' 
WHEN 19 THEN 'L' 
WHEN 20 THEN 'Z' 
WHEN 21 THEN 'Y' 
WHEN 22 THEN 'a' 
WHEN 23 THEN 'J' 
ELSE 'Q' 
END

 Since this was released more key types have been added.  Most notiable is probably Ticket, 32.  Storing these values would eliminate a need to update 100's if not 1000's of deployed solutions when keyvalues are added.

 

If the new column is called KeyFirst this is what could be coded to obtain the value

 

declare @keyFirst char(1)

set @keyFirst = 'Q'

select @keyFirst = KEYFIRST from sysdba.SITEKEYS where KEYTYPE = 32

 

 

Comments
by Moderator Moderator
on ‎08-01-2012 11:54 AM
Status changed to: Under Consideration
Please clarify the purpose of this request.
by Moderator Moderator
on ‎08-08-2014 04:40 PM
Status changed to: Comments Requested
 

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels