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
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.
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
What are you sending the values to?
I have set "Send All Values" in Advanced Filter Options. But still it return same result.
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
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
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.
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 .