Tag: Picklists
How to Retrieve Picklist Data in InforCRM: A Quick Guide
Learn how to efficiently retrieve picklist data in InforCRM, including a detailed explanation of the picklist structure, SQL queries for header rows and items, API usage, and custom scripting examples.
Changing the Regarding Picklist on the Activity Dialog from a Single-Select to a Multi-Select Picklist in Infor CRM
I've mentioned before how customizing the activity dialog in the Infor CRM (Saleslogix) Web client is not like other forms. The Activity Editor dialog is a Javascript/Dojo widget, not an ASP.NET based QuickForm you can edit in the Application Architect. Let's take a look at how you might change one of the existing controls to work differently. In this...
SalesLogix web – retrieving a picklist value client side
How to get a SalesLogix picklist's value using client side code in the SalesLogix web client.
Picklist Column types – Dispaying ticket status in the SalesLogix LAN datagrid
I recently had to build a datagrid displaying ticket information, including the current Status value. Under tickets, the Statuscode field contains the itemid from the picklist table rather than the actual text value as is stored for the Account, Contact or Opportunity areas. If you've only dealt with picklists in those other areas, it could cause some confusion when trying to determine just how to display the Ticket status text value in a datagird, however using the picklist column type makes this very easy.
Using Picklist data revisited
Back in January, I posted about the SalesLogix picklist data structure, and outlined how to use the data found in the picklist table to populate other controls such as comboboxes and listboxes. You can find that article here.) If you are performing customizations to version 7.2 or later of SalesLogx, this processes can be greatly simplified by using Application.Picklist instead of directly querying the database.
