Representation of a list item within the SharePoint API.
9
votes
2answers
7k 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"]);
...
7
votes
1answer
5k 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 ...
7
votes
3answers
1k 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"
...
7
votes
2answers
447 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 ...
6
votes
1answer
2k views
Attach a file to the list item
I attach file to the list item when it updating and when new item added. Additional condition when item updating - if the file already exists, remove it and replace the new.
I receive events ItemAdded ...
5
votes
1answer
1k 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 ...
5
votes
1answer
144 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 ...
5
votes
2answers
981 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
2answers
718 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
1answer
807 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 ...
4
votes
3answers
5k 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 ...
4
votes
3answers
2k 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 ...
4
votes
2answers
2k 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
199 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.
...
4
votes
2answers
171 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
180 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
0answers
74 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 ...
4
votes
1answer
196 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 ...
3
votes
1answer
389 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
4answers
10k 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();
...
3
votes
2answers
2k 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" argument(s): ...
3
votes
2answers
2k 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 ...
3
votes
4answers
226 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
205 views
Caching SPListItems with Permissions
I have a versioned list that I need to cache list items for.
The effect of which being:
If a user has permission to view non published items the cache can return the item pending approval.
...
3
votes
1answer
598 views
Setting the DisplayFormURL of a CalendarView item to an absolute URL, SPCalendarView control
Background:
I have a WebPart that makes use of the SPCalendarView control and in it I add items (events) dynamically from different Calendar lists from multiple sites.
like this (please note that I ...
3
votes
2answers
1k views
Updating a ListItem that another user has edited
I have an event receiver that creates/updates/deletes publishing pages in a publishing library.
In ItemUpdating, I get a handle to the page's underlying ListItem, change some of its properties and ...
3
votes
1answer
348 views
How can I undelete records from a SPList programmatically?
There is a SharePoint List from which many records have been deleted using CAML. The records are available in the Recycle Bin.
Is there an way to recover the records using scripting/CAML etc ?
Since ...
3
votes
2answers
258 views
SP2010 splistitem AND accessing css or style
I have an event receiver which adds splistitems from child sites to the parents site list (in a calendar). How do I access the css or style of an splistitem? I am wanting to color code the different ...
3
votes
1answer
37 views
Get actual item from SPRecycleBin
Similar to this question, I need to permanently delete only specific items from the recycle bin. I need to know more than just their names, however, and SPRecycleBinItem seems to have only have a ...
3
votes
2answers
2k views
OnWorkflowItemChanged not firing when using SPListItem.Update()
I am experiencing a very weird behavior: After using SPListItem.Update() the OnWorkflowItemChanged is triggered (so the title is misleading), but sends the workflow into a sleep state it never wakes ...
2
votes
2answers
515 views
How to find a file with name = X in a SPList
Looking for recommendations. Have a file in a document library with name x.txt. In a workflow code behind, I need to get the file to read its contents. What is the best/most efficient way to do ...
2
votes
4answers
469 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.
...
2
votes
3answers
1k 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 ...
2
votes
6answers
3k views
How can I auto-increment a column?
I am working on a solution where I have a list with a column named LogIDNumber. For each new entry in the list, I would like to increment the LogIDNumber by one. I could use the ID generated by ...
2
votes
3answers
2k views
Attempt to get property CheckOutType of SPFile cause 'System.NullReferenceException' exception
I have a strange situation: If the "Require Check Out" and "Create Major Versions" options are switched on for the current Document Library, then when I try to get the CheckOutType property I receive ...
2
votes
2answers
2k 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.
2
votes
2answers
42 views
Adding list item when user does not have permissions question
I am trying to programmatically add a list item to a SharePoint list. The code works fine when executed by a user with contribute permissions, but does not work when a user has view only. Funny thing ...
2
votes
1answer
89 views
Why do I have 2 ways of retrieving an average rating? Which one do I choose?
It appears that, on enabling social rating against my list for my custom content type, I now have 2 extra fields for each SPListItem in my list:
AverageRating and RatingCount (as explained Blog Link)
...
2
votes
2answers
266 views
Disposing item.web
I have read this article and known which objects should be disposed. But I doubt whether oItem.Web returns the same object as spcontext.current.web object or it creates new one. If it creates new, I ...
2
votes
1answer
812 views
How to read an 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 ...
2
votes
2answers
47 views
Retrieving the highest value from list
My question is regarding retrieving a value from a sharepoint list. Basically I have a list with some data. One of the fields in the list is a text field with numbers.
So what i want to do, i want to ...
2
votes
1answer
303 views
Parse pasted images from Outlook emails as attachments in Sharepoint list
I have a Sharepoint list with incoming email enabled, and an email event receiver to create items out of incoming emails. Once an email is received, it sends an email back to the sender with the ...
2
votes
1answer
511 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?
2
votes
1answer
580 views
SPListItem removing HTML attributes?
I want to add this to an SPListItem HTML field (Multiline text)
<a href="#" onclick="OpenDispPage('Table 1.1', 'table');" >Text</a>
and this is what SharePoint makes out of it when I ...
2
votes
1answer
297 views
How to update SPListItem in ItemFileMoved?
I have a document library. In ItemUpdated I move the file to a different location (based on date) and I want to add some metadata in ItemFileMoved to the file's new columns (which I added). The ...
2
votes
2answers
69 views
Getting latest datetime from a splist
I have sharepoint list with data and one of the columns contains date ... how can i programmatically retrieve the latest date, the field is a Date And Time type?
2
votes
2answers
841 views
Can an event receiver update a list item before the alert email is sent?
I have a requirement to expose a list item's ID value on the "DispForm.aspx" form and all alert emails for a particular list.
SharePoint is very "protective" of its IDs (or counter fields) and it ...
2
votes
1answer
244 views
Duplicates of SPListItem when two quick requests occur
We got code, running on page load. That code asks certain SPList for its items by CamlQuery, which gets only items with specific (current) user in one field (field A) and with some value in other ...
2
votes
1answer
703 views
Search Optimization on SPListItemCollection
I have an SPListItemCollection (Thread Discussion Collection) that consists of almost 20,000 items. Each SPListItem (Thread Discussion) on the SPListItemCollection contains a sub SPListItem(Thread ...
2
votes
0answers
26 views
Bulk file upload creates multiple versions of all files except last file
I have an interesting (well to me anyways) problem here. I am doing a code based mass upload of documents into a SharePoint library with a twist. The twist is that the file's last modified date ...
