Ektron Content Status Codes

Posted on By David Kittell

This is a list of code definitions for the content_status column in the content table

SELECT content_status
	,count(content_status)
FROM content
GROUP BY content_status
Letter Meaning Content state More Information
A Approved Through the workflow and published on the Web site. Approved Content
O Checked Out Currently being edited. Has not been checked in. Checked Out Content
I Checked In Checked in for other users to edit. Checked-In Content
S Submitted for Approval Saved and submitted into the approval chain.
See Also: Approval Chains		 Submitted Content
M Marked for Deletion Requested for deletion. Marked for Deletion Content
P Pending Go Live Date Approved but the Go Live date hasn’t occurred yet. Pending Start Date Content
T Awaiting Completion of Associated Tasks Task(s) assigned to content are not complete How Automatic Task Creation Works
D Pending Deletion Content was created with a future start date then checked in and deleted.

This status only remains until the start date is reached. At that point, the content is deleted.

Reference: http://documentation.ektron.com/cms400/v802/WebHelp/Managing%20Content/Content%20Statuses/APPENDIXACONTENTSTATUS.htm

Originally Posted on September 10, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL MSSQL - Ektron MSSQL - Ektron 8.0.2 SQL

Related Posts

Get IP From Hostname

Posted on

Create a new project Add a TextBox and name it “txtHostname” Add another TextBox and name it “txtIP” Add a button and name it “btnResolve” and give it appropriate text like “Resolve IP” Double click on the button to auto generate the button action code and insert code as shown…

Read More

Red Hat – LFTP File Upload

Posted on

#!/bin/sh # LFTP.sh # # Created by David Kittell on 9/26/2018. # if ! rpm -qa | grep -qw lftp; then echo "Installing lftp" yum install lftp -y else echo "lftp is already installed" fi # lftp profile creation example lftp -c "bookmark add SiteName ftp://user:password@sitename.com/path" #lftp -c "bookmark add…

Read More

Ektron List Widgets On Content

Posted on

This is another Ektron audit script that will help list PageBuilder content items that have a widget placed on them. The script below is very similar to Ektron Alias With Folder Name SET NOCOUNT ON DECLARE @Domain VARCHAR(50) SET @Domain = ‘/’ SELECT c.[content_id] AS ‘Content ID’ ,c.[content_title] AS ‘Content…

Read More