Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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?
You need to receive data by using API and not by using dataabse
I still don't know how
You can see it here - https://our.umbraco.com/documentation/Reference/Querying/IPublishedContent/Collections/
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.
* 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.
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
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
My question about a different issue.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted