Which database table contains KB permalink information?

[ibt]

Which database table contains KB permalink information?

[Community Alums]

I don't think it's stored in the kb_knowledge database. From what I can tell, it's dynamically generated by the 'kb_article_footer' ui macro:

<j:if test="${jvar_kb_showlinks}">
   <b><a id="permalink" style="color:#999999;">${gs.getMessage("Permalink")}</a>:</b>$[SP]<span id="permatext"></span>$[SP]$[SP]$[SP]$[SP]
   <script>
   var urlpath = location.href.substring(0, location.href.indexOf("?")) + "?sysparm_article=$[URL:kb.number]";
   gel("permalink").href = urlpath;
   gel("permatext").innerHTML = urlpath;
   </script>
               </j:if> 

Hope that helps!

Cheers,

Tim

[ibt]

Hi Tim,

Sorry. What I was looking for is… if I use the "Copy Permalink" in article A, create a link in article B using it, click on the link in article B, and open article A…

Where in the SN system is that fact that article B has a link to article A stored? Is there a database table containing all of the permalinks used to link articles? I can run reports and get information about article B like: KB Number; Short Description; Last Update, etc… but cannot find anything about it having one of more links to other KB articles.

Tom

[Community Alums · Accepted solution]

I think I know what you mean- you're putting the HTML link to article A in the article B content? So, when a user views article B, there is a link to open article A somewhere in the content?

If that is the case, then it's stored in the 'text' field of the knowledge base article.

Cheers,

Tim

[ibt]

Thank you Tim. I found it in the Text field.