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

learn more… | top users | synonyms

0
votes
4answers
986 views

Fetch SPList items from another siteCollection - problem with xml

Trying to fetch all list items from a list located in a different site collection and traverse the list items, reading some of their column values. I've taken some code from an example snippet that ...
0
votes
1answer
711 views

Is there a property to get all subitems/subfolders from a SPListItem?

I need to find out how many subitems and subfolders a SPListItem has. The fields ItemChildCount and FolderChildCount are no solution for me, because they only count the folder/item directly beneath ...
0
votes
1answer
27 views

Approaches for porting content from one SPList to another SPList

I have one SPList -say List1- with some 400 items with single line of text, dropdown, lookup,peoplepicker, multiline fields etc. I need to copy the entire from this List1 to a new list that has ...
0
votes
2answers
43 views

Update SPList.ImageUrl after migration from SP2007 to SP2013

After migration from 2007>2010>2013 for all lists ImageUrl property is still on 2007. If someone have powershell script which updates all lists on site SPList.ImageUrl property from SP2007 version to ...
0
votes
1answer
2k 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 ...
0
votes
1answer
626 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. ...
0
votes
1answer
374 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 ...
0
votes
1answer
154 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. ...
0
votes
2answers
1k 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
1answer
605 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); ...
0
votes
1answer
124 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 ...
0
votes
1answer
344 views

How to use dynamic or relative path in SPList object?

I am using the following code to read a picture library: SPList list = SPContext.Current.Web.GetList("http://win-12/sites/mysite/ImageLibrary") Problem is, in above code "win-12" is my machine name ...
0
votes
2answers
3k 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 ...
0
votes
1answer
984 views

selected SPListItem in the current list

how to get the selected SPListItems in the current SPList ? I thought I would find a helping property like this: SPListItemCollection mySelectedItems = ...
0
votes
2answers
1k views

How to get a SPList's default edit SPForm programatically?

I have created a new edit form for my SPList via Sharepoint Designer and haven't deleted the old ones. I know how to get all the forms, but how to distinguish default forms from the rest? I can see ...
0
votes
1answer
808 views

New SPField shows in the view of my SPList but doesn't appear in any forms (edit, new)

I add a new column to a SharePoint list (the list is built on a content type) like this: SPField textfield = list.Fields.CreateNewField(SPFieldType.Text.ToString(), "new column"); ...
0
votes
1answer
901 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 ...
0
votes
1answer
872 views

Proper use of SPWeb from SPContext for pulling lists

So, after about two hours on the subject I am thoroughly confused. There are viewpoints all over the place on how, when, and why to use Dispose() on SPWeb objects as they relate to SPContext. Can ...
0
votes
1answer
443 views

Changing SPField cause no changes

I try to change an SPField after SPList creation, but I'm not getting any results of that change. using this code: SPField oSPField = oSPList.Fields[new Guid("MyFieldGuid")]; ...
0
votes
3answers
342 views

Tool to get SPList in webpart using tool

I want to get SPList data in webpart just passing name in tool. Anybody have any idea about that?Please Suggest me.
0
votes
1answer
34 views

Efficient way to get all the field (column) values in an array from SharePoint List

I have to get all the field (column) values in an array from a SharePoint list. Right now I am looping through all the items in the list and creating an array. But it is very inefficient if I have ...
0
votes
0answers
14 views

Restore viewstate while cancelling request

I have a SPItemEventReceiver with custom ItemAdding handler. When any exception occurs (frequently it's just a model validation) it handles this exception in Handle method. Now it looks like this: ...
0
votes
2answers
68 views

Retreive all Items from All Lists from a site - Powershell

I have a PowerShell script that outputs all documents from all Libraries within a Site (web) scope to a CSV file listed below: function Get-DocInventory([string]$siteUrl) { $site = New-Object ...
0
votes
0answers
59 views

Validate checkboxes and textboxes in SP 2010 List NewForm.aspx on Save Click -PreSaveAction

I am having a new form created on my SP 2010 List, mycustomnewform.aspx and i have some 6 checkboxes and 6 textboxes.Now I need to validate these textboxes' value when a checkbox is checked. I ...
0
votes
0answers
40 views

Unable to update RichTextMode from Compatible to FullHtml

As the title says, I am unable to update the RichTextMode property of the Description field on a Calendar List. I am trying to update the field so that it supports "Enhanced Rich Text". Snipp: ...
0
votes
2answers
97 views

C# SSOM turn on List Rating settings

I have been using the method described here by attempting to use reflection to turn on the Rating Settings of a list. However, I get the following error: Exception Message: exception has been thrown ...
0
votes
0answers
69 views

Show Hide Div based on DropDown SharePoint Visual Webpart

I have a cascaded drop-down on my page that is being populated from SPList on site. Now Based on this drop-down's Selection i want to show or hide Div containing 4 more controls. If any one can help ...
0
votes
0answers
14 views

SharePoint manipulating content on ListItem insertion

Long story short, I am parsing an XML document and adding items to the Body field of a discussion board. The XML has a <body> element that contains encoded HTML that I am adding to the list ...
0
votes
2answers
134 views

How export list in excel file

I want to create a button that exports specific list into the excel file. But when I do it I always get the same error: Error List does not exist. The page you selected contains a list that does ...
0
votes
1answer
39 views

Error passing spweb and splist variables as function parameters

I need to pass SPWeb an SPList as function parameters: string check(SPWeb web1, SPList splist1){} Yet, web1.Title, splist1.Title throws errors: There is no Web named "/http://DevSite". Is ...
0
votes
0answers
47 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 ...
0
votes
0answers
30 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 ...
0
votes
0answers
61 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
122 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
32 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
29 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
3answers
49 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
203 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
199 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 ...
0
votes
1answer
33 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
56 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
32 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
1answer
250 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
244 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
2answers
989 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 = ...
0
votes
2answers
306 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 ...
0
votes
0answers
223 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(); ...
0
votes
1answer
41 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
1answer
61 views

Display a list as readonly regarless of permission level

I am currently trying to display a list view outside of its site collection. This has been done using String str = mySPView.RenderAsHtml(); Controls.Add(new LiteralControl(str)); Since it is ...
0
votes
0answers
126 views

Proper way to get all lists of a certain type from an entire site collection regardless of current location

I'm creating a webpart that gives the user a feed of any annoucement list in the entire site collection, so they can aggregate data to a central portal. I'm currently using the following, but can't ...