DocumentPublishFrom and DocumentPublishTo is Null in database although I have checked "Use publish f

PITO Web CMS asked on January 26, 2024 22:49

Hi Kentico, could you help me on this?

DocumentPublishFrom and DocumentPublishTo is Null in database although I have checked "Use publish from/publish to:" for customized page type

Correct Answer

Brenden Kehren answered on January 26, 2024 23:16

You need to populate those fields in each page with values in order to use the values. You'll also need to check for nulls in your query.

0 votesVote for this answer Unmark Correct answer

Recent Answers


PITO Web CMS answered on January 30, 2024 20:42

Thank you for your reply. I already set the datetime in publish from/to. In pages app, the datetime is showing, but I could not find them in database. which tables in db contain publishfrom and to data? Thank you.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on January 30, 2024 20:46

These fields originate in the cms_document table and are also part of the view_cms_tree_joined view.

0 votesVote for this answer Mark as a Correct answer

PITO Web CMS answered on January 31, 2024 19:25 (last edited on January 31, 2024 21:04)

I checked those two tables and publishFrom and publishTo columns are Null for this custom page, however, in pages app, it did show the data and on left tree view, there is clock icon on the custom page indicating it's a scheduled page. Is there any other table storing this data and how to retrieve this value from my .net project? and which api of kentico? Thanks

---update--- I found if I put a date time that is no later than Now time, it can be recorded in CMS_Document table. Otherwise the column will not be updated.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.