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.

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!