How do I find the Picklistid for any given picklist?

Question:

I see that the PICKLIST table has all the items for the picklists. I also see that there is a PICKLISTID that says what items go with that picklist. But how do I find out what PICKLISTID matches up with (for example) the Contact Status picklist?

And I need to do this programmatically.

 

Answer:

This is how you get all the Picklist Items for a Given Picklist (Using Contact Status as example):

SELECT * FROM PICKLIST WHERE PICKLISTID IN
(
SELECT ITEMID FROM PICKLIST WHERE PICKLISTID = ‘PICKLISTLIST’ AND TEXT = ‘Contact Status’
)

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!