Filtered List View Web Part
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Filtered List View Web Part

 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services
Author Message
Kevin H.
Guest





Posted: Thu Jan 13, 2005 7:21 am    Post subject: Filtered List View Web Part Reply with quote

Perhaps this is a Frontpage Group question, but here it is:

I have a SharePoint list of customers and when I drill into to the display
page (DispForm.aspx) I want to filter a Data View Web part (DVWP) for the
contacts associated with that customer (so you only see the contacts related
to Customer A for example). I should be able to do this with a DVWP in
Frontpage? No? I have tried filtering the Contacts DVWP with a customerID =
'@ID' etc. and with no luck. Any idears on how to configure this as a web
part?

Kevin H.
Back to top
Ian Morrish
Guest





Posted: Thu Jan 13, 2005 1:08 pm    Post subject: Re: Filtered List View Web Part Reply with quote

Hi,
I have done something similar but for Project/tasks
See http://www.wssdemo.com/Project/Lists/Project/DispForm.aspx?ID=3
Up at the home page are some notes on how to do it.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:72CCAA5B-5177-4715-8987-61C3DE75615A@microsoft.com...
Quote:
Perhaps this is a Frontpage Group question, but here it is:

I have a SharePoint list of customers and when I drill into to the display
page (DispForm.aspx) I want to filter a Data View Web part (DVWP) for the
contacts associated with that customer (so you only see the contacts
related
to Customer A for example). I should be able to do this with a DVWP in
Frontpage? No? I have tried filtering the Contacts DVWP with a customerID
=
'@ID' etc. and with no luck. Any idears on how to configure this as a web
part?

Kevin H.
Back to top
Kevin H.
Guest





Posted: Fri Jan 14, 2005 4:53 am    Post subject: Re: Filtered List View Web Part Reply with quote

Ian,

Thanks for the great example... couple of things...

on the notes page of:
http://www.wssdemo.com/Project/Shared%20Documents/display.aspx

and walking through trying to duplicate your example of projects --> tasks

I am having trouble with the Projects DVWP and the Filter on ID with [Input
Parameter]. It will not filter with that. It should be the selected project
it will then filter it on correct? I can get nothing filtered (or any values)
with prjects there when I change the Client Parameter Bindings like the
example:

<udc:ClientParameterBindings>
<udc:ClientParameterBinding Name="filterParam"
Location="Postback;Connection;QueryString(ID)" DefaultValue=""/>
</udc:ClientParameterBindings>

but if I 'hardcode' the default value (DefaultValue="2" for example) to a
valid project ID then I can successfully filter the Tasks for that
'hardcoded' project. Of course, I want to pull those dynamically from the
selected project ID (like yours is doing). Any idea why that [Input
Parameter] is not taking? Also, once the filter is working do you then hide
the Project DVWP somehow? How?

thanks,
Kevin H.

"Ian Morrish" wrote:

Quote:
Hi,
I have done something similar but for Project/tasks
See http://www.wssdemo.com/Project/Lists/Project/DispForm.aspx?ID=3
Up at the home page are some notes on how to do it.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:72CCAA5B-5177-4715-8987-61C3DE75615A@microsoft.com...
Perhaps this is a Frontpage Group question, but here it is:

I have a SharePoint list of customers and when I drill into to the display
page (DispForm.aspx) I want to filter a Data View Web part (DVWP) for the
contacts associated with that customer (so you only see the contacts
related
to Customer A for example). I should be able to do this with a DVWP in
Frontpage? No? I have tried filtering the Contacts DVWP with a customerID
=
'@ID' etc. and with no luck. Any idears on how to configure this as a web
part?

Kevin H.


Back to top
Ian Morrish
Guest





Posted: Sat Jan 15, 2005 12:16 am    Post subject: Re: Filtered List View Web Part Reply with quote

The <udc:ClientParameterBinding Name="filterParam"
Location="Postback;Connection;QueryString(ID)" DefaultValue=""/>
goes on the DVWP that is bound to the Project list, not the task list DVWP
(you may have modified the wrong DVWP on the page). This DVWP is only
required so that we can make a web part connection to the Tasks list.
Unfortunately the web part that displays the Project details that is already
on the page doesn't support connections.

