Questions tagged [kql]

KQL specifies a syntax for search queries that enables users and application implementers to formulate search queries in a structure that resembles natural language and at the same time allows the specification of Boolean matching rules on text and properties of the searched items

Filter by
Sorted by
Tagged with
0
votes
1answer
26 views

KQL with multi value term field values - SharePoint Online

I have a multivalue page property(MyProperty) pointing to a term set and I have a managed property(MyManagedProperty) Stored values are MyManagedProperty:Value1; Value2; Value3 - at least 10 items ...
1
vote
2answers
55 views

Unable to create result source showing only users where AD property is not empty

SharePoint Online here. I'm trying to create a result source that only contains external users. In local AD we distinguish external users from internal ones with the LDAP property 'company'. This ...
0
votes
1answer
79 views

KQL simplification of multiple string.contains queries

For SharePoint search, I create a KQL query that, among other things, sometimes checks whether an entity has one of several interesting substrings appearing in one particular property. The property ...
1
vote
1answer
303 views

KQL for specific columns not working

I have a SharePoint 2016 on-premises farm that contains a large list of items with several text fields that should be searchable. Drawings: Title Name Building Approval Date Category ...
1
vote
1answer
36 views

Issue with wildcard after one letter + asterisk

I'm trying to investigate what's wrong with my KQL queries and it looks like a bug. For example when I query: It causes error, but for following queries it is ok: How to understand that?
1
vote
1answer
75 views

What is the KQL Syntax to use WebId managed property to restrict the search for particular sub sites by passing the WebId in the QueryText?

I want to restrict the search for some sub sites in my SharePoint 2010 environment. I want to use WebId managed property which represents the GUID of the sub site.
1
vote
1answer
44 views

SharePoint Keyword Query to restrict link to Doc Library, but include content in it?

I'm using a Result Source and successfully pulling back content from a document library. The issue is the search result include the link to the document library itself. Thanks in advance.
0
votes
1answer
53 views

How to do paging in JSOM which is using KQL Query

I want to do optimized paging in JSOM which is using KQL Query. Any help and reference will be helpful. Thanks in advance.
3
votes
1answer
88 views

SharePoint Keyword Query search returns fewer results than default SharePoint search for specific Sub Site

I am trying to retrieve the search result from specific Sub Site using KQL in SharePoint 2010.but I am getting only one result with custom code. However the OOTB Search result returns 5 results for ...
2
votes
1answer
4k views

How to write OR and AND combination in KQL query?

I have to build KQL using combination of multiple AND and OR. I have following query: ((Property1:Value OR Property2:Value) AND (Property3:Value AND Property4:Value)) I have tried above query but it ...
0
votes
1answer
211 views

SharePoint KQL Search string with apostrophe!

I would like to return the search results for the documents which has apostrophe by using KQL (Programatically ) in sharepoint 2016. How can i achieve this ?
1
vote
1answer
403 views

Contains in Keyword Query Language SharePoint 2010

