Copied to clipboard

Flag this post as spam?

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


  • nickornotto 394 posts 896 karma points
    Feb 07, 2022 @ 22:16
    nickornotto
    0

    How to get content from the database in umbraco 8 or 9?

    As per the subject - I would like to look up the data structure and the data stored for each content in Umbraco 8 or 9 database.

    I guess it is the cmsContentNu table, I can read the dataRow binary but it just outputs to something like

    Do I need to use some kind of complex query using other tables?

  • nickornotto 394 posts 896 karma points
    Mar 02, 2022 @ 22:37
    nickornotto
    0

    Anyone knows?

  • Yakov Lebski 488 posts 1938 karma points
    Mar 02, 2022 @ 23:51
    Yakov Lebski
    0

    You need to receive data by using API and not by using dataabse

  • nickornotto 394 posts 896 karma points
    Mar 03, 2022 @ 13:00
    nickornotto
    0

    I still don't know how

  • Yakov Lebski 488 posts 1938 karma points
    Mar 03, 2022 @ 13:04
  • nickornotto 394 posts 896 karma points
    Mar 04, 2022 @ 09:53
    nickornotto
    0

    That I know and it's not what I am looking for.

    Isn't there any way to see how the data is actually stored in the database. Eg. * a boolean value or True/False - is it stored as 0/1 or true/false string etc. * a checkboxes values are they stored as comma delimited string values, prevalue id values etc. * whether empty linked media file is stored as empty string, 0 value etc.

    There are many questions like this, what exactly it is in the database. From what we saw in v7 the actual db stored values can be sometimes surprising and are important to know to use the API correctly.

  • Kevin Jump 2175 posts 13864 karma points MVP 6x c-trib
    Mar 04, 2022 @ 10:15
    Kevin Jump
    100

    Hi

    I would agree with everyone, going via the API is always best. but if for whatever reason you need to see the content data in the database. the SQL below will tell you it

    (assuming you know the node Id of the content item you want).

    SELECT pt.alias, pd.* FROM umbracoPropertyData as pd 
        inner join cmsPropertyType as pt 
        on pd.propertyTypeiD = pt.id
        inner join umbracoContentVersion as cv on pd.versionId = cv.id 
        where cv.NodeId = 1097 and cv.[current] = 1
    
    • with all the caveats, might not be the same as what is live, changing things here doesn't update site caches, etc etc…
  • Adelbert Hoeger 1 post 71 karma points
    Mar 03, 2022 @ 09:47
    Adelbert Hoeger
    0

    Between the four of us at Candid Contributions, we knew plenty about .NET Framework but not all of us had worked with Umbraco 9 or .NET 5 yet. So, we started by taking a look at our current site and having a think about what the different frameworks might mean for us. Then, we decided what could be migrated without any changes, what couldn’t be migrated and what would need some changes before it ‘worked’. Finally, we made an inventory of integrations, Umbraco packages and anything else of note. That looked like this:

  • monas 3 posts 73 karma points
    Mar 03, 2022 @ 11:52
    monas
    0

    If migrating from v8, you'll be able to use a similar method as was available in that version. You register a component in a composer, create a migration plan and run the plan to add the database table to the database. Learn more about composers in the

  • nickornotto 394 posts 896 karma points
    Mar 03, 2022 @ 12:59
    nickornotto
    0

    ???

    My question about a different issue.

Please Sign in or register to post replies

Write your reply to:

Draft