You can hide the Project DVWP by setting it to a closed state in the display
properties. I only have it displayed in the demo so that you can see it is
part of the solution.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:4EB69870-1B83-4C02-A9BF-F81C923AAC3B@microsoft.com...
Quote:
Ian,

Thanks for the great example... couple of things...

on the notes page of:
http://www.wssdemo.com/Project/Shared%20Documents/display.aspx

and walking through trying to duplicate your example of projects --> tasks

I am having trouble with the Projects DVWP and the Filter on ID with
[Input
Parameter]. It will not filter with that. It should be the selected
project
it will then filter it on correct? I can get nothing filtered (or any
values)
with prjects there when I change the Client Parameter Bindings like the
example:

udc:ClientParameterBindings
udc:ClientParameterBinding Name="filterParam"
Location="Postback;Connection;QueryString(ID)" DefaultValue=""/
/udc:ClientParameterBindings

but if I 'hardcode' the default value (DefaultValue="2" for example) to a
valid project ID then I can successfully filter the Tasks for that
'hardcoded' project. Of course, I want to pull those dynamically from the
selected project ID (like yours is doing). Any idea why that [Input
Parameter] is not taking? Also, once the filter is working do you then
hide
the Project DVWP somehow? How?

thanks,
Kevin H.

"Ian Morrish" wrote:

Hi,
I have done something similar but for Project/tasks
See http://www.wssdemo.com/Project/Lists/Project/DispForm.aspx?ID=3
Up at the home page are some notes on how to do it.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:72CCAA5B-5177-4715-8987-61C3DE75615A@microsoft.com...
Perhaps this is a Frontpage Group question, but here it is:

I have a SharePoint list of customers and when I drill into to the
display
page (DispForm.aspx) I want to filter a Data View Web part (DVWP) for
the
contacts associated with that customer (so you only see the contacts
related
to Customer A for example). I should be able to do this with a DVWP in
Frontpage? No? I have tried filtering the Contacts DVWP with a
customerID
=
'@ID' etc. and with no luck. Any idears on how to configure this as a
web
part?

Kevin H.


Back to top
Kevin H.
Guest





Posted: Sat Jan 15, 2005 5:01 am    Post subject: Re: Filtered List View Web Part Reply with quote

Hi Ian,

That Client Parameter Binding is exactly what I have on the Projects DVWP.
It is not filtering on the project. When I hardcode the Default Value it
filters it then. Does the parameter need a @ID or anything?

KH

"Ian Morrish" wrote:

Quote:
The <udc:ClientParameterBinding Name="filterParam"
Location="Postback;Connection;QueryString(ID)" DefaultValue=""/
goes on the DVWP that is bound to the Project list, not the task list DVWP
(you may have modified the wrong DVWP on the page). This DVWP is only
required so that we can make a web part connection to the Tasks list.
Unfortunately the web part that displays the Project details that is already
on the page doesn't support connections.

You can hide the Project DVWP by setting it to a closed state in the display
properties. I only have it displayed in the demo so that you can see it is
part of the solution.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:4EB69870-1B83-4C02-A9BF-F81C923AAC3B@microsoft.com...
Ian,

Thanks for the great example... couple of things...

on the notes page of:
http://www.wssdemo.com/Project/Shared%20Documents/display.aspx

and walking through trying to duplicate your example of projects --> tasks

I am having trouble with the Projects DVWP and the Filter on ID with
[Input
Parameter]. It will not filter with that. It should be the selected
project
it will then filter it on correct? I can get nothing filtered (or any
values)
with prjects there when I change the Client Parameter Bindings like the
example:

udc:ClientParameterBindings
udc:ClientParameterBinding Name="filterParam"
Location="Postback;Connection;QueryString(ID)" DefaultValue=""/
/udc:ClientParameterBindings

but if I 'hardcode' the default value (DefaultValue="2" for example) to a
valid project ID then I can successfully filter the Tasks for that
'hardcoded' project. Of course, I want to pull those dynamically from the
selected project ID (like yours is doing). Any idea why that [Input
Parameter] is not taking? Also, once the filter is working do you then
hide
the Project DVWP somehow? How?

thanks,
Kevin H.

