Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jakob Lithner 61 posts 264 karma points
    Mar 01, 2022 @ 10:51
    Jakob Lithner
    0

    Find node publish status in database

    I need to export my Umbraco data to an external system. I have created an aggregated SQL view that extracts all relevant data.

    But to ensure relevant data I also need to check if a node is published or not. I don't understand where that status is stored. Table cmsDocument has columns for published and newest but they don't seem to reflect what I need.

    Help much appreciated!

  • Jakob Lithner 61 posts 264 karma points
    Mar 01, 2022 @ 16:24
    Jakob Lithner
    100

    Maybe I have a suggestion myself.

    I realize there is only one record in cmsDocument with newest=1. If I read the published status of that record I guess that is the current publish status.

Please Sign in or register to post replies

Write your reply to:

Draft