Hi,
I want to pass multiple query string values using the same parameter in Query String (URL) Filter Web Part like mentioned below:

http://server/pages/Default.aspx?Title=Arup&Title=Ratan

But it always return those items whose "Title" value is "Arup". It is not returned any items whose "Title" is "Ratan".
I have followed the

http://office.microsoft.com/en-us/sharepointserver/HA102509991033.aspx#1

Please suggest me.



Thanks | Arup

Hi,

In your query string web part properties, under "Advanced Filter Options" there is a setting for handling multiple values.

Do you have this set to "Send All Values" instead of the default "Send only first value"?

Paul.

Yes Paul, I have set "Send All Values". Can you please guide or suggest to solve this problem?

Thanks | Arup

Actually I have a custom list i.e. "AuthorList" which has column "Title". "AuthorList" contains 20 items. Title of 10 items is "Arup" and 5 of them is "Ratan" and rest of that is "Biswas".

I want to filter out using "Query String (URL) Filter Web Part" and get result those items whose Title is "Arup" & "Ratan".

I have tried with the URL but it retruns only those items whose Title is "Arup"

http://server/pages/Default.aspx?Title=Arup&Title=Ratan

Please help me to solve the problem.

Thanks | Arup

Well... that was my suggestion! But I'll have a play around with it and see what I can find :-)

What are you sending the values to?

Hi Paul,

I have set "Send All Values" in Advanced Filter Options. But still it return same result.

To be honest, I'm not sure you will be able to do this with the query string filters. I don't think the issue is with the filter web part, but more with the ListViewWebPart not being able to use multiple values to filter on a single column using "Or" logic.

Unless someone else has a better idea, you might be stuck with just filtering on a single value at a time.

Have you tried creating a view on your list which has filters using or logic?

• Marked as answer by GuYumingMicrosoft contingent staff, Moderator Wednesday, March 24, 2010 10:00 AM
• Unmarked as answer by Arup Biswas Monday, March 29, 2010 11:18 AM

Thanks for quick response ...Well I need dynamic filtration so do you really think dynamic filtration is possible creating views?    Can I achieve converting into XSLT using SPD?

Not sure... It would be way easier to just filter on one Title at a time!!

Maybe someone else will have an idea, but I'm fresh out (unless you want to do some custom development)

• Edited by Paul Lucas Wednesday, March 17, 2010 7:18 PM

thanks Paul..

Did you find a way around this?

Hi Arup,

I think this is a bug. I tried it but no luck !

Let me know if you get something on this.

I two have been trying to get this too work.

I have even tried adding a second webpart to the page to pass in the second value and I recieve a correlation ID error. I too think this is a bug and will be reporting it.

Workaround is to use a calculated field for the OR logic, and then filter on the calculated field.

I have not been able to get the web part to work either.
The work around is to use the built in filter parameters as shown below.

http://server/pages/Default.aspx?FilterName=Title&FilterMultiValue=Arup;Ratan

(The FilterName value must be the name of a column in the list view web part that you are trying to filter, and it must be displayed on the page.)

http://techtrainingnotes.blogspot.com/2012/03/sharepoint-search-filter-or-sort-lists.ht

It worked for me when I don't create the connection from the filter web part but from the report web part. In the advanced options of the query string filter web part check 'send all values'. Then create the connection by editing the report web part '...Connection - Get Filter Values From - Query String Filter. Then you can create the URL by simply concatenate the filters by ampersand '... ?Period=[Time].[Year].[2013]&Period=[Time].[Year].[2014]'.

Hope this helps.

Best Regards, Ingo

Ingo,

When you say "report web part", are you talking about the report viewer web part? I'm confused about this

Hi DH, sorry for not being clear.

It works when I create the connection from that web part that you want to be connected with the Query String Filter Web part. So let's say you created a web part page. Then you could connect a parameterized Excel Workbook to an Excel Web Access Web Part (or a Performance Point Dashboard etc.) and you insert it into your page and add a Query String Filter Web Part . Then you can connect them by editing the Query String Filter Web Part but also by editing the Excel Web Access Web Part. And only when I created from the latter it worked with multiple values for one parameter. If you have any more questions let me know. See you, Ingo

Hi Arup,

I am also looking for the same solution.

Please let me know if you found any solution or workaround.

Ingo,

Thanks for the response. That cleared it up.

Hi ,Im using Query string URL filter  to get URL parameter and connect it to SQL Report viewer Webpart. 

Below is my details .

URL: /test.aspx?StudentID= [v Current Students List].[Student ID].[11111]

QSF parameter name : StudentID

QSF parameter value : [v Current Students List].[Student ID].[StudentID]

My SSRS report only   require  [StudentID] part from in my URL . I need only to pass part of the URL parameter  in to SQL report viewer webpart 

I this can be achieved with  Query string URL filter   ?

Thanks in advance .