Skip Navigation

Search

Knowledge Advanced Published/Unpublished articles report and Expired articles
Answer ID 13136   |   Last Review Date 04/27/2026

Is Knowledge Advanced Published/Unpublished articles report supposed to identify Expired status articles as Published?

Environment:

Knowledge Advanced (KA), Analytics Reports
 
Resolution:
 
The Published–Unpublished Articles report (ID 18046) status is derived from article actions (for example, Published/Unpublished). There is no explicit Expired action/state included in the logic. As a result, the returns all articles present in okcs_contents, including those that are expired.
 

For identifying expired status articles, the recommended approach is to create a custom report and add an IsExpired column based on okcs_contents.display_ended. For example:

if (okcs_contents.display_ended < sysdate(), 'Yes', 'No')

For further details see

Answer ID 13137: Standard Published–Unpublished Articles report (ID 18046) showing Published article(s) as Unpublished