COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing something wrong. It says,
"There are no items to show in this view of the "test" list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column
4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"
8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target Action "Get Sort/Filder
From"
Columns in Form Web Part "T1" Columns in test "Last_Name"
Finished
11. Saved the page

What did I do wrong?


John


"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl...
> Sorry I'm jumping in here late. I believe the steps below will get you
what
> you want using Connections from within FrontPage 2003...
>
> Convert the view you want to be filtered into a Data View Web Part using
> FrontPage
> Create a filter where your Field Name CONTAINS [Input Parameter]
>
> Insert a Form Web Part onto the page
> Use Web Part connections to pass the Form value as a parameter to the Data
> View
>
> Save the page.
>
> --
> Thanks!
> John Jansen
> Microsoft Office FrontPage
> This posting is provided "AS IS" with no warranties, and confers no
rights.

Re: John Jansen by John

John
Wed Jan 14 15:09:22 CST 2004

So close...

See inline.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <xxxjohnzzz@patmedia.net> wrote in message
news:%23s2Qi$t2DHA.3216@TK2MSFTNGP11.phx.gbl...
> COPIED FROM microsoft.publiv.sharepoint.windowsservices
>
>
> John,
>
> I like your suggestion, but I am obviously doing something wrong. It says,
> "There are no items to show in this view of the "test" list.
>
> Here is what I did.
>
> 1. Opened the Sharepoint site with FrontPage 2003
> 2. Created a Web Part page
> 3. Dragged the "test" list to the right column

Here you have inserted a List View Web Part, but what you want is a Data
View Web Part (they are similar, but just different enough). So Right click
the view and choose "Convert to XSLT Data View" (there are other ways to get
a data view, but this is the easiest).

> 4. Right click to open "List View Properties"
> 5. Clicked on Filter
> 6. Clicked on "Click here to add a new clause"
> 7. Entered Field Name "Last_Name"
> Comparison "Contains"
> Value "[T1]"

When you have a data view, the Value drop-down will be populated with
available Parameters. From the Value drop-down menu choose "[Input
Parameter]"


> 8. Dragged the "Form Web Part" to the left column
> 9. Right click on "Form Web Part" to open Web Part Connections Wizard
> 10. Entered:
> Provide Form Values To
> Connect to a Web Part on this Page
> Target Web Part "test" Target Action "Get Sort/Filder
> From"

Your target action should be "Modify view using Parameters From..."

> Columns in Form Web Part "T1" Columns in test
"Last_Name"

Columns in Form: T1, but columns in test will be [Input Parameter]

> Finished
> 11. Saved the page
>

And now you need to preview in the Browser (hit F12) and type some value
into the Form field and hit Submit.

That should do it.

> What did I do wrong?
>
>
> John
>
>
> "John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
> news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl...
> > Sorry I'm jumping in here late. I believe the steps below will get you
> what
> > you want using Connections from within FrontPage 2003...
> >
> > Convert the view you want to be filtered into a Data View Web Part using
> > FrontPage
> > Create a filter where your Field Name CONTAINS [Input Parameter]
> >
> > Insert a Form Web Part onto the page
> > Use Web Part connections to pass the Form value as a parameter to the
Data
> > View
> >
> > Save the page.
> >
> > --
> > Thanks!
> > John Jansen
> > Microsoft Office FrontPage
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>



Re: John Jansen by John

John
Wed Jan 14 15:32:29 CST 2004

John,

It works perfectly!!

Where can I read more about the differences between the List View and Data
View Web Parts?

Thanks!!
John