"Ian Morrish" wrote:

Hi,
I have done something similar but for Project/tasks
See http://www.wssdemo.com/Project/Lists/Project/DispForm.aspx?ID=3
Up at the home page are some notes on how to do it.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:72CCAA5B-5177-4715-8987-61C3DE75615A@microsoft.com...
Perhaps this is a Frontpage Group question, but here it is:

I have a SharePoint list of customers and when I drill into to the
display
page (DispForm.aspx) I want to filter a Data View Web part (DVWP) for
the
contacts associated with that customer (so you only see the contacts
related
to Customer A for example). I should be able to do this with a DVWP in
Frontpage? No? I have tried filtering the Contacts DVWP with a
customerID
=
'@ID' etc. and with no luck. Any idears on how to configure this as a
web
part?

Kevin H.





Back to top
Ian Morrish
Guest





Posted: Sat Jan 15, 2005 5:17 am    Post subject: Re: Filtered List View Web Part Reply with quote

QueryString(ID) should pick up the ?ID=xx value from the URL.
You could try adding the DVWP to a normal web part page and test by adding
the url parameter to the browser.
The modification is based on this KB
http://support.microsoft.com/default.aspx?scid=kb;en-us;831093

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:B709AEBC-1AAA-4F7D-B583-7AFB643C6308@microsoft.com...
Quote:
Hi Ian,

That Client Parameter Binding is exactly what I have on the Projects DVWP.
It is not filtering on the project. When I hardcode the Default Value it
filters it then. Does the parameter need a @ID or anything?

KH

"Ian Morrish" wrote:

The <udc:ClientParameterBinding Name="filterParam"
Location="Postback;Connection;QueryString(ID)" DefaultValue=""/
goes on the DVWP that is bound to the Project list, not the task list
DVWP
(you may have modified the wrong DVWP on the page). This DVWP is only
required so that we can make a web part connection to the Tasks list.
Unfortunately the web part that displays the Project details that is
already
on the page doesn't support connections.

You can hide the Project DVWP by setting it to a closed state in the
display
properties. I only have it displayed in the demo so that you can see it
is
part of the solution.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:4EB69870-1B83-4C02-A9BF-F81C923AAC3B@microsoft.com...
Ian,

Thanks for the great example... couple of things...

on the notes page of:
http://www.wssdemo.com/Project/Shared%20Documents/display.aspx

and walking through trying to duplicate your example of projects --
tasks

I am having trouble with the Projects DVWP and the Filter on ID with
[Input
Parameter]. It will not filter with that. It should be the selected
project
it will then filter it on correct? I can get nothing filtered (or any
values)
with prjects there when I change the Client Parameter Bindings like the
example:

udc:ClientParameterBindings
udc:ClientParameterBinding Name="filterParam"
Location="Postback;Connection;QueryString(ID)" DefaultValue=""/
/udc:ClientParameterBindings

but if I 'hardcode' the default value (DefaultValue="2" for example) to
a
valid project ID then I can successfully filter the Tasks for that
'hardcoded' project. Of course, I want to pull those dynamically from
the
selected project ID (like yours is doing). Any idea why that [Input
Parameter] is not taking? Also, once the filter is working do you then
hide
the Project DVWP somehow? How?

thanks,
Kevin H.

"Ian Morrish" wrote:

Hi,
I have done something similar but for Project/tasks
See http://www.wssdemo.com/Project/Lists/Project/DispForm.aspx?ID=3
Up at the home page are some notes on how to do it.

Regards,
Ian
http://www.wssdemo.com

"Kevin H." <KevinH@discussions.microsoft.com> wrote in message
news:72CCAA5B-5177-4715-8987-61C3DE75615A@microsoft.com...
Perhaps this is a Frontpage Group question, but here it is:

I have a SharePoint list of customers and when I drill into to the
display
page (DispForm.aspx) I want to filter a Data View Web part (DVWP)
for
the
contacts associated with that customer (so you only see the contacts
related
to Customer A for example). I should be able to do this with a DVWP
in
Frontpage? No? I have tried filtering the Contacts DVWP with a
customerID
=
'@ID' etc. and with no luck. Any idears on how to configure this as
a
web
part?

Kevin H.





Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB