IsPublished column in Database

Mani SJ asked on May 19, 2020 07:13

I want to use documents which are published. I am aware of TreeNode.IsPublished Kentico12 Property. I am trying to find IsPublished column in below db tables but I can't find any

[CMS_Document] [CMS_Tree] [View_CMS_Tree_Joined]

In which table IsPublished column exists in DB?

tree document database

Correct Answer

Brenden Kehren answered on May 19, 2020 08:08

It does not exist in the database, it's a calculated value. This would be the equivalent WHERE condition

([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= GETDATE()) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= GETDATE()))

1 votesVote for this answer Unmark Correct answer

Recent Answers

Mani SJ answered on May 19, 2020 09:40

Thanks. It works.

0 votesVote for this answer Mark as a Correct answer