Representation of a list item within the SharePoint API.

learn more… | top users | synonyms

2
votes
5answers
3k views

List Item Timeout

I am trying to open/close the a custom list item with 11500 items but I am getting an error which seems to be a timeout error, i checked the logs and found 'Unable to execute query: Error 0x80131530'. ...
2
votes
2answers
1k 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
377 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
1k 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
43 views

How do I determine why some records within my sharepoint list are read only?

I'm running a snippet of code to update my SharePoint List through Access 2013. It seems that my code works for some records, but other records will give me the "Cannot update. Database or ...
2
votes
0answers
58 views

SPQuery returns wrong values

The Setup I have a list with 2 extra columns. Target Audience: Choice (Relevant/Everyone) Tags: Managed Metadata field (multiple) When I choose in the "Target Audience" field "Everyone", this ...
2
votes
1answer
85 views

Rest api - Query Multiple Sharepoint lists for a listitem with a given property value

I have 3 sharepoint lists with the same columns. I need to fetch the list items with a particular property value, eg. CustomName property with value 'Test' from all the 3 lists. Instead of looping ...
2
votes
1answer
44 views

SharePoint 2010 keywordQuery

I am using the keyworkQuery class to fetch some items from a Sharepoint 2010 list. I need to fetch also the Attachments for each item how can I do?. I tried: KeywordQuery kw = new KeywordQuery(proxy)...
2
votes
0answers
161 views

SPListItem.BackwardLinks equivalent in CSOM, JSOM, or REST?

In the Server API for SPListItem there is a property called BackwardLinks that returns a collection of items that link to the item. I don't see the same property in CSOM, JSOM, or REST. Is there a ...
2
votes
1answer
734 views

“User cannot be found.” Error While Updating List Item

I'm experiencing a weird error while trying to update the author and editor on some files in a site, but not all, and the behavior is strange and inconsistent. The code: SPListItem item; int newID; ...
2
votes
1answer
805 views

Document Library items not updating via UI or code. System metadata (last modified, modified by, etc.) updating

I am having a strange issue with one of my Document Libraries. It is the document library created by the publishing feature "Documents." Here are the symptomps and what I have done so far. Any help ...
2
votes
0answers
111 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 ...
2
votes
1answer
314 views

How to import one single row of data from excel to one list item in a SharePoint 2010 list?

I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
2
votes
0answers
223 views

Is my Object Casting Model acceptable?

I'm creating a SharePoint application, and am trying some new things to create what amounts to an API for Data Access to maintain consistency and conventions. I haven't seen this before, and that ...
2
votes
1answer
187 views

SPListItem update yields ItemUpdated/ing Numbering Scheme not found

I've written a console app that searches items in a SP document library (MOSS 2007) for a specific condition and updates the value in a column for each item that meets the criterion. I run the console ...
1
vote
4answers
52 views

Get SPListItem ItemsData

I have the list of items in object SPListItem item. Is it possible to extract certain data from the ListItems property? The reason I want to do that is because I have a FieldName "AssignedTo" which ...
1
vote
3answers
9k views

Getting specific SPFile from document library

I have a Document Library called "x" with file named "y". I am curious what the best way to get the SPFile object for the specified SPListItem. Currently I am using this: SPContext.Current.Web....
1
vote
3answers
4k views

Getting “Object reference not set to an instance” but column name exists

The NewsCaption field exists (both display and internal name is NewsCaption). I even saw it exists when I went to watch window and show this field listed in the SchemaXML for the fields element. I am ...
1
vote
2answers
6k views

Getting an ItemCount with filtering in SP2013 using REST api

I am attempting to return an integer (itemcount) of the items within a SP2013 list. I have done this easily using the stock standard json method. However I have a need of counting the splist items ...
1
vote
2answers
2k views

Add/Copy SPListItem object to Sharepoint List

explanation: I have fetched list items based on conditions. Like this. var query = from SPListItem oItem in splist.Items where Convert.ToDateTime(oItem["Status"])....
1
vote
3answers
5k views

How to programmatically restart a workflow

I have a workflow linked to my list. Is there any programmatically way to select a list item and restart the associated workflow? Something like: SPListItem item = List.Items.GetById(1); item....
1
vote
7answers
6k views

Value does not fall within the expected range. But the field exist

I have the following problem. I have a list with a custom content type, when programmatically I want get an information from my SPListItem I get the following exception: Value does not fall within the ...
1
vote
4answers
3k views

How to delete an item on ItemAdding

I want to performe some Action on ItemAdding. I have a Custom List that reacts on Item Creation. In particular on Item Adding performs some action using the After Properties.. If, at this level, i ...
1
vote
2answers
472 views

ListItem Versioning Differences

Does anyone know how to programmatically determine if any non-system fields have changed between ListItem versions? I realize that I could iterate through the fields between each version and if I see ...
1
vote
2answers
1k views

How to foreach through a list and get distinct values from specific columns C#?

I'm able to loop through a list on sharepoint and get the information I need from selected columns, but how would I loop through a list and get only distinct values from a column in C#. For instance ...
1
vote
2answers
786 views

spfielduservaluecollection.remove not working

