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

learn more… | top users | synonyms

0
votes
2answers
30 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
20 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
13 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
32 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
40 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
22 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
31 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
29 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
32 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
45 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
70 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 ...
0
votes
2answers
494 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
0answers
26 views

Managed metadata not loaded in standard metadata-dialog

I have a standard SharePoint list which has a (required) Managed metadata-column. When I want to add a new item and click on the icon to show the Managed metadata-dialog, the dialog opens but nothing ...
2
votes
1answer
55 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
0answers
139 views

Excel Online - refresh data in a SharePoint list

I have added a SharePoint list to an excel spreadsheet as an odata feed. This data connection refreshes perfectly using Excel on the Desktop. However, when I refresh the connection in the Excel web ...
0
votes
2answers
1k 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 ...
9
votes
3answers
12k 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
71 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 ...
0
votes
0answers
63 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 ...
4
votes
4answers
788 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
190 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 ...
3
votes
0answers
127 views

SPGridView - How to make it look & feel like built-in SP grid

In C# code, I'm working with the SPGridView control to display list items from a list of type SPDocumentLibrary. It binds fine, but it looks totally plain and has basically no features. I would like ...
1
vote
3answers
85 views

Cannot iterate subfolders of a very large folder

I have working code that is to iterate lots of folders in our (rather large) document archive, but one folder (which happens to have a very large amount of subfolders) does not allow me to iterate it. ...
2
votes
1answer
891 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 ...
5
votes
3answers
3k 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
2answers
175 views

Why does SPList.GetItems(string fields[]) return more fields than specified?

I'm using SPList.GetItems(string fields[]) to obtain only specific item fields from a document library: SPListItemCollection items = list.GetItems("UniqueId", "Name"); However, iterating the items ...
1
vote
2answers
2k views

Add New Item Link not appear in Sharepoint List

Add New Item Link not appear in Sharepoint List. I logging with admin account(having full control). How to resolve ?
1
vote
1answer
28 views

Is there a setting that determines the default root folder of a freshly-created SPList?

I noticed that when I create lists on my development site(s), they're created right in the site's root (in other words, URLs look like xxx/sites/DEV/DocLibX). The last time I looked (a few days ago), ...
2
votes
2answers
97 views

Unable to set permission on list for multiple spgroup

I have a list to which I want to set permission to 2 site groups. Among them, one is contribute level and second is read. My code for assigning the permission to list is: private void ...
0
votes
1answer
133 views

Adding an splist instance to an Application page programmatically through xaml/backend c#

I have created a custom list which I wish to put inside an application page, since I wish to be able to filter what is shown inside the list to the content which is related to the user. Is there any ...
1
vote
0answers
55 views

Using DefaultNewFormUrl's link on Document Library opens item on save

As our company tries to move away from the folder structure and into a tag-driven structure we were left with a dilemma. Users can only add content to folders/libraries yet they don't want to have to ...
1
vote
1answer
1k views

How do I get values of fields from custom lists?

I have a custom list ("Contacts") as well as a web part with forms. I want to take the custom list fields and map them to the web part form. My problem is getting the values from the custom list. I've ...
1
vote
0answers
39 views

'E-Mail a Link' Ribbon Button generates a wrong URL on Grouped Views

When a Grouped View is defined in a List View Web Part, the OOB Ribbon Button 'Email a link' on a List/Library Context Tab, generates an incomplete URL (only Web Application URL) Override the Ribbon ...
0
votes
1answer
88 views

Add additional user information to SPList as list column

I have a List Tickets with a field Client. This is a user from our AD and displays the name of the user. We now need to display the country and the location the user resides in to additional fields. ...
1
vote
2answers
566 views

How to create tempary hidden field or variable in infopath that not going to add to SP List

I want add tempary variable or field to Infopath Brower Form to hold some information i want to set by rules. So i dont need this field in my sharepoint list.. Is there any way to do this without ...
0
votes
1answer
203 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
0answers
76 views

External lists: Field GUIDs always empty?

I want to turn an external list into a DataTable using the ID/GUID values of external list's Fields as the DataTable column names; however, I've noticed for the external list I'm using, all of the ...
0
votes
2answers
365 views

Changing permission for splist

How can I change the list permission to be read only for all groups in the site? programmatically. This is my code: list.BreakRoleInheritance(true); SPRoleDefinition roleDefinition = ...
1
vote
1answer
98 views

In SharePoint 2010, is there a way to stop one user from subscribing to list alerts?

For example, when a list is updated, a user can subscribe to the list so they get emails about the changes to the list. I can remove a user from getting those alerts, but the user can simply go back ...
0
votes
1answer
37 views

Is there any programmatic way to determine if a list has any relationships to other lists?

If list A has a SPFieldLookup to list B is there any thing in list B's SPList object to show the relationship with list A? While I can flip through list A's fields and find the relationship to List B ...
0
votes
2answers
148 views

Is it possible to populate result by joining two lists throughout the site collection

Scenario is somewhat like this: I have n number of subsites and each subsite contains two lists(exactly same in all subsites) having parent child relationships using a lookup column, need to populate ...
4
votes
2answers
1k views

Using PowerShell how do I change the column ordering for a SharePoint List

Been trying to search for the answer to this, what I need to do is re-order the fields of a SharePoint list and propagate that change down to 300+ sites (should have used a content type, but oh well) ...
1
vote
2answers
187 views

View aggregations programmatically

I have a view in my list, I defined aggregations in my view: sum and average of several columns. Now I want to get programmatically the aggregations results. How can I get it?
0
votes
2answers
494 views

ItemEventReceiver - ItemDeleting not working with a document library and referencing list

I have a custom list that has a GUID column which refers to the UniqueId of a document in a document library. Every time I upload a document, it should add an entry in this list and populate the ...
0
votes
0answers
113 views

Programmatically updated SPList view filter is showing <!#Render Error--> in the view Moss 2007

Am appending a filter condition to a particular view alertview.Query = viewQuery.ToString(); alertview.ParentList.ParentWeb.AllowUnsafeUpdates = true; alertview.Update(); ...
2
votes
1answer
712 views

List.AddItem() and List.Item.Add() … why two methods for same purpose

I searched and got the difference between List.AddItem() and List.Item.Add(). SPList.Add() vs SPList.AddItem() SharePoint 2010 Now the query which comes to my mind is that why Sharepoint has two ...
1
vote
2answers
203 views

Deleting all items from a list and then adding new items will not give the new items id 1,2,3 etc

I have a list with 3 items. When I delete these 3 items and add new items they get ID 4, ID 5 and ID 6. But I want the new items to get ID 1, ID 2, and ID 3. Is there any workaround? This is how I ...
2
votes
1answer
86 views

Changed URL to pages, but still redirects to Pages?

I have an external website which needs to show URL in lowercase only. I don’t want to use URL Rewrite or any third party tool. Instead we decided to change the actual URL’s of the Pages Library. I’ve ...
0
votes
1answer
87 views

Best way to update 200 items on a list [closed]

Situation in a VS2010/SP2010 site: List A with main items List B with subitems, having a lookup column that points to List A ID There are about 200 subitems for each item The Page where users edit ...
5
votes
2answers
855 views

how to set list alert using javascript in sharepoint 2010?

I need to set a list alert for current (logged in) user using javascript. var currentcontext = new SP.ClientContext.get_current(); var currentweb = currentcontext.get_web(); ...