I raised a support call to see if there was anyway to create a link in a custom property field (for example a link to a Documentation folder) for each node. I was told this was not possible by support as I would have to edit the HTML which is unsupported. I decided to attack it slightly differently by updating the SQL rather than the HTML.
I created a Custom Property called Documentation for each node.
On the SQL server I created a SQL Job that runs daily with the following code.
You enter the link \\server\share\ and the job will add the HTML tags when ever it is run.
use [NETPERFMON]
GO
CREATE TABLE #tempTable
(
[tempChar] [varchar](255) NULL,
[NodeID] int,
ROW [int] IDENTITY(1,1) NOT NULL
)
INSERT INTO #tempTable
SELECT Documentation, NodeID
FROM dbo.nodes
WHERE Documentation IS NOT NULL
AND Documentation <> ''
AND Documentation NOT LIKE '<a href%'
DECLARE @intLoop int
set @intLoop = 0
while (@intLoop < (SELECT MAX(ROW) FROM #tempTable))
begin
set @intLoop = @intLoop + 1
UPDATE dbo.Nodes
SET [Documentation] = (SELECT '<a href="file://' + [tempChar] + '" target=_blank>' + [tempChar] + '</a>' from #tempTable where ROW = @intLoop)
WHERE [NodeID] = (SELECT [NodeID] from #tempTable where ROW = @intLoop)
--(SELECT '<a href="file://' + [tempChar] + '" target=_blank>' + [tempChar] + '</a>' from #tempTable where ROW = @intLoop)
end -- while loop
DROP TABLE #tempTable
The way I see it is that this will still be supported as the Documentation field is still text and no db schema is being changed etc.
HTH,
Pete
