Forum Post: Query to return values in a picklist as an array?

  • Thread starter Thread starter gwf
  • Start date Start date
Status
Not open for further replies.
G

gwf

Guest
Hello all, I want to build a custom pie chart in JS (using Raphael) that will show the breakdown of records of one object by values in a picklist. Is there a good way to get the picklist values in an array so that I can then get the count of records for each value and also use the values (not the codes) to populate the legend? The array needs to be dynamically generated since values can be added to the picklist as new records are uploaded, so I need to recreate the list of values each time the chart is generated. I.e., a picklist fields has the values "A," "B," and "C." The piechart will show the breakdown (20 records have value "A," 5 have "B," and 10 have "C") and the legend will list each value. When a new record is uploaded and adds "D" as a value in the picklist, the chart will then include "D" in the breakdown and legend. So is there a query to return the values in a picklist as an array? Thank you, Greg

Continue reading...
 
Status
Not open for further replies.
Back
Top