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

Copilot Studio Azure OpenAI with SharePoint Data Source

I n this post, we will see how to index SharePoint documents with Azure AI Search index and use it with an Azure Open AI model for chat playground. Curently, SharePoint data source is not available in the Azure AI Search UI but we can configure using REST API. This GPT model further can be integrated with Copilot Studio and deployed to various channels such as MS Teams. Prerequisites: SharePoint sites with documents Azure Entra Service Principal Azure AI Search (to create SharePoint as Data Source, Search Index and Indexer) Open AI Access Create Service Principal: We need to create an Azure Entra ID service principal to configure the SharePoint data source. In this case, Azure AI Search uses Graph API to access the SharePoint data. we use delegated permissions to configure app registration. You can can also use application permissions. You need to create client secret if you are using application permissions. Navigate to Azure Entra Id -> App Registrations -> Create App Registrat...
Read more

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

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