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

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

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

1111 Views

sebjepb

Community Member, 5 Posts

18 October 2011 at 3:16pm

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 ?

Return to top