Rows of items containing columns of information.

learn more… | top users | synonyms (1)

23
votes
4answers
11k 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.
13
votes
3answers
24k 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
349 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
10answers
11k 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
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 ...
9
votes
1answer
4k 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 ...
9
votes
2answers
10k 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 ...
9
votes
6answers
11k 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 ...
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
5answers
268 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
670 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
19k 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
22k 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
21k 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 ...
7
votes
3answers
3k 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
6answers
5k 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
14k 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
509 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
791 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
3answers
9k 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 ...
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 ...
6
votes
4answers
519 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 ...
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

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
4answers
25k 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 ...
6
votes
2answers
1k 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
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
3answers
335 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
1answer
406 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
258 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
3answers
5k 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(); ...
6
votes
1answer
6k 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 ...
6
votes
2answers
885 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 ...
6
votes
5answers
7k 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 ...
6
votes
2answers
639 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
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
78 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
1answer
78 views

Is it possible to have different timeline views against the same list?

Using a single task list, from our testing it seems that the add to timeline/remove from timeline functions store state across the site list rather than against the view. Is it possible to select a ...
6
votes
1answer
2k views

Inherit permissions on list in a sub-site causes site collection lock-out

Scenario is this - site collection contains a sub-site with unique permissions. In that sub-site, site owner with full control creates link list. That list is not created with the same permissions as ...
6
votes
2answers
650 views

Saving list template with managed metadata columns. Creating new list with the template.

I have a list that has several columns including managed metadata columns. I'm saving this list as a template and including all the content. I'm then taking this template to another site collection ...
5
votes
2answers
17k views

Calculated value for Title field?

I would like to create a calculated value for the mandatory Title field: <username, created by> - DD-MM-YYYY That is I want the title to be filled in with the user name (the user that creates ...
5
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 ...
5
votes
5answers
4k 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 ...
5
votes
5answers
7k views

What's the best way to move a list from one site to another?

I know you can backup site collections with stsadm -o backup, and you can backup sites with stsadm -o export. But what's the best way to copy a list. I've tried to use the save as a list template and ...
5
votes
4answers
3k views

calculated field - formula for ageing

Again a calculated field question, How can I create a calculated field to find out, what is the age of the entry. In the list I will have a created date field, from that I would like to create a ...
5
votes
4answers
838 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.