none
QueryFilter returns count but doesn't disply items RRS feed

  • Question

  • I am using following query filter to filter items from customer list.

    Following is data in my list.

    State Customer Address

    NJ 00055000 28 Foest Dr
    NJ 00060000 45 Drive
    NJ 00078000 468 Millburn Ave
    PA 00098000 85 Main Street
    PA 00045000 456 Pine Street
    PA 00055000 85 Springfield Ave
    PA 00085000 456 Pine Street

    When Queryfilter ?FilterField1=Customer&FilterValue1=00055000&FilterOp1=Contains  is applied I get Output as expected. One matching record for NJ and PA.

    NJ (1)

    00055000 28 Foest Dr

    PA (1)

    PA 00055000 85 Springfield Ave

    Now if change filter to ?FilterField1=Customer&FilterValue1=55000&FilterOp1=Contains. It seems like query is working, Numbers of items in the group counts are 1 for each state. However details are missing. This is when group (Group By State) settings are set to Show groupings collapsed by default.

    NJ (1)

    PA (1)


    When I changed group settings to Show groupings Expanded default,  ?FilterField1=Customer&FilterValue1=55000&FilterOp1=Contains worked as expected as show in below image.

    NJ (1)

    00055000 28 Foest Dr

    PA (1)

    PA 00055000 85 Springfield Ave

    Is this know issue with Query Filter? View Style is "Default" in both cases.

    Friday, March 24, 2017 5:54 PM

All replies

  • Hi,

    I can also reproduce this issue in my test environment SharePoint 2013 and SharePoint Online.

    If you want to show groupings collapsed by default, as a workaround, we can set the Group By Expanded in list view settings, then add some JavaScript to make the items collapsed.

    The following article for your reference:

    Expand-Collapse All Groups in SharePoint 2013 List Views using jQuery

    http://www.sharepointdiary.com/2014/07/expand-collapse-all-groups-in-sharepoint-2013-list-view-jquery.html

    Best Regards,

    Dennis


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Tuesday, March 28, 2017 8:52 AM
    Moderator
  • Dennis,

    Thanks for reply. We are already using the this approach where Group By Expanded in list view settings.

    For me it looks like bug.

    List View web part returns correct results in expanded mode and only correct count, but no result in collapsed mode, when Filter is "Contains" and criteria is to search within word, not entire word.

    Regards,

    Rajesh

    Wednesday, March 29, 2017 6:47 PM
  • Hi Rajesh,

    In currently, I suggest you use the workaround to achieve your requirement.

    Best Regards,

    Dennis


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Wednesday, April 5, 2017 1:40 AM
    Moderator