Questions tagged [kql-query]
The kql-query tag has no usage guidance.
12
questions
0
votes
0
answers
17
views
How to search fraud score for multiple IP's
I am trying to find fraud scores for multiple IP's to show in a table
let HttpURL = externaldata (host:string,fraud_score:string, ISP:string,proxy:string,vpn:string,bot_status:string,city:string, ...
0
votes
0
answers
61
views
KQL for Managed Metadata in SharePoint Online
I've been researching for a couple of hours now, but can't seem to find a straight answer. In SharePoint on premise, you can perform KQL searches with the following commands to search for documents ...
1
vote
3
answers
154
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 -...
0
votes
0
answers
94
views
KQL query for SharePoint Online list to return just column value
I have a workspace list that contains records for all the workspaces(SharePoint sites) that were ordered. This list has one column called "WorkspaceUrl". So here I am looking for a KQL query ...
0
votes
1
answer
528
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 ...
0
votes
1
answer
98
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....
0
votes
1
answer
172
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 ...
1
vote
1
answer
197
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 "...
0
votes
1
answer
2k
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
3k
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 ...
1
vote
0
answers
102
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 ...
1
vote
2
answers
647
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:$...