Representation of a list item within the SharePoint API.

learn more… | top users | synonyms

18
votes
2answers
12k views

SPList.Add() vs SPList.AddItem() SharePoint 2010

Using some test code i found out that SPList.AddItem() executes slight faster then SPList.Add() - does anyone know why is it so ? DateTime start = DateTime.Now; SPList ...
16
votes
1answer
21k views

How to get a SPFieldLookupValue from an SPListItem?

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the ...
13
votes
2answers
22k views

Safest way to get a date from Sharepoint into a C# datetime field, using object model?

If I have a Sharepoint list item with a date field. How can I get the field value populated into a c# datetime object? For example: DateTime validfrom = Convert.ToDateTime(item["validfrom"]); ...
9
votes
2answers
206 views

Efficient way to retrieve all list items

I am retrieving all items from list containing around 4000 items. But it seems to take longer time to fetch all items which is ~15 to ~22 seconds. Is there any best way to fetch all items from list in ...
8
votes
2answers
792 views

Is it possible to create a “Link to a Document” in a Document Library using a CAML Batch Command with UpdateListItems?

I have a Document Library in WSS 3 which has the "Link to a Document" content type enabled, and I want to use a batch command (via lists.asmx updatelistitems) to create a series of links. Here is the ...
7
votes
2answers
17k views

Fastest way to retrieve an item by title?

Currently I am using a foreach loop to find the item I want by its title using the following code: SPList list = web.Lists.TryGetList("DocumentLibrary"); foreach ...
7
votes
4answers
45k views

How to set ListItem Lookup Field value

How do I set a ListItem's Lookup field using code? SPFile file = list.RootFolder.Files.Add(destUrl, iStream, true); SPListItem item = file.Item; item["DocumentID"] = DocID.ToString(); ...
7
votes
2answers
7k views

PowerShell: Update People Picker Field with domain\Username

I'm trying to get this to work in PowerShell: $spListItem[$ppField] = "domain\username" $spListItem.Update() This gives me the following error: Exception calling "Update" with "0" ...
7
votes
3answers
3k views

Multiple Lookup field , how to return better deliminators using object model?

I have a multiple lookup field, and when I do this: string myValue = oItem["MyLookupField"]; I get this string back: [id];#[displayText];#[id];#[displayText] or a real example: "5;#C3;#15;#P3" ...
6
votes
3answers
14k views

Cannot get field value of list item through JavaScript

I try to get the value of a list item (that is currently selected). I know that I must load it into the context but even with loading the field explicitly I get the following message. Microsoft ...
6
votes
1answer
3k views

Attach a file to the list item

I attach a file to the list item when it is updating and when new item added. Additional condition when item updating - if the file already exists, remove it and replace the new one. I receive events ...
6
votes
1answer
2k views

ItemUpdated event handler runs four times

I have a list in the rootweb, and a list in a subweb. I want to update/add when something changes in an item in the subweb. This method is invoked in an ItemUpdated event receiver. The problem is that ...
6
votes
3answers
384 views

SPList.GetItems(view) vs SPList.GetItems(query)

Which solution from the two is the most efficient one: 1. Using SPList.GetItems with a given view as a parameter 2. Using SPList.GetItems with a given query as a parameters and then retrieving from ...
6
votes
1answer
6k views

How to get Attachment URL Programatically From Sharepoint ListItem?

How to get Attachment Full URL Programatically From Sharepoint ListItem? Explanation: I have adding new item with attachment. Now i have to bind that attachment link to grid. When click on that link ...
6
votes
2answers
2k views

How can I tell if a document is 'being published'?

I need to use the relevant event receiver to tell if a document is being published, is this possible? I will settle for has 'just been published' - i.e. I have no preference between itemupdating and ...
6
votes
2answers
2k views

SPListItem.SystemUpdate updates SPListItem.File.ModifiedBy

As can be seen from the debug image when I call SystemUpdate(false) of a SPItem, that SPItem's File object's ModifiedBy attribute changes to "SHAREPOINT\system". Sorry, it's a bit weird way to ...
5
votes
3answers
4k views