I have SharePoint 2010 list where items are stored names of cities. The field CityName is managed property. I compiled query using KQL with query text: query.QueryText = String.Format("CityName:\"*{...
1
vote
1answer
543 views

What is the KQL syntax to filter by owstaxId managed properties in SharePoint 2010?

My understanding of how to use KQL to query against the automatically created managed properties which have the form of owstaxIdProperty, that is that to query for all items with a given term, the ...
0
votes
0answers
67 views

Keyword Query Language to get all the Items holding particular SharePoint Security group from Site Collection

I have requirement to get all the items from Lists & Document Libraries of entire site collections holding SharePoint Security group name "Inspection" using Keyword Query Language. Can any one ...
3
votes
2answers
2k views

KQL - No Search Result For Exact Match ( '=' ) On Custom Property

There is a site column docowner, hence managed property docownerOWSUSER docowner is user field. In a document library the docowner field has value John Doe Searching query docownerOWSUSER:John Doe ...
3
votes
0answers
70 views

KQL direct url to file + icon

I have 2 questions regarding the KQL (keyword query): Which property should I retrieve to get an URL to a file in results? The property Path"is www.site.com/sites/site/documentlibrary/DispForm.aspx?...
1
vote
1answer
395 views

KQL unable to filter result “starting with”

I'm trying to filter values in a result-source in SharePoint Online. I want for example all values starting with an "A". Initial query: Property:A* - Results "Adam and Mary", but also the unwanted "...
0
votes
1answer
368 views

How to add popular items web part for each user for given amount of time

I have added most popular items web part in SharePoint online 2016 website i have created.Is it possible change the query of the web part so it only displays users most clicked items for given amount ...
3
votes
1answer
161 views

Can a KQL query find pages with tags that match the current page?

The problem I'm trying to solve is I have a content type "wiki page" that contains a custom site column called "features". I have a "issues" folder on my site filled with other "wiki pages" which also ...
1
vote
0answers
114 views

Using KQL in Sharepoint online 2013

I'm using ContentTypeId:0x0108* Path:{Site.Url} AssignedTo:{User.Name}Status<>Completed to sort out all completed tasks. But it does not work. If I use only NOT or -Completed it works, but it ...
1
vote
1answer
116 views

Search in managed navigation term store, get URL

a customer is asking whether it is possible to use SharePoint (2013 and up) search in a term store and (infer) the URL of any hits. To make my example more vivid, imagine a term structure like ...
0
votes
1answer
38 views

Querying several page fields, some empty

This probably has a very straight-forward answer, but I just can't get my head around it. I've built a Search Result Web Part checking whether five column on the page are filled out and if so, ...
5
votes
1answer
2k views

Difference between #k= and ?k= in the url

We have a custom JavaScript input box that passing the search term to the search result in a public SharePoint site. When a user log in to the site and search for stuff, everything works great. ...
0
votes
1answer
202 views

How to pass term guid to CSWP through query string

I'm following this tutorial on how to use kql to query against terms. I've set up a page with a content search web part and in the query builder I've entered this owstaxIdLocation:GP0|#ad491ed9-...
1
vote
0answers
654 views

Query Builder KQL return only items/folders at top level

I'm using content search webparts with cross-site publishing in an on-prem SP2013 site. I've got a result source that is limited to a specific library using Query text: {searchTerms?} (contentclass:...
0
votes
1answer
54 views

Content Search Web Part: Search Fields

I'm having some trouble querying fields with KQL. I have a custom list with a field named "A". The following query returns results: path:"<My URL>" ( title:"<Text that Appears in title&...
2
votes
0answers
505 views

SharePoint 2013 CSOM C# - How to limit results of KeywordQuery to specific folder?

I am currently using SharePoint 2013. I want to limit my results of the query to specific folder within my list. For example entering the oath for the QueryText field: keywordQuery.QueryText = "path:...
2
votes
0answers
302 views

Using Sharepoint 2013 Search.asmx with FQL

I have a website using sharepoint search services to query SP index. After migrating to 2013 I started getting this error: ERROR_BAD_QUERY Error: We didn't understand your search terms. Make sure ...
1
vote
1answer
888 views

KQL wildcard operator problem in Sharepoint 2016 search web part

In my Sharepoint 2013 on-premise environment, I have a page that contain a Content Search WebPart. When I pass some parameters like the firstname or lastname using the wildcard * character in the URL ...
0
votes
2answers
2k views

KQL - How to Create Query That Filters by Dates Within the Past Week (7 Days)

So I'm trying to create a query using KQL where one of the parameters brings back items that fall under a certain date range - only items that got modified within the past 7 days. Here it is below: ...
1
vote
1answer
45 views

Building a navigation with a search result webpart

I'm trying to set up a top level site that displays every Project site, creating a basic navigation. To achieve this I used a Search Result Webpart with a custom query, providing me with the correct ...
4
votes
0answers
2k views

How to escape special characters in a KQL query?

In a list I have a column with these values: MyField ------- foo.A foo.B foo.* I want to search for these values. I've plumbed all managed properties and crawled content. If I search myfield:"foo.",...
1
vote
1answer
988 views

KQL query string parameter default value

I have to filter my search result WP using a query string parameter in the KQL query: myfield:{QueryString.XXXX}. I need to be able to define a default filtering or default value for myfield if the ...
0
votes
1answer
269 views

Get List item version history into Keyword Query Language Search Result

I am using search KQL to show the data within my custom visual web part. I googled for many hours but could not find anything related to List Item version history within search query. Is it possible ...
10
votes
0answers
346 views

Content search and content type

In SP 2013 on-prem publishing site, I have a Content Search WebPart that shows a list of pages by querying for the custom content type id, and it worked fine until I edited the navigation settings on ...
1
vote
1answer
604 views

KQL Query to Get All Blog Posts

I am having trouble formatting a KQL statement which returns all Blog Posts from an entire site collection. Bonus points if I can filter by date posted, to only get newer Blog Posts. I am unsure if ...
3
votes
1answer
2k views

DateTime.Now in KQL

In SP 2013 on-prem, I am using display template and a list to show alerts on the front page of the intranet. I want the alerts to be showed from the list when the list item has a start date that is ...
3
votes
2answers
2k views

Boost site in search results with XRANK / KQL

I have a group of sites included in an enterprise search center. One particular site I'd like to have more weight in search results relevancy than the others. How do I use XRANK to do that? I've made ...
5
votes
2answers
200 views

Custom Search webpart - How to 'drill down' into folders?

We recently deployed a new custom Search Results webpart that utilizes a search scope we setup to query specific document libraries under a site hierarchy and return the results in a web part. The ...
0
votes
1answer
24 views

Specify <DIV> when querying people “About Me”

I'm working on a "people directory" using a search query on the active directory. As it stands now I'm just using our group name, which is part of a large company. This get's all of the employee's in ...
0
votes
1answer
637 views

Apply group by on Sharepoint Search results

I am struggling with figuring out how to apply group by on SharePoint 2013 search results. I am using angular JS to display the results using SharePoint restful endpoint for search service. I am using ...
0
votes
1answer
65 views

Content Search - Display only custom library templates types

I am trying to get a Content Search WP to return only Doc Libraries created using a custom Library template. I have tried the following but doesn't seem to work: contentclass=...
2
votes
1answer
674 views

KQL to filter out non published hits

I want to use a result source to get all published pages of a type in a sitecollection. In a different result source I want also the drafts so I have enabled this possiblity in the libraries. However ...
1
vote
0answers
262 views

created < 2010-10-10 Using KQL on Sharepoint 2013

String queryText = "Created<2010-10-10 and IsDocument:1"; KeywordQuery keywordQuery = new KeywordQuery(siteCollection); keywordQuery.RowLimit = 500; keywordQuery.QueryText = querytext; ...
1
vote
2answers
4k views

SharePoint 2013 Search Query syntax for “Starts With” for whole term with multiple words

I am building a search based A to Z (as it needs to run across site collections) on SharePoint 2013 and need to be able to find all pages where their 'AZText' managed property value starts with a ...