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.

General Questions

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

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

Full text search not returning for ClassName Page


Reply

395 Views

Avatar
sebjepb

18 October 2011 at 3:16pm Community Member, 5 Posts

Hi
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 ?