I want to remove the user from the list item from the column of type person or group and it is multi-valued. My code is: private void DeleteUserFromList(SPUser userDeleted, string fieldName,...
1
vote
2answers
3k views

Unable to update item using powershell when event reciever is enabled

I have a powershell script that I am using to update some list items programatically. It seems to work as I expected when I disable the event reciever that is associated with the list however when I ...
1
vote
3answers
1k views

Proper way to evaluate/get status of boolean field when looping through SP List with code

What is the best way to do this when looping a list? I have tried to evaluate it with something like this but it wont let me evaluate bool as an "if" condition if (item["ShowTitle"] == true) //do ...
1
vote
2answers
227 views

Is it possible to update the searchindex for only one item?

Is it possible to update the searchindex for only on specific item. I'm search some tasklists through keywordsearch and showing them in a webpart. Then I have a custom action which changes the status ...
1
vote
2answers
500 views

Updating an SPListItem without knowing SPSite or SPWeb

I'm building a custom web part that is running an SPSiteDataQuery. I will be running this query across all site collections, and displaying the results, together, in 1 web part. Users interacting with ...
1
vote
2answers
75 views

Trigger an email when list item is updated-without using ItemEventHandlers

I need to send an email to a designated person [ Windows-AD authentication account - john@mycompany.com] whenever there is a change in the list item of my SP 2010 List. I cannot use the event receiver ...
1
vote
1answer
36 views

Drop Down Site column has no value in edit form

My list has a drop down Site column. In the view you can see that most of the items has a value for this column. Even when you go to display item form you can see that the field has right value. ...
1
vote
1answer
178 views

Item Field returning value with hash character in Itemupdate

I am trying to get value of item field from the list. The field is a lookup field with integer value. When I am trying get the value it is coming like 9;#9 (shown below). But I need only 9. web....
1
vote
2answers
1k views

SPListItem.Attachments - what type cast?

When iterating through a SPListItems SPAttachmentCollection what type cast am I supposed to use? SPFile or SPFileStream or something else? I want to display the item's filename and when it was ...
1
vote
3answers
5k views

Get Sharepoint data synchronously with JavaScript

I was wondering is there some way to get list items form SharePoint with JS synchronously. All methods I've found required to specify a callback method. As I am building a custom JS validation for ...
1
vote
1answer
587 views

Customize AllItems.aspx

I have a list "Projects". Each ListItem stores which users are working on that project. I have 2 groups within SP - "ProjectManagers" and "ProjectMembers". Now I want to customize AllItems.aspx ...
1
vote
2answers
218 views

GetItems(cQuery)

The following code seems to be working. Basically, I have multiple items in a document library and I need to run a cleanup PS. Do I need to add Dispose as I am not running under the Using context? $...
1
vote
1answer
89 views

Identify Whether Document is Published Or not

I have to call SP search Api for documents in document Library applying filter for only bring such documents which are published and having specific content type . Is there any specific property for ...
1
vote
3answers
324 views

JSOM 2013 Get Item from List containing all fields

I'm trying to get a specific list item (by id) using JSOM and want to get all fields in this item. Though, for some of my fields I get the error that I need to request the field (which would be done @ ...
1
vote
1answer
79 views

Get SP list items in select tag

I am trying to get list items in select tag but it is not working.I have tried to fix this in many different ways but nothing works. my code: <select id ="listBox" multiple="multiple" style="width:...
1
vote
2answers
959 views

RegEx to validate and replace invalid file name characters from a custom web part file upload control

Scenario: I have a fileupload control in my custom webpart that attaches the uploaded files to the list item. The attachment code is given below: private void UploadAttachments(Helper ...
1
vote
2answers
107 views

Latest unique item from a SP list column

I have a SP2010 list.This list has a choice column. I want to create a view with the unique items(latest one) from this column. How to achieve this?
1
vote
2answers
466 views

delete sp.listitem in client object

I've an issue to delete document in a document library. I did not get any exception but document is not getting deleted clientContext.Load(oldItem.File); oldItem.DeleteObject(); oldItem.Update(); ...
1
vote
1answer
1k views

Alternative to CSOM ListItem.get_item

The only way I know to load a sharepoint list via Javascript is to load it and on the current list item: var value = currentItem.get_item(columnTitle); I want to be able to load an item and on the ...
1
vote
3answers
3k views

SharePoint 2013 Webpart - Multiple file upload

I want to add the multiple files functionality to my custom webpart in C# .NET 4.5. I want the same functionality as the out of the box multiple files add feature when you create a list item via the ...
1
vote
1answer
3k views

How to get the sharepoint website url in a workflow from the current SPListItem?

I am using sharepoint 2010 and have created a workflow in vs. In this workflow I create some tasks and fill the title, bodytext and assign it to a user or group. In the bodytext I add an hyperlink as "...
1
vote
1answer
3k views

Odd and Even list item color

i saw a sharepoint where its list item as a background color (blue) for odd list item number and another (white) for even numbers. I dont know where i can set this. I looked into designer and i could ...
1
vote
1answer
1k views

Export-SPWeb with Where Clause to filter List Items?

I am trying to export list items to a local folder but I only want certain items, not the complete list.Is this possible? I have tried to iterate through the SPListCollection with the "Modified" ...
1
vote
4answers
2k views

Returning a SPListItem in conjunction with RunWithElevatedPrivileges

* *Clarification. Application == Site Definition. Direct Database access is out the window ** I've created an application for SharePoint that utilizes some new approaches to coding List Access. I've ...
1
vote
3answers
2k views

update SPList using csv via Powershell

knowing that is possible in PS, exporting SPList items to PS objects(link1 link2) what is the best way, to go into the other way: Create/Update an SPList from an exported csv or format-table.