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

ABOUT THE AUTHOR

Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix, now Infor CRM, since 2001 and believes in sharing with the community. His new passion for CRM is Creatio, formerly bpm'online. He loves C#, Javascript, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!