411557 - Search KB by article source

Status: RESOLVED FIXED

(support.mozilla.org :: Knowledge Base Software, task)

Description

[Chris Ilias [:cilias]]

Sometimes I need to go through all articles, which have a specific line to text in the source. Using the standard search does not search article sources; so I can't use that.

Comment 1

[Chris Ilias [:cilias]]

I'd like to bring some more attention to this bug, because I often run into situations where this would help a lot. For instance:
- I recently renamed the in-product articles. Some of them already have equivalent versions in the knowledge base (cookies-en-US vs Cookies, which was renamed to "About cookies" before the in-product version took its place.) It would be great if I could search the KB for articles linking to About cookies, so I could update all the links to point to the in-product article.

- I relabeled a couple of content blocks. Unfortunately, articles using those content blocks do not get automatically updated. It would be great if I could search the KB for articles using a certain content label, and update them.

Comment 2

[Chris Ilias [:cilias]]

Is it too late to renominate this for 0.7? This one is really important to me, because there are so many use-cases.

Comment 3

[Chris Ilias [:cilias]]

Cheng is there a query we can run on sumotools for this? We can then apply it to bug 482343 - "Update references in KB from 3.1 to 3.5".

Comment 4

[[:Cww]]

SELECT tp.pageName as title, tto.lang as lang FROM tiki_objects tob JOIN tiki_pages tp ON tob.itemId = tp.pageName JOIN tiki_translated_objects tto ON tto.objId = tob.objectId WHERE tob.type = 'wiki page' AND tp.data LIKE '%3.1%' order by lang;

Gives you pagename and language (since that's pretty useful in lots of cases).

Comment 5

[Chris Ilias [:cilias]]

Thanks.

Comment 6

[Chris Ilias [:cilias]]

The output of that query didn't include the Private Browsing article, which does mention 3.1.

Comment 7

[[:Cww]]

Hmm... seems to only hit articles that have been translated at least once.

Try the much simpler:

SELECT tp.pageName as title, tp.lang as lang FROM tiki_pages tp WHERE tp.data LIKE '%3.1%' ORDER BY lang;

It'll have dupes but that should be OK.