Developer forum

I made a custom implementation of that, since it's not already supported. I'm not sure whether we'll implement it in the standard search, but I'll be happy to share the custom implementation with you if you're interested.

Sorensen wrote:

I made a custom implementation of that, since it's not already supported. I'm not sure whether we'll implement it in the standard search, but I'll be happy to share the custom implementation with you if you're interested.

Hi Lars,

I'm always interested in your solution. :-)

In response to your reaction; Don't you think it's a kind of incomplete feature then ? I mean, you don't offer any search option through the forum by default, which in my opinion is a must-have.

So please consider it by making it part of the standard search.

Kind Regards,

Emil

I'd prefere avoiding dissing our software (in public), so let's just say there was a reason why I did the custom approach;)

What I did was create this view on the SQL database:

CREATE VIEW [dbo].[ForumV2Search] AS SELECT FT.ForumV2ThreadID, FT.ForumV2ThreadHeadline, FT.ForumV2ThreadCategoryID, FT.ForumV2ThreadDescription, FT.ForumV2ThreadText, FP.ForumV2PostHeadline, FP.ForumV2PostText, FP.ForumV2PostDate FROM dbo.ForumV2Post AS FP INNER JOIN dbo.ForumV2Thread AS FT ON FT.ForumV2ThreadID = FP.ForumV2PostThreadID

Set it up as a query if you're using MS Access.

The I registered a custom module using the Dynamicweb Developer module with these settings:

Module tab
Name: Forum V2 Search
System name: ForumV2Search
Access: Checked
Paragraph module: Unchecked

Search tab
Database: ForumV2.mdb
Item table: ForumV2Search
Item query parameter: action=ShowThread&ThreadID
Category table: ForumV2Category

Category fields
ID: ForumV2CategoryID
Name: ForumV2CategoryName

Item fields
ID: ForumV2ThreadID
Category ID: ForumV2ThreadCategoryID
Heading: ForumV2ThreadHeadline
Date: ForumV2PostDate
Edit date: ForumV2PostDate

Search
Search in: ForumV2ThreadHeadline, ForumV2ThreadDescription, ForumV2ThreadText, ForumV2PostHeadline, ForumV2PostText
Body text: ForumV2PostText

Nothing entered in the Publication fields and on the Security tab.

Let me know how it works for you.