Rows of items containing columns of information.
11
votes
3answers
4k 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.
11
votes
1answer
295 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" ...
9
votes
2answers
6k 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
5answers
4k 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 ...
8
votes
10answers
7k 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 ...
8
votes
1answer
2k 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 ...
8
votes
2answers
974 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 ...
7
votes
6answers
3k 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
5answers
2k 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?
7
votes
1answer
349 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
2answers
738 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
1k 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 ...
7
votes
2answers
445 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 ...
6
votes
4answers
346 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
2k 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
2answers
760 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
8k 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 ...
6
votes
1answer
420 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 ...
6
votes
3answers
117 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
284 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
124 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
5answers
165 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 ...
6
votes
5answers
7k 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 ...
6
votes
3answers
3k 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
2k 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 ...
6
votes
1answer
1k 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 ...
5
votes
3answers
2k 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?
5
votes
2answers
13k 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
5answers
3k 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
4answers
2k 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
3answers
14k 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 ...
5
votes
4answers
437 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.
5
votes
2answers
755 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. ...
5
votes
2answers
2k views
Location of Ribbon XML for List View
I'm looking for the location of SharePoint ribbon XML for List Views. I'm just curious to see how Microsoft has coded it. However, I don't know the location of the xml file. Could someone put me in ...
5
votes
3answers
5k 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 ...
5
votes
1answer
338 views
Only show Sorting option not filtering opetion in contex menu of header in ListViewByQuery
I have creatd ListViewByQuery control through coding and added the control through RencerControl Event.
I am filtering the list in code. so filtered result is shown. I want to hide filter context ...
5
votes
2answers
108 views
Only have the option to create Web Pages
I'm a new SharePoint user, getting my feet wet by learning the interface for WSS. I'm trying to edit an existing site by adding a links list. But I don't have the regular options.
On the Home site ...
5
votes
2answers
4k 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?
5
votes
1answer
886 views
SPList.GetItems query returning an invalid SPListItemCollection. What am I doing wrong?
I'm trying to query an SPList object using a CAML query (see code below).
SPQuery queryGetExistingTargetTask = new SPQuery();
queryGetExistingTargetTask.Query = ...
5
votes
2answers
513 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 ...
5
votes
3answers
196 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 ...
5
votes
2answers
215 views
How to know old id of item in recycle bin?
I need know old id of item in recycle bin or is there any way how to save its id in this item before deleting. When item is deleted, a new SPRecycleBinItem is created in Recycle Bin. And the only ...
5
votes
2answers
121 views
Strategy Queston : how would you implement this calendaring use-case
At my organization there is a process that goes in to preparing for our Board of Director's Meetings that begins 6 weeks beforehand and involves about 9 different steps. We have a template document ...
5
votes
1answer
290 views
Tooltip showing latest pictures inside a Picture Library for SharePoint 2007
Inside a SharePoint Document List, I keep a few folders - Folder A, Folder B, Folder C.
Each folder have some pictures inside them.
May I know if there are any web part that can help me display at ...
4
votes
5answers
10k 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 ...
4
votes
2answers
4k views
SharePoint List with many columns
We are designing a system where data from forms will be stored in sharepoint lists.
Problem is that these lists can have very many columns.
Question is:
Is there a max number of columns in a ...
4
votes
3answers
1k views
How to add event receivers to all the lists in a site collection?
What is the best practice around adding event receivers across all the lists in a Site Collection?
4
votes
1answer
757 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 ...
4
votes
3answers
1k 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 ...
4
votes
2answers
215 views
Can you call SPSite on a different machine to SharePoint setup?
I'm trying to call SharePoint from within a standard .NET class library. This will probably be hosted on a different server to SharePoint.
I just need to return an item from a list, and wondered if I ...