"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
news:OzzbxKu2DHA.2408@tk2msftngp13.phx.gbl...
> So close...
>
> See inline.
>
> --
> Thanks!
> John Jansen
> Microsoft Office FrontPage
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "John" <xxxjohnzzz@patmedia.net> wrote in message
> news:%23s2Qi$t2DHA.3216@TK2MSFTNGP11.phx.gbl...
> > COPIED FROM microsoft.publiv.sharepoint.windowsservices
> >
> >
> > John,
> >
> > I like your suggestion, but I am obviously doing something wrong. It
says,
> > "There are no items to show in this view of the "test" list.
> >
> > Here is what I did.
> >
> > 1. Opened the Sharepoint site with FrontPage 2003
> > 2. Created a Web Part page
> > 3. Dragged the "test" list to the right column
>
> Here you have inserted a List View Web Part, but what you want is a Data
> View Web Part (they are similar, but just different enough). So Right
click
> the view and choose "Convert to XSLT Data View" (there are other ways to
get
> a data view, but this is the easiest).
>
> > 4. Right click to open "List View Properties"
> > 5. Clicked on Filter
> > 6. Clicked on "Click here to add a new clause"
> > 7. Entered Field Name "Last_Name"
> > Comparison "Contains"
> > Value "[T1]"
>
> When you have a data view, the Value drop-down will be populated with
> available Parameters. From the Value drop-down menu choose "[Input
> Parameter]"
>
>
> > 8. Dragged the "Form Web Part" to the left column
> > 9. Right click on "Form Web Part" to open Web Part Connections Wizard
> > 10. Entered:
> > Provide Form Values To
> > Connect to a Web Part on this Page
> > Target Web Part "test" Target Action "Get
Sort/Filder
> > From"
>
> Your target action should be "Modify view using Parameters From..."
>
> > Columns in Form Web Part "T1" Columns in test
> "Last_Name"
>
> Columns in Form: T1, but columns in test will be [Input Parameter]
>
> > Finished
> > 11. Saved the page
> >
>
> And now you need to preview in the Browser (hit F12) and type some value
> into the Form field and hit Submit.
>
> That should do it.
>
> > What did I do wrong?
> >
> >
> > John
> >
> >
> > "John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
> > news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl...
> > > Sorry I'm jumping in here late. I believe the steps below will get
you
> > what
> > > you want using Connections from within FrontPage 2003...
> > >
> > > Convert the view you want to be filtered into a Data View Web Part
using
> > > FrontPage
> > > Create a filter where your Field Name CONTAINS [Input Parameter]
> > >
> > > Insert a Form Web Part onto the page
> > > Use Web Part connections to pass the Form value as a parameter to the
> Data
> > > View
> > >
> > > Save the page.
> > >
> > > --
> > > Thanks!
> > > John Jansen
> > > Microsoft Office FrontPage
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
>
>



re: ATTN: John Jansen by Jim

Jim
Wed Jan 14 16:54:57 CST 2004

I don't believe you need to do steps 5-7. In fact, I think
these are filtering on the literal "[T1]".

Step 10 should set up all the filtering you need.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------



>-----Original Message-----
>COPIED FROM microsoft.publiv.sharepoint.windowsservices
>
>
>John,
>
>I like your suggestion, but I am obviously doing
something wrong. It says,
>"There are no items to show in this view of the "test"
list.
>
>Here is what I did.
>
>1. Opened the Sharepoint site with FrontPage 2003
>2. Created a Web Part page
>3. Dragged the "test" list to the right column
>4. Right click to open "List View Properties"
>5. Clicked on Filter
>6. Clicked on "Click here to add a new clause"
>7. Entered Field Name "Last_Name"
> Comparison "Contains"
> Value "[T1]"
>8. Dragged the "Form Web Part" to the left column
>9. Right click on "Form Web Part" to open Web Part
Connections Wizard
>10. Entered:
> Provide Form Values To
> Connect to a Web Part on this Page
> Target Web Part "test" Target
Action "Get Sort/Filder
>From"
> Columns in Form Web Part "T1" Columns in
test "Last_Name"
> Finished
>11. Saved the page
>
>What did I do wrong?
>
>
>John
>
>
>"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote
in message
>news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl...
>> Sorry I'm jumping in here late. I believe the steps
below will get you
>what
>> you want using Connections from within FrontPage 2003...
>>
>> Convert the view you want to be filtered into a Data
View Web Part using
>> FrontPage
>> Create a filter where your Field Name CONTAINS [Input
Parameter]
>>
>> Insert a Form Web Part onto the page
>> Use Web Part connections to pass the Form value as a
parameter to the Data
>> View
>>
>> Save the page.
>>
>> --
>> Thanks!
>> John Jansen
>> Microsoft Office FrontPage
>> This posting is provided "AS IS" with no warranties,
and confers no
>rights.
>
>
>.
>

