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)
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)
Comments
Post a Comment