none
How to pass multiple query string values using the same parameter in Query String (URL) Filter Web Part

    Question

  • 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

    THanks! Arup R(MCTS) SucCeSS DoEs NOT MatTer.
    • Moved by Mike Walsh FIN Tuesday, March 16, 2010 3:40 PM admin q (From:SharePoint - Design and Customization (pre-SharePoint 2010))
    Tuesday, March 16, 2010 2:23 PM

All replies

  • 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.

    Wednesday, March 17, 2010 1:01 AM
  • Yes Paul, I have set "Send All Values". Can you please guide or suggest to solve this problem?

    Thanks | Arup
    THanks! Arup R(MCTS) SucCeSS DoEs NOT MatTer.
    Wednesday, March 17, 2010 5:27 AM

  • 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
    THanks! Arup R(MCTS) SucCeSS DoEs NOT MatTer.
    Wednesday, March 17, 2010 5:36 AM
  • 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?
    Wednesday, March 17, 2010 5:37 AM
  • Hi Paul,

    I have set "Send All Values" in Advanced Filter Options. But still it return same result.
    THanks! Arup R(MCTS) SucCeSS DoEs NOT MatTer.
    Wednesday, March 17, 2010 6:10 AM
  • 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?
    Wednesday, March 17, 2010 2:20 PM
  • 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?



    THanks! Arup R(MCTS) SucCeSS DoEs NOT MatTer.
    Wednesday, March 17, 2010 5:49 PM
  • 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
    Wednesday, March 17, 2010 5:54 PM
  • thanks Paul..
    THanks! Arup R(MCTS) SucCeSS DoEs NOT MatTer.
    Wednesday, March 17, 2010 6:07 PM
  • Did you find a way around this?
    Thursday, October 20, 2011 10:32 PM
  • Hi Arup,

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

    Let me know if you get something on this.


    Ashish Mishra MCTS, MCPD in SharePoint 2010

    Monday, May 21, 2012 1:57 PM
  • 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.

    Friday, July 13, 2012 8:43 PM
  • Workaround is to use a calculated field for the OR logic, and then filter on the calculated field.
    Wednesday, October 02, 2013 12:53 PM
  • 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.html


    DH


    • Edited by DHarv Sunday, January 04, 2015 3:31 PM
    Sunday, January 04, 2015 3:31 PM
  • 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

    Wednesday, January 07, 2015 10:42 PM
  • Ingo,

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


    DH


    • Edited by DHarv Thursday, January 08, 2015 4:15 AM
    Thursday, January 08, 2015 4:14 AM
  • 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

    Saturday, January 10, 2015 11:59 PM
  • Hi Arup,

    I am also looking for the same solution.

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


    Regards Sourabh Soni

    Tuesday, February 24, 2015 5:00 AM
  • Ingo,

    Thanks for the response. That cleared it up.


    DH

    Tuesday, February 24, 2015 5:03 AM
  • Hi ,I’m 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 . 

    14 hours 44 minutes ago