Invalid SPListItem. The SPListItem provided is not compatible with a Publishing Page

Whenever I try to save or publish or check in the web-interface, I get this error. The test-environment did not have this issue, and I've only added a single web part to the page and tweaked the CSS ...
5
votes
3answers
6k views

How to get SP.Folder for SP.ListItem in SharePoint 2010 JavaScript Client Object Model?

I have a custom button on ribbon for document library and need to disable it if current SPListItem is an empty folder. To disable button I use EnabledScript attribute of CommandUIHandler. I can get ...
5
votes
1answer
54 views

How to set calculate column result in another item

I made a list for Event Planning, the columns name are: Row(to change the order) Subject start time duration end time(sum of start and duration) I need to copy each end time to start time ...
5
votes
2answers
580 views

SPQuery returning different before and after using RunWithElevatedPrivileges method

I am having a huge problem here. I am executing a query looking for a SPListItem, when I execute this query with user identity it works well, retuning the fields "Author" and "Editor" that I need. ...
5
votes
1answer
527 views

Get SPListItem from LINQ

I have used SPMetal to create a data context. I can query my lists. The queries return an object of the type of list that they are in. Is it possible to convert this type into a normal SPListItem ...
5
votes
2answers
1k views

Problem with CAML SPQuery ItemChildCount result

I know that this query works fine SPQuery query = new SPQuery(); query.Query = "<OrderBy><FieldRef Name='ItemChildCount' Ascending='FALSE' /></OrderBy>"; But my ...
4
votes
2answers
170 views

People or Group field returning semicolon hash then Name

In querying the properties of a list item, I found that returning the value of a people or group field that the value would be returned in the form 1;#George Grainger Using the code: ...
4
votes
2answers
9k views

How do I get the url for attachments on an SPListItem using C#?

I have an SPListItem for which I would like to get the urls of all its attachments. The urls will be used as part of my custom web part which has an SPList of SPListItem items.
4
votes
2answers
11k views

How to read a User field value for a list item

I've got a content type that contains a filed of the type user. When I want to read the ListItem I just get a string containing the users name instead of a object which contains Name, Username, E-Mail ...
4
votes
3answers
2k views

Get SPListItem by UniqueID

I'm trying to retrieve AN SPListItem from his UniqueID. I can have his document library url like http://mysharepoint.be/MYDOCUMENTLIBRARY but when i try to get the SPList from the name ...
4
votes
2answers
5k views

Locking SPListItem for entirely server-side update

I am using code similar to the following to apply an update to an SPListItem, after necessarily elevating to System privileges on said item. Because this can be called multiple times for the same ...
4
votes
2answers
205 views

Editing list item with custom field creates a new list item on current date and time

Based on How to add new field to custom list (See edit!) It is a different question relating to the above so thought I'd create a new question as the above was technically answered. But after adding ...
4
votes
1answer
204 views

Delayed Writes & Implications for Cross-Process Synchronization

Simple scenario: OWSTIMER creates a new SPListItem, populates it and calls .Update(). It then fires an HTTP request over to w3wp.exe (front-end app-pool) to invalidate an in-memory cache held there. ...
4
votes
4answers
324 views

Does SPList.ItemCount equal SPList.Folders.Count plus SPList.Items.Count?

I'm trying to do some inventorying of SharePoint 2007 content and have been scratching my head over this for a while now. I understand from MSDN that SPList.ItemCount counts all folders and items ...
4
votes
0answers
90 views

Can you add comments to an append-only field in a list in Sharepoint 2010 using C#? [duplicate]

Possible Duplicate: Can you programmatically add comments to an append-only comment field in a custom item list using C#? Posted on stack exchange first, then I found this Sharepoint ...
3
votes
3answers
4k views

Find creation time for list elements (including documents)

I know SharePoint has some hidden fields for list items. I need to check the timestamp for when a list element was created, is this possible? The reason is I must allow the item to be edited for the ...
3
votes
1answer
770 views

