Wednesday, April 3, 2013
Get fields using Javascript Client Object Model
Using the Javascript Client Object Model, you can get values from a listitem.
How to use the JSOM is described here Code Project
Title – SP.ListItem.get_item(‘Title‘);
ID – SP.ListItem.get_id();
Url -SP.ListItem.get_item(‘urlfieldname‘).get_url()
Description – SP.ListItem.get_item(‘descriptionfieldname‘).get_description();
Current Version – SP.ListItem.get_item(“_UIVersionString“);
Lookup field – SP.ListItem.get_item(‘LookupFieldName’).get_lookupValue(); // or get_lookupID();
Created By – SP.ListItem.get_item(“Author“).get_lookupValue();
Modified by – SP.ListItem.get_item(“Editor“).get_lookupValue();
Choice Field – SP.ListItem.get_item(‘ChoiceFieldName‘);
Created Date – SP.ListItem.get_item(“Created“);
Modified Date – SP.ListItem.get_item(“Modified“); -> case sensitive does not work with ‘modified’
File – SP.ListItem.get_file();
File Versions - File.get_versions();.
Content Type – SP.ListItem.get_contentType();
Parent List – SP.ListItem.get_parentList();
Note: (‘LookupFieldName’).get_lookupValue() sometimes returns an array of data, especially when your lookup allows multiple values.
In that case you will need to iterate the array and get each value individually.
SP.ListItem.get_item(‘LookupFieldName’)[0].get_lookupValue(); - this will get the first item in the array.
For Arrays:
for(var i = 0; i < oListItem.get_item("LookupFieldName").length; i++)
{
alert(oListItem.get_item("LookupFieldName")[i].get_lookupId()); // or get_lookupValue()
}
Subscribe to:
Post Comments (Atom)
Hi: Thanks for your great post. I have a query on it. Is it possible to get the version number of a specific column (for example the Title column) for a particular row ?
ReplyDeleteFor example:
SP.ListItem.get_item(“_UIVersionString“);
returns the version number of a row (SharePoint list item).
But i want something like:
oListItem.get_item('Title').get_item('_UIVersionString');
Thanks,
Zakir
Hi Zakir,
ReplyDeleteI don't believe SharePoint stores a version number for each individual field, I believe its only at the row level.
Why do you need a column version?
Kind Regards
Chunkyfeather
Basically I have a requirement to mark the recent changes value of field. For example I have a SP list containing student information with fields student name and address. Now I want to mark last three days changes on both student name and address field for all rows. How about SP list revision history ?
DeleteThanks for your time.
Hi, Did you find any solution ? Thanks
ReplyDelete