How do I display a filtered view of a list in a sub-site...desparate...
This is killing me!
I read this
post, in which things are getting clearer. Here's what I am struggling with:
I have Master List in a Exec Site(WSS2.0). I have aseveral sub-sites for each of our satellite offices.
I'd like to be able to display filtered views of the Master List applicable
to each office in their sub-site.
I was able to create a part, paste the list and setup the required filter
(in FrontPage 2003). Well, each office still has to have read
permissions for the Exec Site and the Master List . That means they can
discover the main site and read content they are not supposed to.
Is there anyway to pull the filtered data into a list on a sub-site?
I'd like each office to authenticate themselves to their sub-site,
then when they open the filtered list to run without another authentication to
the main site.
The site resides on a remote server - it's being hosted by a third
party.
Please, please I would appreciate any suggestions!
Thank you!
I wrote a solution for that once, and it's still being sold by the company I worked for.
Its called sharepoint list synchronizer and you can download a free trail from them: http://www.omnisys.co.il/main.asp?lngCategoryID=2557
I am not sure if it supports synchronizing only part of the list, like you seem to want (did I understand correctly?) but I am sure they will be happy to customize it for you.
Thanks for your reply Ishai!
I don't understand why is it isn't possible to view lists(or filtered views) that belong to a Main Site under one or all of its subsites (that's when you use SP Designer). Then it would be possible to create the views I am struggling with.
I started working on the upgrade to v3.0 of the Main Site. I might be able able to accomplish the task within the main Site using permissions, but I'll have to read up some more on SPS v3.0.
To describe the scenario again: a user has permissions for subsite only. They login to that subsite, open a webpart on which they have a Data View of a list that resides on the Main Site (their subsite was created from that site). The view is nothing more than a simple select query. Is it possible or not?
I'll try to keep this topic alive. I am sure someone has an idea how to accomplish this task.
Thanks again!
So you want users to see a web part of a list that is in a parent site, to which the users have no permissions?
First, you need to give permissions to the list (disconnect its permissions from the site) so that users are allowed to see the list itself.
Then, use a dataview built by sharepoint designer, but don't point it to the list! instead, use the "lists" web service which allows you to show list items from any site (even on another server).
You can find a lot of samples on how to do that in my blog, but in short, let's say the parent site is "http://site" , all you have to do is add a dataview connected to "http://sites/_vti_bin/lists.asmx" and the function GetListItems. You will need to specify the list name, and some other data (run google on GetListItems & dataview if you run into trouble)
Good luck!
You could try using item level security. When someone publishes an item to the list on the main site, they would specify which groups could see it. Then you put a dataviee in each subsite that views the list from the main site. Sharepoint item security ensures that only the items a user is authorized to see are displayed in the subsite.
Thanks Ishai,
| So you want users to see a web part of a list that is in a parent site, to which the users have no permissions? |
|
Yes! They should be able to read only a view that applies to them. These items however were not created by them - they are all created by a single user. He imports the data from a table. If there's a way to "assign" item permissions to certain users even if they were created by someone else, it would be the perfect solution. Then I won’t even need subsites as my only concern is for these “satellites” are not read other peoples items or the entire list.
| First, you need to give permissions to the list (disconnect its permissions from the site) so that users are allowed to see the list itself. |
|
Last time I tried this it didn't work or I don't understand your explanation. If users do not have (any) permissions to the site, but they have read permission to the list I can enable them view the list in subsite? Correct? How do I do that when the main list doesn't appear as an item under a subsite?
| Then, use a dataview built by sharepoint designer, but don't point it to the list! Instead, use the "lists" web service which allows you to show list items from any site (even on another server). |
|
I followed your instructions for the GetListItems procedure as well as this one. For some reason all fields now begin with "ows_" (without the quotes). Also in cells formatted with currency the null values are replaced by “ NaN ”(without the quotes). Worst of all is the representation of the calculated fields - they all start with "string;# "(without the quotes). How do I correct all that?
The dataview is awful in my opinion. I am having a hard time rearranging the order of each field. I am doing this in FP 2003 using a subsite WSS 2.0. Is there a way to create datasheet view? I need to have some totals and count calculated for some of the fields. My dataview has 44 columns.
I appreciate your help very much!
Thanks russgove,
Items are created by a single user - all of them. After the fact, only a few users are able to make modifications. I attempted to re-assign an item to one of the read-only users, but the items themselves are read-only. That means I need to change the permissions of the readers, make changes, and even then these items won't be theirs. I right here, correct?
I managed to create a DataView using GetListItems. This time I used Sharepoint Designer, connected to a site with V3.0 of SPS. Here are a few problems I am not able to overcome:
I connect to the list and select Show Data. It displays all the fields but it limits the items to 100 (under ItemCount). I am connecting to a view of the list on which I have calculated values. All fields display "string;#" (without the quotes) before the data. All field names start with "ows_" which is the ways it supposed to be from what I read in a MSDN article.
My questions are then: how do I avoid the "string;#" to display and is it ok/safe to rename the field names on the dataview table. Most importatnly: how do I increase the 100 to unlimited under ItemCount? Would rowLimit do the trick? It sounds like it would display a certain number of records before paging.
Thank you and ppreciate your help very much!
In SharePoint Designer, select the dataview and you'll see an arrow on the right side for some options. Select "Paging" near the top of the popup menu. There is where you can change the number of rows.
I'm facing the same problem with the "string;#" appended to data I pull from a calculated column. See my post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279818&SiteID=1. Have you an answer for getting rid of the "string;#"? Is this a SharePoint Designer bug?
