How do you extract or print the values of a pick list?

Version 1

    Details

     

    How do you identify and print a list of values from a pick list?

     


    Resolution

    You can examine the pick list to identify the table you need to build your query from.


    1. First locate the pick list you want to get the values from.

    The column "Object Name" shows what the list is pointing to.


    You can also examine what the value for 'Get list data from' states, this is the business object.


    Based on the information above, the SQL query would be "select * from DSMRequestType"

    You can also build and run an 'export to excel' action to get the values as well.