Is there a quick way to see if a KB article has an attachment?
Is there a quick way to see which of my KB articles have an attachment without having to go into each article?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
nshah
11 years ago
Honest...I don't believe there is a way unless you attach a label that indicates it has an attachment. That might be a feature request you can submit. You can see what a software title has an attachment, maybe KACE can do the same for KB articles.
Comments:
-
If you check the ADVISORY table in your database it shows all fields (TITLE, NOTE, CATEGORY) except attachment. I would think it would be in there somewhere. If you took nshah's suggestion about adding labels that say it has an attachment you could JOIN the ADVISORY and ADVISORY_LABEL_JT tables. Then create a query with something like WHERE LABEL.NAME = '<LABEL_NAME>'. - dugullett 11 years ago
