Working with Picklist collections in the SalesLogix Web Client


In a previous post I talked about working with the Sage.SalesLogix.Picklist assembly to get a specific instance of a picklist item.  Today I wanted to show how to work with an entire picklist list:

The assembly offers a method to return an IList collection of all picklist items in a specific picklist.  The syntax for this is something like this:

System.Collections.Generic.IList<Sage.SalesLogix.PickLists.PickList> items = Sage.SalesLogix.PickLists.PickList.GetPickListItemsByName(“AccountType”, true);


As you can see the method is called GetPickListItemsByName.  The method has a couple of overloads.  The first parameter is always the picklist name, passed as a string.  The second optional parameter is whether to return the list sorted alphabetically, expressed as a Boolean value.

With the IList returned you can bind it directly to a control,like a list box like so:

System.Collections.Generic.IList<Sage.SalesLogix.PickLists.PickList> vendors = Sage.SalesLogix.PickLists.PickList.GetPickListItemsByName(“Vendor”, true);
cboVendor.DataSource = vendors;

Alternatively you can work with the collection to do something like so:

System.Collections.Generic.IList <Sage.SalesLogix.PickLists.PickList> statuses = Sage.SalesLogix.PickLists.PickList.GetPickListItemsByName(“Product Status”, true);
foreach (Sage.SalesLogix.PickLists.PickList status in statuses)
    if(status.Text.ToUpper()!=”AVAILABLE”) //Do something               


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!