Login / Register  search  syndication  about

          Ryan Farley's Blog

Ryan Farley on .NET Development with a focus on CRM Development for SalesLogix

VBA Picklist Item Missing

Timmus Agersea from Customer Systems Inc shares a tip about a missing picklist item in SalesLogix related to script tasks in Contact Processes (posted in the SalesLogix Business Partner newsgroups). Thanks Timmus.

The Contact Process engine adds history records for each task.  If the type of task is a script, the history record type value is 262159.  This does not exist in the picklist table and is therefore excluded from the history tab (inner join to Picklist).  Rather than change the UI, I decided to fix the data.  Here is the sql to accomplish the same.  Note that 262147 is a ToDo.

INSERT INTO
    PickList
SELECT
    262159 , 'VBA' , 'VBA' , 'VBAVBAVBAVBA' , PickListID ,
    UserID , DefaultIndex
FROM
    PickList
WHERE ID = 262147

What's This?
  
Bookmark and Share

About Ryan Farley

   Ryan Farley is the Director of Development for Customer FX Corporation and the creator of slxdeveloper.com.

Don't miss these developer series from Ryan:


Related Content
   Updates to the SalesLogix Mobile Developer Toolkit
I've released some updates to the SalesLogix Mobile Developer Toolkit. This new release adds some fix
Posted on Apr 10, 2013 by Ryan Farley to Ryan Farley's Blog
 
   Free Tool to Retrieve SalesLogix User Names and Passwords
As a business partner we work with customer SalesLogix databases often. Along with getting a database bac
Posted on Feb 25, 2013 by Ryan Farley to Ryan Farley's Blog
 
   Introducing the SalesLogix Mobile Developer Toolkit
I am very pleased to announce a new & free open source tool from Customer FX named the SalesLogix Mob
Posted on Nov 13, 2012 by Ryan Farley to Ryan Farley's Blog
 
   Passing Connection Information from SalesLogix Web to Another Website
When integrating another system, application, or website with SalesLogix there are many options. If you&#
Posted on Dec 22, 2011 by Ryan Farley to Ryan Farley's Blog
 
   Extending Sublogix Entities
If you've followed my posts on Sublogix, or even better, given Sublogix a spin, you'll know that
Posted on Nov 15, 2011 by Ryan Farley to Ryan Farley's Blog
 
Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2013 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register