Kb articles dont open - redirects to work item instead on newly created page within portal
With help we have managed to get the below new Knowledge Base View set up with displays our KB articles.
The way we did this was
- create a new page within the portal, used a SQL table and use the below query.
SELECT cat.DisplayString as 'KA Category',ka.title,ka.ArticleID, ka.CreatedDate, ka.LastModifiedDate, ka.Keywords,
stat.DisplayString AS 'KA Status',
ut.DisplayName AS 'LastModifiedUser'
FROM [ServiceManagement].[dbo].[KnowledgeArticle] AS ka
Left JOIN DisplayString cat ON cat.ElementID = ka.Category AND cat.LocaleID = 'enu'
Left JOIN DisplayString stat ON stat.ElementID = ka.status ANd stat.localeid = 'enu'
Left JOIN CI$User ut on ut.Id = ka.LastModifiedBy
The display is;
when i hover over any of the KB articles i see the below;
when i try to open any of the articles it fails as it tries to find a work item.
the same query and set up works for others in a different environment . i updated the portal to version 9.3 but it didn't fix this issue.
any ideas on what i can do to get the KB articles to open correctly? any help will be much appreciated.