How can you get distinct values from a SharePoint List column using JavaScript without a huge performance hit?
A simple example would be appreciated :)
Assuming that your field is a Choice/MultiChoice field without "Fill In Choices" enabled then you can use get_choices. If it does have fill in choices and/or is a different field type then I don't think there is an option apart from brute force (iter over all items getting unique values). http://spdailytips.blogspot.com/2011/11/retrieve-all-choice-field-values-using.html
| |||||
|
I personally prefer /_vti_bin/listdata.svc. For example to retrieve only Title och Status from 100 first Tasks:
See more on my blog: $select, $.getJSON and listdata.svc, updating with listdata.svc | |||
|