Tuesday, 9 December 2014

Sharepoint 2010 FAST Search: Fast Query Language lessons learned

I am currently experiencing the joys of writing FQL search queries. It has been pretty much smooth sailing after I added my Managed Properties (with this script) and using these references:

http://msdn.microsoft.com/en-us/library/office/ff394606(v=office.14).aspx
http://blogs.perficient.com/microsoft/2011/06/using-fql-to-query-fast-search-index/

However, I learned the following lessons (the hard way):

1. using 'Path' to filter by URL did not work for me. I had to use
path:starts-with("http://my-url/my-site")

2. date range queries work much better when dates are set in UTC
myDateField:range(2000-01-01T00:00:00Z, 2020-01-01T00:00:00Z)

No comments:

Post a comment