How can I make sure that only one of two fields is filled out (ListItem)?

I have custom SharePoint list with several fields. Two of the fields are TargetPage and ExternalURL. At the moment the user is allowed to fill out both of them if he want to, and I want to deny that. ...
3
votes
7answers
7k views

ArgumentException when trying to access SPListItem value

I have a tool to update all items in SP (link replacement). The tool works most of the time but sometimes it throws me an ArgumentException ("Value does not fall within the expected range."). Here is ...
3
votes
2answers
8k views

Set default value in a document library column via Powershell?

I'm looking for a powershell script that allows me to set the default value for a column in SharePoint. Thanks
3
votes
4answers
2k views

What is the best way to retrieve random item?

I would like to retrieve random item from SharePoint list. I have these approaches: Get random index and use list.items[randomIndex]. But I think that I retrieves all items from DB in this case. ...
3
votes
2answers
36 views

List item field hidden from Edit form

I have a content-type consisting of two columns: Title and Description. Title is required and a single line of text Description is optional and consists of more lines of text (Rich text editor). ...
3
votes
2answers
58 views

Problem with bulk items insert in SPList (works fine for 200 but not if item exceeds )

var itemArray = []; for (var i = 0; i < data.length; i++) { var items = data[i].split(","); downloadID = items[0].trim(); noOfDownloads = items[1]; ...
3
votes
1answer
950 views

Add New List Item With Attachment Via Excel VBA

I have users that have a schedule template in Excel (2010). I'm wondering how I can code via Excel VBA to create a new list item and attach the Excel worksheet they are using that contains the ...
3
votes
2answers
3k views

Help with getting the value of a look up field

Currently, I am using an ajax request to access the list items. The fields that are not lookups come as expected but the lookup fields come across as an ID of the object that corresponds to its ...
3
votes
1answer
36 views

Monitoring list item fields for a certain span of time

how to monitor a list item field or document library metadata for a duration of say 20 days whether it was modified or not. (tracking only one field not the entire list item modified date) the ...
3
votes
4answers
860 views

Set permissions on an item depending on column value

Is there anyway to set permissions on an item depending on a column value? I was think about creating a feature to do this but do I have to?
3
votes
1answer
2k views

Updating a SPFieldMultiLineText field

I have an SPListItem. I have a field on the item of type SPFieldMultiLineText. How can update the value of that field?
3
votes
1answer
3k views

set separate url and description for URL-field via javascript

I've got a list item with a field of type URL. As you know, an URL-field consists of two parts: a description and a URL. Using javascript to update a field that consists of one part is easy, you ...
3
votes
1answer
537 views

Formula to save seconds and Milliseconds in Sharepoint List for DateTime type column

is there any way to hold datetime with seconds and milliseconds in sharepoint list where column type is 'DateTime'. currently my list column saving as below 1/9/2014 6:30 PM but i need to show it as ...
3
votes
1answer
13k views

How to retrieve all items from a list (with custom fields) by javascript object model

I need to get all my custom fields from my list by Javascript Object Model.. The code I wrote down is this: var items; $(document).ready(function () { ...
3
votes
1answer
334 views

SPListItemVersionCollection - iteration performance

This question is related to my issue described here: SharePoint 2010 Performance troubleshooting On SP 2010: Does anyone knows if there is some performance limitations while using ...
3
votes
1answer
3k views

loop splistitem in folder in powershell

I'm trying to loop all splistitem in a folder of a library. I can get my library and have folder but i'm not able to get the items inside the folder. When i display the listitem for folder, i've the ...
3
votes
2answers
358 views

Get Notified on List Item Changes - not using email

I'm searching for an easy way to display the latest changes of a sharepoint list. Situation: one huge list (10k entries) with a lot of daily changes (lets say 100). Target: Display the changes during ...
3
votes
1answer
1k views

Get last major published version of items returned as DataRow (from SPSiteDataQuery)

Does anyone know the solution for this? If I'm querying items by SPSiteDataQuery I receive a DataTable with DataRow objects. I could fetch the current version of an item and check if it ends with ...