Hello,

I am trying to create a smart search that uses a smart search filter. The search filter is populated by the data of a custom table. I am trying to accomplish almost the same result as the following article but with no luck.

http://devnet.kentico.com/Knowledge-Base/Search/How-to-set-up-a-Smart-search-filter-for-document-t.aspx

My custom table has the following fields.
itemid
categoryliteral

So, I create a query (CMS.Root.SmartSearchFilter) for this custom table. The query is the following:
SELECT 'itemid', itemid, CategoryLiteral FROM RecipeCategories ORDER BY CategoryLiteral

The first item of the query should be the searchable item on the custom table or the documents I want to search?

Then I add the 3 web parts and the parameters for the filter are as follows:
query name: CMS.Root.SmartSearchFilter
where: categories IN (SELECT itemId FROM RecipeCategories)
categories is the int field on the document type table that holds the index of the custom table.
Filter clause: Must

However, when I search the filter is not used at all.

Any ideas why?

Dimitris