Re: ATTN: John Jansen by John

John
Thu Jan 15 11:08:30 CST 2004

Hi Jim, you are right about the fact that his steps would have him filtering
on the string [T1], that's why I made sure to specify choosing [Input
Paramter] from the drop-down. Since List View web parts don't provide this
parameter from the drop-down, he must have been confused and just typed in
his own value.

However, you do still need to perform steps 5 - 7 or else the view you
connect to would take in the parameter but have no idea what to do with it.

The thing that causes confusion here is that in order to do the "Contains"
side of things, you cannot just set up connections that perform the
filtering for you, you need to set up the filter first and pass it a
parameter which populates the Contains clause via connections.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim Buyens" <anonymous@discussions.microsoft.com> wrote in message
news:03d701c3daf1$6e785820$a401280a@phx.gbl...
> I don't believe you need to do steps 5-7. In fact, I think
> these are filtering on the literal "[T1]".
>
> Step 10 should set up all the filtering you need.
>
> Jim Buyens
> Microsoft FrontPage MVP
> http://www.interlacken.com
> Author of:
> *----------------------------------------------------
> |\---------------------------------------------------
> || Microsoft Office FrontPage 2003 Inside Out
> ||---------------------------------------------------
> || Web Database Development Step by Step .NET Edition
> || Microsoft FrontPage Version 2002 Inside Out
> || Faster Smarter Beginning Programming
> || (All from Microsoft Press)
> |/---------------------------------------------------
> *----------------------------------------------------
>
>
>
> >-----Original Message-----
> >COPIED FROM microsoft.publiv.sharepoint.windowsservices
> >
> >
> >John,
> >
> >I like your suggestion, but I am obviously doing
> something wrong. It says,
> >"There are no items to show in this view of the "test"
> list.
> >
> >Here is what I did.
> >
> >1. Opened the Sharepoint site with FrontPage 2003
> >2. Created a Web Part page
> >3. Dragged the "test" list to the right column
> >4. Right click to open "List View Properties"
> >5. Clicked on Filter
> >6. Clicked on "Click here to add a new clause"
> >7. Entered Field Name "Last_Name"
> > Comparison "Contains"
> > Value "[T1]"
> >8. Dragged the "Form Web Part" to the left column
> >9. Right click on "Form Web Part" to open Web Part
> Connections Wizard
> >10. Entered:
> > Provide Form Values To
> > Connect to a Web Part on this Page
> > Target Web Part "test" Target
> Action "Get Sort/Filder
> >From"
> > Columns in Form Web Part "T1" Columns in
> test "Last_Name"
> > Finished
> >11. Saved the page
> >
> >What did I do wrong?
> >
> >
> >John
> >
> >
> >"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote
> in message
> >news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl...
> >> Sorry I'm jumping in here late. I believe the steps
> below will get you
> >what
> >> you want using Connections from within FrontPage 2003...
> >>
> >> Convert the view you want to be filtered into a Data
> View Web Part using
> >> FrontPage
> >> Create a filter where your Field Name CONTAINS [Input
> Parameter]
> >>
> >> Insert a Form Web Part onto the page
> >> Use Web Part connections to pass the Form value as a
> parameter to the Data
> >> View
> >>
> >> Save the page.
> >>
> >> --
> >> Thanks!
> >> John Jansen
> >> Microsoft Office FrontPage
> >> This posting is provided "AS IS" with no warranties,
> and confers no
> >rights.
> >
> >
> >.
> >



Re: ATTN: John Jansen by John

John
Thu Jan 15 13:20:20 CST 2004

John,

Can I pass more than one parameter?

John

