Forum Discussion

Mike Jansen's avatar
Mike Jansen
Iron Contributor
Apr 05, 2017
Solved

Call "standard" search result page (or webpart) from custom query

I have a document library with a lot of documents (+1000). The documents have a "Label" column. I created a script which reads all those different Labels and populates a dropdown:   When I s...
developer
Document Library
SharePoint Online
  • Mikael Svenson's avatar
    Mikael Svenson
    Apr 07, 2017
    You need to construct the KQL to pass to limit for what you need:

    /_layouts/15/osssearchresults.aspx?u=https://..path-to-document-library&k=myterm prop1:propvalue

    If you column with a property is a site column it will have generated an automatic managed property for you which you can query for. Say you have a text site column named "Foo", then the managed property would be named FooOWSTEXT, and you query would be:

    /_layouts/15/osssearchresults.aspx?u=https://..path-to-document-library&k=myterm FooOWSTEXT:label
Mike Jansen's avatar
Mike Jansen
Iron Contributor
Apr 05, 2017
Ok, but how do I trigger that from code? Especially using a search web part.
When I push the search button, this query is generated and fired:

https://blabla.sharepoint.com/_api/web/lists/getByTitle('Documents')/items?$select=FileLeafRef,FileRef,File_x0020_Type,Categorie,Label/Title&$expand=Label&$filter=Label/Title eq %27"+ inputLabel +"%27&rowlimit=500

Inputlabel is the result from my dropdown.

Would be something like: "Currentsite/result.aspx?k="myquery" ?

Is it also possible to stay on the current site, without a complete page refresh?
paulpascha's avatar
paulpascha
Bronze Contributor
Apr 05, 2017

The value of the "k" querystring parameter is read by the Search Results Web Part. In other words, if you put a Search Results Web Part on your page you should be able to start querying by appending the k Query String parameter with your search term value to the URL and see the results. You can use JavaScript to request a specific page (or the page you're currently on) appending the required querystring parameter.

 

 

  • Mike Jansen's avatar
    Mike Jansen
    Iron Contributor
    Apr 05, 2017
    I'll give it a try.
    Let you know the result.

    Thanks, Mike
    • Mike Jansen's avatar
      Mike Jansen
      Iron Contributor
      Apr 06, 2017

      I tried a, long, night to get it running. But no luck.

       

      I try to manipulate the search URL. But it look like is is not possible with only the "k=" parameter. As far as I can see I can only pass a search keyword. But I need to pass, a keyword, a document library and a property of the documents.

       

      "Show all documents(from document library X) with keyword "Dog" where label is some lookupvalue"

       

      The search api query I use now is:

      https://blabla.sharepoint.com//_api/web/lists/getByTitle('Documents')/items?$select=FileLeafRef,FileRef,File_x0020_Type,Categorie,Label/Title&$expand=Label&$filter=Label/Title eq %27"+ inputLabel +"%27&rowlimit=500

      All I want is to pass the results to a standaard search webpart or page.

       

      • Mikael Svenson's avatar
        Mikael Svenson
        Iron Contributor
        Apr 07, 2017
        You need to construct the KQL to pass to limit for what you need:

        /_layouts/15/osssearchresults.aspx?u=https://..path-to-document-library&k=myterm prop1:propvalue

        If you column with a property is a site column it will have generated an automatic managed property for you which you can query for. Say you have a text site column named "Foo", then the managed property would be named FooOWSTEXT, and you query would be:

        /_layouts/15/osssearchresults.aspx?u=https://..path-to-document-library&k=myterm FooOWSTEXT:label

Resources