Questions tagged [kql-query]
The kql-query tag has no usage guidance.
13
questions
0
votes
0
answers
17
views
Power Automate to populate a Date/Time sharepoint column to use the site time zone?
I have a site content type named Asset, and this content type contains a site column of type Date/Time named ETA. now i am using KQL formula inside PnP Modern search web part to get all items which ...
0
votes
2
answers
132
views
Lost listing from contentClass:STS_List_DocumentLibrary
Within SharePoint Online, I have a page that is making use of the "Highlighted content" web part. Here are my settings for it :
Custom query is selected
The source is set to "This site&...
- 1,363
0
votes
0
answers
118
views
Help with KQL query search not returning any result
I have installed the search query tool and i'm sure i have the properties Birthday and Department updated in my SharePoint user profile.
But using the below queries yields no result
To list everyone ...
- 4,310
0
votes
0
answers
257
views
SharePoint 2019 Search KQL Boolean Operator "AND" doesn't work, "+" works
On our SharePoint 2019 Server we have a KQL that searches the whole Tenant for specific documents, by querying Managed Properties, like so: ContentType:MyContentType AND FileType:pdf.
According to ...
- 113
1
vote
3
answers
1k
views
KQL Search Query SharePoint Online
I would like to add filter based on Usage Location for AU or NZ. However the following result only return the record where UsageLocation is NZ
{searchboxquery} contentclass=spspeople -UsageLocation -...
- 1,799
0
votes
1
answer
3k
views
KQL Query for SharePoint Online List (Column) Search
I am trying to search for two title fields in a SharePoint list using KQL and can't seem to get this to work. I can get it to work for a single Column, but I can't get it to search for a second ...
- 97
0
votes
1
answer
446
views
SharePoint Search - Result Source to retrieve only 5 People along with rest of the results
Can you please help me in formulating a KQL or FQL query?
Is it possible to retrieve only 5 people results from the below query. Rest 15 can be anything from the index of the SharePoint Search Service....
- 1
0
votes
1
answer
718
views
How to write ANDNOT in KQL query?
I need to achieve a query where RefinableDate00 must be earlier than today
RefinableDate00:1900-01-01..{Today}
but also should not be null since if it is null, the result I want does not appear in the ...
- 101
1
vote
1
answer
623
views
SharePoint Search - KQL query (results limitation)
I have a issue with limiting search results using PnP Modern Search.
In addition to pulling all *.docx documents from the document library, I would like to skip those that have the name "...
- 21
0
votes
1
answer
6k
views
How to write a query in KQL for Internal and External ip addresses [closed]
How do you write a query in KQL looking for external ip addresses and internal ip addresses
1
vote
2
answers
5k
views
How to search only some specific sites using result source - SharePoint Online
I have couple of sites and subsites and would like to create a result source just for these sites. Then my intention is to add a new search webpart or use the existing one but change it to use my new ...
- 4,310
1
vote
0
answers
145
views
Search result source exclude read only sites
I am looking for a way to set up two search result sources, one that should exclude all content from any site collection that have been set as Read only and another that should only show content from ...
- 2,504
1
vote
2
answers
819
views
How to set search scope to specific site or subsite using KQL powershell csom
I want to search for content in a specific subsite in sharepoint online. How can I set scope of search to subsite in KQL using powershell csom?
I tried the following query:
$queryText="createdby:$...
- 399