KQL - Keyword Query Language - Date Time in Queries




KQL - Keyword Query Language - Date Time in Queries - Date Time Managed Property

KQL provides the datetime data type for date and time. The following datetime formats are supported in queries:
  • YYYY-MM-DD
  • YYYY-MM-DDThh:mm:ss
  • YYYY-MM-DDThh:mm:ssZ
  • YYYY-MM-DDThh:mm:ssfrZ
Below are the examples:

 EndDate Equals to Selected Date: 
EndDate=2015-01-01
EndDate=2015-01-01T12:00:00

 EndDate between two dates
EndDate=2015-01-01..2015-01-07

 EndDate less than than selected date:
EndDate&lt;=2015-01-07 or EndDate<=2015-01-07 
EndDate&lt;=2015-01-07T12:00:00 or EndDate<=2015-01-07 

 EndDate greater than selected date:
EndDate&gt;=2015-01-07 or EndDate>=2015-01-07 State:"Active"
EndDate&gt;=2015-01-07T12:00:00 or EndDate>=2015-01-07T12:00:00 

 The KQL Query looks like:

 <?xml version="1.0" encoding="utf-8" ?>
<QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000">
<Query domain="QDomain">
 <SupportedFormats><Format>urn:Microsoft.Search.Response.Document.Document</Format></SupportedFormats>
 <Context>
  <QueryText language="en-US" type="STRING" >EndDate&lt;=2015-01-07T12:00:00 </QueryText>
 </Context>
<Properties><Property name="EndDate" /><Property name="Rank" /><Property name="Title" /><Property name="Author" /><Property name="Size" /><Property name="Path" /><Property name="Description" /><Property name="Write" /><Property name="HitHighlightedSummary" /><Property name="HitHighlightedProperties" /></Properties><SortByProperties><SortByProperty name="Rank" direction="Descending" order="1"/></SortByProperties>
 <Range><StartAt>1</StartAt><Count>500</Count></Range>
 <EnableStemming>false</EnableStemming>
 <TrimDuplicates>true</TrimDuplicates>
 <IgnoreAllNoiseQuery>true</IgnoreAllNoiseQuery>
 <ImplicitAndBehavior>true</ImplicitAndBehavior>
 <IncludeRelevanceResults>true</IncludeRelevanceResults>
 <IncludeSpecialTermResults>true</IncludeSpecialTermResults>
 <IncludeHighConfidenceResults>true</IncludeHighConfidenceResults>
</Query></QueryPacket>



Comments

Post a Comment

Popular posts from this blog

Create and Deploy custom copilot to SharePoint Site (Part 2)

Image
  Custom Copilot as a canvas control on SharePoint site: This post is an extension to Part 1 to deploy the custom Copilot to SharePoint site. Before proceeding further please refer to the Part 1 as we are leveraging the custom Copilot and Service Principal created in the previous post. Deploying custom Copilot requires an additional app registration(this is different than the one created in the Part 1 for enabling authentication) to register SharePoint site as a canvas app to host copilot and handle single sign on flow. Create App Registration for SharePoint App: Login to https://portal.azure.com -> Microsoft Entra ID -> Create New App Registration Select 'Single page application' for platform and the SharePoint URL where the copilot is to be hosted and accessed Select API permissions blade and add custom API permission which was created in part 1 Save the Application(client Id) and the tenant id these will be used in SharePoint canvas app Deploy SharePoint SPFx App on ...
Read more

Create and Deploy custom copilot to MS Teams and SharePoint Site (Part 1)

Image
Custom Copilot using Copilot Studio published to MS Teams: In this two part series we see how to create a custom copilot using Microsoft Copilot Studio for Generative Answers based on the SharePoint Knowledge DB(files uploaded to SharePoint) and deploy the copilot to MS Teams and a SharePoint site. Deploying custom copilot to MS Teams and SharePoint require an authentication enabled. Lets create an Azure Service Principal(Client Id and Secret) required to enable Manual Authentication as deploying to SharePoint requires Manual Authentication. Create App Registration for Authentication: Login to https://portal.azure.com -> Microsoft Entra ID -> Create New App Registration    Add delegated API permissions: openid, profile, Files.Read.All, Sites.Read.All from Microsoft Graph Add a Scope from 'Expose an API' blade. This is required to publish the copilot to SharePoint site. You can ignore this step if you are publishing your copilot to MS Teams only. Crete a client secret fro...
Read more

Copilot Announcements from Microsoft Build 2024

Image
  Microsoft Announced major updates to Copilot Studio in Build 2024. In this article we will see the new Copilot features announced in Build 2024. New User Experience Redefined simplified developer experience for creating copilots using Copilot Studio.  Templates Industry specific templates to create custom copilots based on the industry specific templates. Templates will accelerate the development as we do not need to start from scratch. Some of these templates are Store Operations, Sustainability Insights, Website Q & A etc. we can also save custom copilot as template and made it available to others. Create Copilots from SharePoint - Private Preview Users can directly create custom copilots from SharePoint site by selecting documents and extend the copilot using Copilot Studio. Copilot will be available on the SharePoint site and we can directly ask any questions on the data from the data within the SharePoint site Copilot Connectors/Knowledge Sources We can now bring in...
Read more