"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
news:OUPZ0o42DHA.484@TK2MSFTNGP10.phx.gbl...
> Hi Jim, you are right about the fact that his steps would have him
filtering
> on the string [T1], that's why I made sure to specify choosing [Input
> Paramter] from the drop-down. Since List View web parts don't provide
this
> parameter from the drop-down, he must have been confused and just typed in
> his own value.
>
> However, you do still need to perform steps 5 - 7 or else the view you
> connect to would take in the parameter but have no idea what to do with
it.
>
> The thing that causes confusion here is that in order to do the "Contains"
> side of things, you cannot just set up connections that perform the
> filtering for you, you need to set up the filter first and pass it a
> parameter which populates the Contains clause via connections.
>
> --
> Thanks!
> John Jansen
> Microsoft Office FrontPage
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Jim Buyens" <anonymous@discussions.microsoft.com> wrote in message
> news:03d701c3daf1$6e785820$a401280a@phx.gbl...
> > I don't believe you need to do steps 5-7. In fact, I think
> > these are filtering on the literal "[T1]".
> >
> > Step 10 should set up all the filtering you need.
> >
> > Jim Buyens
> > Microsoft FrontPage MVP
> > http://www.interlacken.com
> > Author of:
> > *----------------------------------------------------
> > |\---------------------------------------------------
> > || Microsoft Office FrontPage 2003 Inside Out
> > ||---------------------------------------------------
> > || Web Database Development Step by Step .NET Edition
> > || Microsoft FrontPage Version 2002 Inside Out
> > || Faster Smarter Beginning Programming
> > || (All from Microsoft Press)
> > |/---------------------------------------------------
> > *----------------------------------------------------
> >
> >
> >
> > >-----Original Message-----
> > >COPIED FROM microsoft.publiv.sharepoint.windowsservices
> > >
> > >
> > >John,
> > >
> > >I like your suggestion, but I am obviously doing
> > something wrong. It says,
> > >"There are no items to show in this view of the "test"
> > list.
> > >
> > >Here is what I did.
> > >
> > >1. Opened the Sharepoint site with FrontPage 2003
> > >2. Created a Web Part page
> > >3. Dragged the "test" list to the right column
> > >4. Right click to open "List View Properties"
> > >5. Clicked on Filter
> > >6. Clicked on "Click here to add a new clause"
> > >7. Entered Field Name "Last_Name"
> > > Comparison "Contains"
> > > Value "[T1]"
> > >8. Dragged the "Form Web Part" to the left column
> > >9. Right click on "Form Web Part" to open Web Part
> > Connections Wizard
> > >10. Entered:
> > > Provide Form Values To
> > > Connect to a Web Part on this Page
> > > Target Web Part "test" Target
> > Action "Get Sort/Filder
> > >From"
> > > Columns in Form Web Part "T1" Columns in
> > test "Last_Name"
> > > Finished
> > >11. Saved the page
> > >
> > >What did I do wrong?
> > >
> > >
> > >John
> > >
> > >
> > >"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote
> > in message
> > >news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl...
> > >> Sorry I'm jumping in here late. I believe the steps
> > below will get you
> > >what
> > >> you want using Connections from within FrontPage 2003...
> > >>
> > >> Convert the view you want to be filtered into a Data
> > View Web Part using
> > >> FrontPage
> > >> Create a filter where your Field Name CONTAINS [Input
> > Parameter]
> > >>
> > >> Insert a Form Web Part onto the page
> > >> Use Web Part connections to pass the Form value as a
> > parameter to the Data
> > >> View
> > >>
> > >> Save the page.
> > >>
> > >> --
> > >> Thanks!
> > >> John Jansen
> > >> Microsoft Office FrontPage
> > >> This posting is provided "AS IS" with no warranties,
> > and confers no
> > >rights.
> > >
> > >
> > >.
> > >
>
>



Re: ATTN: John Jansen by John

John
Thu Jan 15 13:32:40 CST 2004

