I know how to link directly to tutorials in the Help module with the URL, but I wanted to link directly to specific Help Categories. The trouble I ran into was as I click on a category in the Help module the URL does not change. After an IM with Mr Beadle, he showed me how to link directly to categories in the Help module. Here's how:
http://www.dotnetnuke.com/default.aspx?tabid=787&helpculture=en-us&helpmodule=Text%2fHTML
This link above will send you directly to the DotNetNuke® page where the Help Module is located (compliments of Lorraine Young) and load the Text/HTML category. Philip explained that all I have to do is set the helpmodule = [name] field from the Help_Category table. Very cool!! Now I can provide dynamic links to Help categories. Thank you, Philip.
Here is my contribution (for what is worth):
I wanted to see a list of ready made URL links to my various Help categories in my portal to reference so I could insert the hyperlink where I needed them throughout my portal. So I put a Reports module on an page that only I can see and loaded this SQL statement:
SELECT TOP (100) PERCENT dbo.Tabs.TabID, dbo.Tabs.TabName, dbo.Help_Category.Name AS [Help Category],
'<a target=_"blank" href="/Default.aspx?tabid=' + CAST(dbo.TabModules.TabID AS varchar(8))
+ '&helpmodule=' + dbo.Help_Category.Name + '">Help</a>' AS URL
FROM dbo.Help_Category INNER JOIN
dbo.TabModules ON dbo.Help_Category.ModuleID = dbo.TabModules.ModuleID INNER JOIN
dbo.Tabs ON dbo.TabModules.TabID = dbo.Tabs.TabID INNER JOIN
dbo.Portals ON dbo.Tabs.PortalID = dbo.Portals.PortalID INNER JOIN
dbo.Modules ON dbo.TabModules.ModuleID = dbo.Modules.ModuleID AND dbo.Portals.PortalID = dbo.Modules.PortalID
WHERE (dbo.Modules.IsDeleted = 0) AND (dbo.Tabs.IsDeleted = 0) AND (dbo.Portals.PortalID = 7)
ORDER BY dbo.Tabs.TabID, [Help Category]
Now I have a list of ready made direct links to my Help Categories. Change the PortalID = [your PortalID].