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.
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.
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!
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.
is working on a reply...