FAST Search for SharePoint 2010 – FQL and its Impact on Relevancy Ranking (Using Full Text Index Mapping)


Introduction

In this post I will describe a common mistake that occurs when you write your own FQL that impacts the search results that depends on Relevancy Ranking (Using Full Text Index Mapping).

 

Scenario

Lets consider that we have a list of products that we would like to search through that have a custom managed property weights defined to control Relevancy; The Full Text Index Mapping is configured as following:

  • ProductName: Level 7 (High Importance)
  • ProductDesc: Level 1 (Low Importance)

and lets say that other Dynamic Ranking options are disabled (such as Freshness, Boosts, Authority Weight … etc.) in this scenario to make things easier. So what happens if I searched for the product “XBox” using the following FQL:

(

    (

        ProductName:string(

            “XBox”,

             mode=”simpleany”

        )

    )

) or (

       ProductDesc:string(

            “XBox”,

             mode=”simpleany”

        )

)

 

What I expect to see is that the search results will bring the result items that has the word “Xbox” in the ProductName first due to my relevancy configuration, but that doesn’t happen, why?

 

 

The Problem:

To understand the problem lets check the official definition of FQL from Microsoft MSDN Site:

The FAST Query Language (FQL) is a powerful query language that enables developers to perform exact searches and to narrow the scope of your search to values that belong to a specific managed property or a full-text index.

So what happened here is that the Exact Managed Property Search kicked in and disabled the Dynamic Ranking (using Full Text Index Mapping).

 

Solution 

 To solve this issue you need to remove the managed properly names from your query and rephrase it as following:

 

(

    (

        string(

            “XBox”,

             mode=”simpleany”

        )

    )

)

 

This will enable the Full Text Index Mapping on your reach results and brings in the results that are ordered in the ProductName first.

 

Note:

For the sake of this scenario I disregarded the number of occurrence of the word “Xbox” in the search results to make it easier to understand, please note that this issue will also affect the order of the search results.

 

 

 

Additional References

More useful information can be found in the below links:

Comments (2)

  1. showbox says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    http://showboxandroids.com/showbox-apk/
    http://showboxappandroid.com/
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    http://showboxappk.com/showbox-for-ipad-download/
    http://showboxappk.com/showbox-for-iphone/
    Showbox for PC articles:
    http://showboxandroids.com/showbox-for-pc/
    http://showboxappandroid.com/showbox-for-pc-download/
    http://showboxforpcs.com/
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings. Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android.
    The above all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.