DateTime resolution for querying FAST for SharePoint

I was doing range queries in the Search Center UI to limit documents between two exact dates.

image

But no matter what I entered as hours/minutes/seconds in my query I still got the same result.

There are good and bad news around this. The good news is that you can change the resolution from day to for example hours for your default rank profile:

$rank = Get-FASTSearchMetadataRankProfile
$rank.FreshnessResolution = “Hour”
$rank.Update()

The bad news is that the Search Center UI disregards this, and when monitoring the queries received by FAST all hours/minutes/seconds are stripped from the query. They are adjusted for time zones as you can see below where 00:00:00 is turned into 23:00:00 of the day before the original query.

image

If you want to do date range queries on an interval less than a day you have to use the development API’s, and not the default Search page.

Article written by

Computer literate and search enthusiast with an interest for sharepoint, coding, and life in general :)


Leave a response





XHTML: These tags are allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

301 Moved Permanently

Moved Permanently

The document has moved here.


OSLO

Comperio AS
Øvre Slottsgate 27
NO-0157 Oslo,
Norway
+47 22 33 71 00
View map

STOCKHOLM

Search Provider Sverige AB
Gamla Brogatan 34
SE-11 120 Stockholm
Sweden
+46 8-21 49 00
View map