Extract content node data from Umbraco SQL Database
I want to display a dropdown of all the content nodes under a parent node. This is my content tree: https://i.imgur.com/2Xbey7O.png
Though I am not sure where this data is stored in the Umbraco Database. I need the name of the content node as well as the ID, so that the dropdown will automatically be updated when new content nodes are added.
I looked in the UmbracoNode table and found at least the content names, but that ID did not match up.
Extract content node data from Umbraco SQL Database
I want to display a dropdown of all the content nodes under a parent node. This is my content tree: https://i.imgur.com/2Xbey7O.png
Though I am not sure where this data is stored in the Umbraco Database. I need the name of the content node as well as the ID, so that the dropdown will automatically be updated when new content nodes are added.
I looked in the UmbracoNode table and found at least the content names, but that ID did not match up.
I cannot use query builder for this as I am displaying the dropdown using UIOMatic: http://uiomatic.readthedocs.io/en/stable/02.DefaultEditorViews/#dropdown
Where can I find the content id along with the name in the DB? Do I need to perform some inner joins to make this work?
is working on a reply...