Copied to clipboard

Flag this post as spam?

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


  • ThomasBrunbjerg 90 posts 182 karma points
    Sep 19, 2017 @ 07:14
    ThomasBrunbjerg
    0

    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?

Please Sign in or register to post replies

Write your reply to:

Draft