SPList represents a list on a Microsoft SharePoint Foundation Web site.

learn more… | top users | synonyms

0
votes
0answers
22 views

Check for mandatory fields while saving Sharepoint Item programmatically

I have a Mandatory field in a list. I need to save the item and not create the item. I need to implement the it using custom JavaScript and not use the save button on the new form. Also need to ...
1
vote
1answer
18 views

Modify list item field using PowerShell

I have a list field that stores an XML string. I am trying to get the XML contents and modify a particular tag in the XML like so: foreach($item in $list.Items) { ...
1
vote
1answer
25 views

Get Checked out items in a document library

I have a document library which has 18000 items. When I go to the All Site Contents page, I see 18000 items against the document library name. But when I query the items in C# as foreach(SPListItem ...
7
votes
2answers
91 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 ...
0
votes
0answers
17 views

View filtered on SPUser fast in Sharepoint display but slow in getItems

Sharepoint 2010 Foundation : I’m used to have some surprises with Sharepoint but since some days, I have a real strange one. One of our clients has problem of response time in our applications… I ...
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.
1
vote
1answer
49 views

Refresh parent page after closing list item dialog

I'm trying to refresh the parent page of a list when closing the dialog of a list item. Is there a way to achieve this with javascript somehow? I inspected the button in the DOM and tried to write ...
0
votes
0answers
20 views

Save Conflict error and item added twice into list

I am trying to create a list which deletes all the listitems and then adds site collection and subsite details to the list. How ever i am getting save conflict error when i execute this code in DEV. ...
0
votes
2answers
26 views

Check if required fields are filled or not in SPList programmatically

I want to check if required field in SharePoint list is filled with data or not? Which method or property should i use?
0
votes
0answers
19 views

SharePoint 2010 - can't Check In List Item or View List Settings

I had an issue where I could use the site normally, but at a certain point I was unable to check-in List items. And when I went to List Settings I would get an ASP error. The problem turned out to ...
0
votes
0answers
21 views

compare the fields on gridview with sharepoint list and and add new gridview items store in sharepoint list

i am new to programming. i have a requirement where i have to store items in the gridview to a sharepoint list on page load event. but before storing on every page load. we have to compare if the ...
0
votes
1answer
79 views

Why is my list total showing as “Count= undefined”?

I'm updating a view on an existing list programmatically but I can't get the aggregation to work correctly. I'm setting it as follows (the values are pulled from an xml site definition): if ...
1
vote
3answers
426 views

Get List by “InternalName”

I'm trying to use the SharePoint 2013 JavaScript Object Model to retrieve a List via an internal name equivalent. SPList doesn't have a Name or Internal Name property. It is referred to by the ...
0
votes
3answers
36 views

How to do a real time research in a SPList from a Textbox

I'm working on SharePoint 2010 (with Visual Studio 2010) for an internship and I would like to do a real time search in a SPList from the value in a textbox. I have something in mind like Google's ...
0
votes
0answers
104 views

Customize drop down list with jquery

I'm using SharePoint 2010 and trying to limit the choices in SharePoint SpListFilterWebPart filter, using jquery. The filter has around 40 values to choose from (stored in SharePoint as list), but ...
0
votes
1answer
175 views

_ModerationStatus on list items is always draft from SPQuery

I am querying for list items in a timer job. The list has moderation enabled. It has various list items that have different approval status (e.g. scheduled, approved etc.). However the query always ...
0
votes
3answers
1k views

JSLink set in list definition (schema.xml) not being loaded

I have created a custom list definition and detailed in many articles across the net I have specified my file in the JSLink property of the view. For some reason it is no longer working. <JSLink ...
0
votes
1answer
814 views

SharePoint: Move SPListItem inside folder to root and set lookup field value

Given a custom list with folders for countries: ListA ---FolderA (Title: "USA") ------Item1 ------Item2 ------Item3 ---FolderB (Title: "Switzerland") ------Item4 ------Item5 ------Item6 Given a new ...
6
votes
2answers
1k views

Is it possible to update a list's icon?

Is there a way to update a list's icon? I was looking to use SPList.ImageUrl, but this is read only. The problem is that I've updated a list definition's icon; unfortunately there several list ...
0
votes
0answers
13 views

Same question but different column names

Im sorry for bothering you again but when I tried the same formula but different column names it did not work... Column names for example are: F1 Makeup (26),F1 bridge tap (26),F2 bridge tap (26),F1 ...
0
votes
1answer
19 views

Calculated field formula

When I tried this, it didn't work... =IF([Circuit Type]="ISDN",(([len_26] + [bt_26] + [dlen_26] + [dbt_26]) * 2.81) + (([len_24] + [bt_24] + [dlen_24] + [dbt_24]) * 2.03) + (([len_22] + [bt_22] + ...
0
votes
1answer
51 views

How do i Generate different calculations depending on what item is selected in drop down box?

Hi guys I am making a SP 2013 site and am currently creating columns... I have a drop down column (Circuit Type) , four text fields (Num1, Num2, Num3, Num 4) and a calculated column (Loss). The ...
0
votes
1answer
29 views

Iterating through list items by name

I have a conditional statement that uses named columns of a list item. Eg. Stage 1, Stage 2, Stage 3.. Is there a way that I can iterate through them to satisfy the problem I'm having when stating the ...
0
votes
0answers
66 views

NullReferenceException when attempting to read from SPList on postback in UpdatePanel

I am developing a SharePoint 2013 Events Calendar Visual Web Part which relies on a SharePoint list to display event data asynchronously. I've tested the concept in a raw ASP.NET environment and it ...
4
votes
0answers
83 views

Efficiently get a collection of all users following a list in SP2013 using CSOM or SSOM?

Does anyone know if there is a way to leverage the SocialFollowingManager() class or the SPList() class to efficiently get a collection of all of the users that follow a specific List? I thought ...
5
votes
4answers
5k views

How to bind dropdownlist from splist column with choice field using C#

Here is my list with name "Department" and name,mobile these are my column name and i want to add to my dropdown list only mobile number(column)plz help me ... SPSite site = new ...
1
vote
0answers
35 views

how to implement picture library look and feel in provider hosted App?

How to implement the same view (design) of SharePoint list (picture or document library) in provider hosted App, for now I am using asp.net controls but the final view of app doesn't belong to ...
0
votes
1answer
440 views

Which of these is the best way to get a list item collection?

Performance-wise which of these methods is the best way to get a list item collection, and why? SPList list = web.getlist("listurl"); SPListItemCollection items = list.getItems(query); ...
1
vote
2answers
250 views

Enable versioning on SPList programmatically

I might be missing something obvious, but I am trying to enable version history on a regular task list programmatically. It is definitely possible from the UI, but how can this be achieved in code? I ...
0
votes
0answers
65 views

Not getting sharePoint lookup addtional field in infopath form

SharePoint List has a Infopath Form, in this list one Lookup column say for eg. "FirstName" and also select addtional column named "Email" Now i have to filter lookup dropdown based on addtional ...
0
votes
1answer
97 views

Sharepoint 2013 c# customise field data depending on user connected properties

I have some specific need here, and i don't know how to approach it. I explain : I have a SharePoint list to which i am adding a field in feature activated event reciever. I am adding a 3 choices ...
0
votes
0answers
40 views

How to syncronize Excel ListObject with SharePoint List

I am import a SharePoint list to Excel. I edit this list in Excel and would like update this modification to my SharePoint source list. I would like do with vb.net. My code snippet is base one method ...
4
votes
4answers
169 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 ...
0
votes
2answers
81 views

How retrieve custom fields only when using SPListItemCollection?

Hi with following code I am retrieving a DataTable from a List: using (SPSite site = new SPSite("http:...")) { using(SPWeb web = site.OpenWeb()) { ...
1
vote
0answers
47 views

Replace default List View Web Parts

As the title explains, I am trying to remove the default Web Parts that are associated to list items and replace them with my own custom web parts. Here is what I've attempted so far: SPList list = ...
0
votes
0answers
42 views

Custom triggers for Alerts in SharePoint 2013

Is it possible to set up an alert that triggers after 5 or more items are entered into a list within a specific timeframe (i.e. 2 hours)? List is SharePoint 2013 custom template. Email would not ...
0
votes
1answer
1k views

SharePoint List View - Export to Excel with Formatting and Grouping

I have a SPList View with 2 levels of grouping. First level is Company and the second level is 'Month - Year' which is a calculated field. Below is the view's screen shot: The issue is when a do ...
1
vote
2answers
183 views

Replacement for Item Level Permissions

I have a SharePoint calender list and where i have given item level permissions for each event through designer workflow using the impersonation step. But now on the production site the number of ...
0
votes
0answers
25 views

CQWPs need reconfiguring when their list is deleted

I have a bunch of Content Queries on a site that are set to show items from a SharePoint list. There's a key field for each list item and the CQs have a filter that matches on the key. I'm managing ...
0
votes
1answer
142 views

Restricted Read Over Contribute Permission Sp 2013

I have a Document library where userA has been placed under 2 groups. Group1 has been given Restricted Read and Group2 has been given Contribute. In this Scenario UserA cant edit the document even ...
0
votes
1answer
113 views

Where does a list item go when it is deleted using Server Object Model?

Assumptions: I have a custom SharePoint list with 2 items in it. In one case i delete one item from the list manually and check the recycle bin,here i find the deleted item. Now in the second case i ...
1
vote
1answer
48 views

How to embed SPList to a custom application page?

I have a custom central admin list and would like to insert it to a custom application page in a way that would make it look exactly like it does if you access the list via its URL - i.e. it should ...
0
votes
1answer
336 views

List Enable Throttling using Server Object Model

Consider the following code, It is querying to a list called Employee Information which has about 23000 items, i.e it has crossed the list view threshold set by the administrator. ...
1
vote
1answer
628 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 ...
2
votes
1answer
143 views

SPListDataValidationException in an event receiver on a task list with Overdue tasks

I have a task list called Finance Department Tasks on this task list i have created an item updating event receiver which checks if all fields in the task list are filled and then sets the task status ...
0
votes
2answers
2k views

Creating SSRS report in SharePoint 2010 with multiple SPLists

I have SP Lists Students: StudentID, Name, Address,Email Course: CourseID, Name, Duration, Fees StudentCourse: StudentID, CourseID How can I query these lists and create a SSRS report displaying ...
11
votes
3answers
18k views

Fastest way to delete all items with C# [duplicate]

Possible Duplicate: Deleting all the items from a large list in SharePoint What is the fastest way to delete all items in a list programmatically? I do not want to remove list and re-create ...
1
vote
0answers
137 views

How do I make a dynamically created SPList read-only in browser, but editable in code?

In code, I create a SPList. I write to this list programatically, but I would like the list to appear read-only for all users (perhaps excluding admins only) in browser only, i.e. I don't want to ...
4
votes
4answers
958 views

Programmatically adding SharePoint Lists to external SQL database

I need to export a SharePoint list to an external SQL database. My initial idea is to open the list as a datatable and bulk update. I created a console app I can run anytime I need to sync the data. ...
1
vote
1answer
610 views

How to get username through REST

I am currently working with a task where you have a SPList in one farm that holds some data that we need to aggregate into a view on another farm. Therefore I am working on a Visual Web Part that ...