21286 Posts in 5733 Topics by 2602 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 215 Views |
-
Full text search not returning for ClassName Page

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 ?
| 215 Views | ||
|
Page:
1
|
Go to Top |

