Jump to:

23376 Posts in 18218 Topics by 2867 members

General Questions

SilverStripe Forums » General Questions » Full text search not returning for ClassName Page

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

Page: 1
Go to End
Author Topic: 372 Views
  • sebjepb
    Avatar
    Community Member
    5 Posts

    Full text search not returning for ClassName Page Link to this post

    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 ?

    372 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.