Rows of items containing columns of information.

learn more… | top users | synonyms (1)

29
votes
7answers
13k views

Deleting all the items from a large list in SharePoint

What is the most efficient way to delete all the items of a large list in SharePoint? The code should take Query throttling limits into consideration.
14
votes
4answers
26k views

Hide the “Add new Item” option below the sharepoint 2010 list

I have a sharepoint 2010 list, I want to hide the option "add new item" which resides below the list, any suggestions?
11
votes
1answer
353 views

View problem when attaching workflow to list programmatically

Very irritating problem. I have a list with the following view <View BaseViewID="1" Type="HTML" WebPartZoneID="Main" DisplayName="$Resources:core,All_Documents;" DefaultView="TRUE" ...
10
votes
4answers
24k views

Change Title (linked to item with edit menu) to different column

How can I change the column in a SharePoint list that has the link to the item and the link to the item with edit menu eg: Title (linked to item) Title (linked to item with edit menu) I want to have ...
10
votes
10answers
12k views

Sharing data between multiple site collections

We currently have no central records for the addresses of our offices around the world in Sharepoint. Different teams maintain their own address lists, and a search for an address may return various ...
10
votes
5answers
6k views

Which is the easiest way to migrate entire List to a new new site?

Hi I need to migrate a list with 800+ items to a new location but within the same site collection. Which is the easiest way to do it. I want it to be a exactly same with all data, attachements etc ...
10
votes
1answer
5k 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 ...
10
votes
1answer
4k views

Understanding Data Sheet view list better in SharePoint 2010

I would like to know more about the features of Data sheet type lists. Can I use conditional modification to the data sheet rows, for example changing the color if a column value equal 'X' ? Can I ...
10
votes
6answers
12k views

View list from another site collection (Why no easy answer?)

