Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Full text search not returning for ClassName Page

Go to End



Community Member, 5 Posts

18 October 2011 at 3:16pm

We have SS loaded on windows MSSQL IIS7 environment and have had trouble getting the search to work for standard pages.

Went thru the tutorial, the issue is that searches will only be returned if they have classname Errorpage,RedirectorPage,VirtualPage, File etc but not for the standard classname Page.

Here is the showqueries sql debug

SELECT "File"."ID", 'File' AS Source, "Rank" AS "Relevance" FROM "File" INNER JOIN FREETEXTTABLE("File", (*), 'tasmania') AS "ft" ON "File"."ID"="ft"."KEY" WHERE ("File"."ClassName" IN ('SiteTree', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'File')) UNION SELECT "SiteTree_Live"."ID", 'SiteTree' AS Source, "Rank" AS "Relevance" FROM "SiteTree_Live" INNER JOIN FREETEXTTABLE("SiteTree_Live", (*), 'tasmania') AS "ft" ON "SiteTree_Live"."ID"="ft"."KEY" WHERE ("SiteTree_Live"."ShowInSearch"!=0) AND ("SiteTree_Live"."ClassName" IN ('SiteTree', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'File')) ORDER BY "Relevance" DESC

which shows that ClassName 'Page' has been excluded ?