In two previous posts I detailed a method of using partial text
in a search filter on a data view web part. You can find the posts
here:
Part
1
Part
2
Multiple Searches
Up until now I have always created one page per search, but some
of my users started to complain that this meant more time was taken
up keep changing pages so I started to look into how to create
multiple searches on the same page.
So my page has a data view web part and a three text searches
added.

Parameters
The next step is to add the parameters that I will use to filter
the list
To do this highlight the data view web part and select
Parameters from the ribbon

The image below shows the 3 parameters I have added, in each case
the source is a query string and the variable should match exactly
the title of the column you will be searching on

Filters
I now need to add the filters to the data view web part
To do this highlight the data view web part and from the ribbon
select Filter

The filtering uses a series of And/Or options to
filter the data that is presented in the data view web part
The image below shows the criteria that will be used to filter the
data view

Using the Or option means that the filter will
look for any one of the first 3 criteria AND the
final criteria, so for example it could filter the data on
Year AND ARCode or any one of the 3
combinations
Filter Connections
I now need to connect the text filters to the data view web
part
To do this right click the first text filter and click Add
Connection

Select Send Filter Values To and click
Next

Leave the default selected and click Next

On this screen select the data view web part you want to connect
to, set the target action to Get Parameters From
and click Next

On this screen you need to match the text filter to the
Parameters you set earlier in the process. If you
title your text filters to match what they are going to filter on
it makes it a lot easier
Now click on Next & Finish
So that's the text filter setup, you only need to repeat the
process for each text filter on the page changing the setting for
the last screen
Final Results
If we now navigate to the page we can test out the filters
Lets start with a surname that is in the data

As you can see it brings up data of a user with Smith in their
name
So what about the other searches

So that's the tutor group search working as well
And finally the year search

Alan
Richards has been working in Schools for 17 years and
during that time has been at the forefront of using IT. As well as
managing his own school's SharePoint implementation he also manages
the SharePoint farm for the local consortium of schools. Alan is
also a regular blogger and speaker at various events.
Check out our new resource centre for more insightful work
from Alan .
Stay tuned for more SharePoint content
by joining our
community or by following us on twitter or facebook.