Picklist Defaults in the SalesLogix 7.5.3 web client

SalesLogix allows defining a default value for a picklist.  Normally when a default value is set, any screen that utilizes the SalesLogix picklist has the default value pre-populated in the picklist control.  Starting in SalesLogix 7.53, the web client no longer automatically honors those default values. 

Picklist management in the SalesLogix 7.5.3 web client is now available within the web client interface under Administration…Picklists.  When you open a given picklist  in this interface you will see an option on screen called “Apply options to Web pick list”.  This setting must be checked in order for the default picklist values to populate a picklist control now in the SalesLogix web client.

 

Setting this checkbox actually updates an existing picklist table field.  When the box is checked it sets the PICKLIST.ID field to 1 and unchecked it is set to a 0.

You can manually chnage this setting with a T-SQL statement such as:

UPDATE PICKLIST SET ID = ‘1’ , MODIFYDATE=getutcdate(),MODIFYUSER=’ADMIN’ WHERE TEXT=’Custom List’  AND PICKLISTID = ‘PICKLISTLIST’

or

UPDATE PICKLIST SET ID = ‘0’ ,
MODIFYDATE=getutcdate(),MODIFYUSER=’ADMIN’ WHERE TEXT=’Custom List’  AND
PICKLISTID = ‘PICKLISTLIST’

Note: If you do change this setting via SQL you will need to log out of the SalesLogix web client and then back in to see the change.  If you make the change in the web client interface in the Manage Picklist screen, you do not need to log out.

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

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!