Yeah, you just need to create new ones in the XSLT (copy and paste the
filterParam we create by default and give it a new name).

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <xxxjohnzzz@patmedia.net> wrote in message
news:%23qS1ey52DHA.2556@TK2MSFTNGP10.phx.gbl...
> John,
>
> Can I pass more than one parameter?
>
> John
>
> "John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
> news:OUPZ0o42DHA.484@TK2MSFTNGP10.phx.gbl...
> > Hi Jim, you are right about the fact that his steps would have him
> filtering
> > on the string [T1], that's why I made sure to specify choosing [Input
> > Paramter] from the drop-down. Since List View web parts don't provide
> this
> > parameter from the drop-down, he must have been confused and just typed
in
> > his own value.
> >
> > However, you do still need to perform steps 5 - 7 or else the view you
> > connect to would take in the parameter but have no idea what to do with
> it.
> >
> > The thing that causes confusion here is that in order to do the
"Contains"
> > side of things, you cannot just set up connections that perform the
> > filtering for you, you need to set up the filter first and pass it a
> > parameter which populates the Contains clause via connections.
> >
> > --
> > Thanks!
> > John Jansen
> > Microsoft Office FrontPage
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Jim Buyens" <anonymous@discussions.microsoft.com> wrote in message
> > news:03d701c3daf1$6e785820$a401280a@phx.gbl...
> > > I don't believe you need to do steps 5-7. In fact, I think
> > > these are filtering on the literal "[T1]".
> > >
> > > Step 10 should set up all the filtering you need.
> > >
> > > Jim Buyens
> > > Microsoft FrontPage MVP
> > > http://www.interlacken.com
> > > Author of:
> > > *----------------------------------------------------
> > > |\---------------------------------------------------
> > > || Microsoft Office FrontPage 2003 Inside Out
> > > ||---------------------------------------------------
> > > || Web Database Development Step by Step .NET Edition
> > > || Microsoft FrontPage Version 2002 Inside Out
> > > || Faster Smarter Beginning Programming
> > > || (All from Microsoft Press)
> > > |/---------------------------------------------------
> > > *----------------------------------------------------
> > >
> > >
> > >
> > > >-----Original Message-----
> > > >COPIED FROM microsoft.publiv.sharepoint.windowsservices
> > > >
> > > >
> > > >John,
> > > >
> > > >I like your suggestion, but I am obviously doing
> > > something wrong. It says,
> > > >"There are no items to show in this view of the "test"
> > > list.
> > > >
> > > >Here is what I did.
> > > >
> > > >1. Opened the Sharepoint site with FrontPage 2003
> > > >2. Created a Web Part page
> > > >3. Dragged the "test" list to the right column
> > > >4. Right click to open "List View Properties"
> > > >5. Clicked on Filter
> > > >6. Clicked on "Click here to add a new clause"
> > > >7. Entered Field Name "Last_Name"
> > > > Comparison "Contains"
> > > > Value "[T1]"
> > > >8. Dragged the "Form Web Part" to the left column
> > > >9. Right click on "Form Web Part" to open Web Part
> > > Connections Wizard
> > > >10. Entered:
> > > > Provide Form Values To
> > > > Connect to a Web Part on this Page
> > > > Target Web Part "test" Target
> > > Action "Get Sort/Filder
> > > >From"
> > > > Columns in Form Web Part "T1" Columns in
> > > test "Last_Name"
> > > > Finished
> > > >11. Saved the page
> > > >
> > > >What did I do wrong?
> > > >
> > > >
> > > >John
> > > >
> > > >
> > > >"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote
> > > in message
> > > >news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl...
> > > >> Sorry I'm jumping in here late. I believe the steps
> > > below will get you
> > > >what
> > > >> you want using Connections from within FrontPage 2003...
> > > >>
> > > >> Convert the view you want to be filtered into a Data
> > > View Web Part using
> > > >> FrontPage
> > > >> Create a filter where your Field Name CONTAINS [Input
> > > Parameter]
> > > >>
> > > >> Insert a Form Web Part onto the page
> > > >> Use Web Part connections to pass the Form value as a
> > > parameter to the Data
> > > >> View
> > > >>
> > > >> Save the page.
> > > >>
> > > >> --
> > > >> Thanks!
> > > >> John Jansen
> > > >> Microsoft Office FrontPage
> > > >> This posting is provided "AS IS" with no warranties,
> > > and confers no
> > > >rights.
> > > >
> > > >
> > > >.
> > > >
> >
> >
>
>