In Sharepoint 2010 whats the best way to view a list from another site collection. I want to be able to sort on People and I want it to look like a listview. (Why is there no easy answer to this ...
9
votes
2answers
11k views

Show custom action in ribbon for only one list

Does anyone knows how to show a custom action in the ribbon for only one list? At this moment I've got multiple custom lists, but my button is added on all of them. I only want to show it on one ...
8
votes
3answers
10k views

How to delete the undeletable list

Somehow a developer has managed to royally screw up a site collection. The site collection has the Publishing Feature enabled and it's working fine. A botched migration from 2007 to 2010 has caused ...
8
votes
6answers
3k views

Different SPList.Items.Count & SPList.ItemCount

A list on my site gives 2 when I call myList.ItemCount. But myList.Items.Count gives me zero and I can't access the items stored in the list. AllItems.aspx show me the two missing items. Any ideas?
8
votes
3answers
3k views

How to add list web part to the SharePoint page using Managed Client Object Model?

I am trying to add new web part to the SharePoint page using Managed Client Object Model that will display a list. I can't seem to be able to figure out the code of the web part's XML that is ...
8
votes
1answer
7k views

PowerShell - create list from list template in list template gallery

Using PowerShell on a SharePoint 2010 site, how can you create a new list from a list template found in the list template gallery?. I want to be able to add several lists at once (just in numerically ...
8
votes
5answers
290 views

Should I use lots of SharePoint Lists or a SQL Database to store the data for my new bespoke application?

I am working on a project to create a new bespoke intranet website for around 50 users. The data volumes are relatively small, but in order to model the data I need to store (about the 100 or so ...
8
votes
2answers
2k views

How can I create an Entity Relationship Diagram for SharePoint lists?

I'm trying to design/document a collection of lists with lookups in an Entity Relationship Diagram. Currently I'm using Visio's built-in ERD template, which is most of the way there, but it lacks two ...
8
votes
1answer
3k views

How to Impersonate Users Via Client Object Model?

I want to insert new SP List items -- blog comments, to be exact -- on behalf of other users. Ideally, I'd just pass a SharepointID for the user, but that doesn't seem to be possible. I think that ...
8
votes
2answers
692 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 ...
7
votes
5answers
21k views

Sharepoint Lists vs. Sharepoint Libraries

Fundamentally, what is the difference between the two? I'm in the really early stages of working out what's what with sharepoint and I can't seem to tell the difference between the two.
7
votes
5answers
556 views

What are the benefits of grabbing a list by Guid compared to any other way

I know its always best to access a list by its Guid since it won't ever change, compared to accessing a list by Title or Url, but what are the other benefits of grabbing a list by the Guid? There ...
7
votes
5answers
25k views

How to make a filtered lookup field

I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes). I would like to use this list as a look-up for other ...
7
votes
3answers
4k views

Possible to format how numeric columns display?

I have a numeric column in a list that displays like so: 16,090 I would like it to display without the comma: 16090 Can this be done?
7
votes
4answers
26k views

How do I create a formatted report document from a list?

I am using a SharePoint 2010 Foundation list to contain information that I need to populate a custom report with. Ideally this is all done from with SharePoint, such that a user could look at the ...
7
votes
6answers
6k views

Where to find PublicKeyToken?

I opened an empty sharepoint project in which I added a new application page. There I wrote some code. Now I need to enter that information under <SafeControls> tag in web.config file. ...
7
votes
4answers
15k views

How to submit data from repeatable table in infopath form to a sharepoint list?

I have a infopath form created from a sharepoint list content type. In this form I need to add a repeatable table to send data to another sharepoint list. So when people submit this form the original ...
7
votes
1answer
526 views

JavaScript Client Object Model functionality to get all the non hidden lists of current web and listing them

We have requirement to get all the non hidden lists of current web using JavaScript Client Object Model(JSOM). I have tried the below code but failed to get the desired result. function ...
7
votes
1answer
859 views

Where to load data in the lifecycle of custom webpart

I have a webpart where I access a sharepoint list and render contents of that list. At the moment I'm fetching the data in CreateChildControls(). When a button is clicked the data will be fetched ...
7
votes
2answers
1k views

How do you stop scroll position maintained after postback on lists?

I have a list with paging enabled and a page size of 10. When you scroll to the bottom of the page hit the next button in the list the page redirects to itself with different querystring parameters ...
7
votes
3answers
6k views

How to get the ID of the list item just inserted using ecmascript

I am stuck at a place where I have to update a list which has a Lookup column. For example I am using this code to update my normal list var clientContext = SP.ClientContext.get_current(); ...
7
votes
2answers
948 views

How do I set a list to not be valid for search through the object model?

In WSS 3.0, there's an option under "Advanced Settings" for a List as follows: Search Specify whether this list should be visible in search results. Users who do not have permission to see ...
7
votes
5answers
10k views

How to auto-populate a list column with a sequential number?

I am using a SharePoint list as a database for logging accidents/incidents at work. Each incident is assigned a number. As there are multiple people making use of this list, I'd really like the ...
7
votes
2answers
757 views

Anonymous access: Add an Item to List without allowing to View the List

I'm creating a 'Contact Us' webpart with form to allow anonymous user to send a message which will be added to a SharePoint List. However I cannot grant the anonymous user the permission to Add ...
6
votes
3answers
5k views

ListInstance with predefined data, prevent adding records to list with same name on deployment

I have a feature which on activation has to create a list called Scanners. Only one column from the list (Title) is actually used in my app. The list needs to be pre-populated with some values. To ...
6
votes
2answers
3k views

Renaming Title Column in SharePoint List Definition

I am defining a custom list content type for SharePoint (using VSeWSS 1.3 and schema.xml). I want to change the display name of the default title field ('Title') to 'Serial Number': <Fields> ...
6
votes
3answers
4k views

How to restrict user to see only few rows in a list

I have one list Title Availability Department ----------------------------------------------------- Microscope Yes Biology Buret No ...
6
votes
2answers
2k views

Download file from a sharepoint site from code behind

I have an Image button in a custom 2010 webpart, on click of that I would like to download a file. Code Used : foreach (string filename in item.Attachments) { attachmentURL = SiteListURL + ...
6
votes
5answers
5k views

SharePoint List Item Permissions

Does anyone know of a way to implement permissions within a SharePoint list so that items are only visible to the person who created it (or potentially who the list item is "assigned to", as in like a ...
6
votes
4answers
892 views

How can I print a SharePoint list without all the chrome?

Is there a way to print the list you are looking at without all the browser chrome? I have seen List Print by Bamboo Solutions which does something similar.
6
votes
4answers
10k views

How to migrate a 2007 sharepoint list to 2010?

We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010. what's the best and fastest method? thanks in advance
6
votes
2answers
970 views

Best practice for combining two lists

I know it's a common SharePoint problem. I want to accumulate two SharePoint lists on MOSS 2007. One is a calendar list and the second a custom list with a date column. I want both in another list. ...
6
votes
3answers
352 views

Filter out folders from a user alert against a list

I have created an alert for a user against a list (more specifically, a document library). I want the user to be notified of all changes regarding list items (documents) and not any sub folders. ...
6
votes
3answers
8k views

Best method to create custom NewForm / EditForm

I am new to sharepoint development and need to create some custom NewForm/EditForms for a new custom list I am creating. It seems like I have two choices: ...
6
votes
1answer
3k views

Choice field changed - How to propagate the change down to all lists that used it?

I have a feature (Web scoped) with a content type which contains a field (Type="Choice"). Values were A, B and C. I've created a list based on this content type and added some elements in it. I ...
6
votes
1answer
5k views

How can I restart list item ID numbering at 1?

I deleted list items that include an ID from the list and the recycle bin. When I create a new list item, the ID populates where the last line item left off. Now is there a way to make a new ID ...
6
votes
1answer
463 views

How to Combine IN-Opeator with LookupIds in a caml-query?

I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine: <Where> ...
6
votes
2answers
280 views

Create a decrementing budget

I'm new to sharepoint and I have been tasked to create a depreciation list using a sharepoint 2007 environment. Does anyone how to create a list that displays a fixed fiscal year budget, and as data ...
6
votes
2answers
9k views

Is there a way to get column headers to wordwrap in SharePoint lists?

My column header needs to be quite long, but the content of the column is only a few pixels wide, so loads of white space and horizontal scrolling required to see the rest of the content. Any ideas?
6
votes
2answers
2k views

How to create SharePoint list with custom template using Managed Client Object Model?

Creating lists in SharePoint using Managed Client Object Model is rather easy task. Here's how to create a list with SharePoint's custom list template: ListCreationInformation lci; List list; lci = ...
6
votes
2answers
82 views

How to make the “Web Address” link in List Settings clickable

On the "List Settings" page of any custom list that we make (or OOTB list for that matter), there are 3 fields that show at the top at all times: "Name", "Web Address", and "Description" (sample ...
6
votes
3answers
211 views

Equivalent of a database table in SharePoint?

I'm making a Publishing site, and part of this site will display information about company products. We have a number of products, and each one should have its own description page. The description ...