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

  • 질문

  • 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.
    • 이동됨 Mike Walsh FIN 2010년 3월 16일 화요일 오후 3:40 admin q (From:SharePoint - Design and Customization (pre-SharePoint 2010))
    2010년 3월 16일 화요일 오후 2:23

모든 응답

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

    2010년 3월 17일 수요일 오전 1:01
  • 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.
    2010년 3월 17일 수요일 오전 5:27

  • 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.
    2010년 3월 17일 수요일 오전 5:36
  • 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?
    2010년 3월 17일 수요일 오전 5:37
  • 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.
    2010년 3월 17일 수요일 오전 6:10
  • 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?
    • 답변으로 표시됨 GuYuming 2010년 3월 24일 수요일 오전 10:00
    • 답변으로 표시 취소됨 Arup Biswas 2010년 3월 29일 월요일 오전 11:18
    2010년 3월 17일 수요일 오후 2:20
  • 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.
    2010년 3월 17일 수요일 오후 5:49
  • 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)
    • 편집됨 Paul Lucas 2010년 3월 17일 수요일 오후 7:18
    2010년 3월 17일 수요일 오후 5:54
  • thanks Paul..
    THanks! Arup R(MCTS) SucCeSS DoEs NOT MatTer.
    2010년 3월 17일 수요일 오후 6:07
  • Did you find a way around this?
    2011년 10월 20일 목요일 오후 10:32
  • 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

    2012년 5월 21일 월요일 오후 1:57
  • 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.

    2012년 7월 13일 금요일 오후 8:43
  • Workaround is to use a calculated field for the OR logic, and then filter on the calculated field.
    2013년 10월 2일 수요일 오후 12:53
  • 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


    • 편집됨 DHarv 2015년 1월 4일 일요일 오후 3:31
    2015년 1월 4일 일요일 오후 3:31
  • 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

    2015년 1월 7일 수요일 오후 10:42
  • Ingo,

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


    DH


    • 편집됨 DHarv 2015년 1월 8일 목요일 오전 4:15
    2015년 1월 8일 목요일 오전 4:14
  • 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

    2015년 1월 10일 토요일 오후 11:59
  • Hi Arup,

    I am also looking for the same solution.

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


    Regards Sourabh Soni

    2015년 2월 24일 화요일 오전 5:00
  • Ingo,

    Thanks for the response. That cleared it up.


    DH

    2015년 2월 24일 화요일 오전 5:03
  • 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 . 

    2015년 8월 31일 월요일 오전 3:30
  • I resolved this by creating a single [dollar sign] delimited parameter and splitting it using jquery on the target pages..

    regards, Andy

    2016년 4월 12일 화요일 오후 9:33
  • I know the post is 3 years old...

    Can you add the jquery code?


    RobBob

    2019년 9월 30일 월요일 오후 8:47