Copied to clipboard

Flag this post as spam?

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


  • nickornotto 377 posts 869 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 377 posts 869 karma points
    Mar 02, 2022 @ 22:37
    nickornotto
    0

    Anyone knows?

  • Yakov Lebski 473 posts 1878 karma points
    Mar 02, 2022 @ 23:51
    Yakov Lebski
    0

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

  • nickornotto 377 posts 869 karma points
    Mar 03, 2022 @ 13:00
    nickornotto
    0

    I still don't know how

  • Yakov Lebski 473 posts 1878 karma points
    Mar 03, 2022 @ 13:04
  • nickornotto 377 posts 869 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 2146 posts 13582 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…
  • 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 377 posts 869 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