is there a way to disable the versioning system? So that when I save a node, its current properties are updated and not added as new rows in cmsPropertyData?
I'll explain better what I'm trying to achieve. I'm trying to make an sql query to get all the nodes of a certain document type with all their properties. I'm not good at sql, so far all I could do was a select that returns the nodes, and one property, but there are duplicate rows, because I think of the multiple versions of the property in the cmsPropertyData table. I don't remember exactly the query and I'm at home now, but it's something like
SELECT umbracoNode.id, umbracoNode.text, cmsPropertyData.dataNtext FROM umbracoNode INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId INNER JOIN cmsPropertyData ON umbracoNode.Id = cmsPropertyData.contentNodeId WHERE cmsContentType.alias = 'Test' AND cmsPropertyData.dataNtext IS NOT NULL
Is such a query possible? Would, if possible, disabling the versions do the trick?
Well speed is the reason, there are going to be a lot of nodes and I'll have to also perform some sorting operations. And because there'll be a lot of them, I need pagination of some sort to list, that's why I cannot use the repeatable custom content as you've sugested in my previous question :) This large number of nodes will be created in a short period of time, so again for performance reasons I wanted do disable lucene.
disable versions / rollback
Hi,
is there a way to disable the versioning system? So that when I save a node, its current properties are updated and not added as new rows in cmsPropertyData?
Thanks!
I'll explain better what I'm trying to achieve. I'm trying to make an sql query to get all the nodes of a certain document type with all their properties. I'm not good at sql, so far all I could do was a select that returns the nodes, and one property, but there are duplicate rows, because I think of the multiple versions of the property in the cmsPropertyData table. I don't remember exactly the query and I'm at home now, but it's something like
SELECT umbracoNode.id, umbracoNode.text, cmsPropertyData.dataNtext
FROM umbracoNode
INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId
INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId
INNER JOIN cmsPropertyData ON umbracoNode.Id = cmsPropertyData.contentNodeId
WHERE cmsContentType.alias = 'Test' AND cmsPropertyData.dataNtext IS NOT NULL
Is such a query possible? Would, if possible, disabling the versions do the trick?
Thank you!
Is there a reason to use sql instead of umbraco API?
Well speed is the reason, there are going to be a lot of nodes and I'll have to also perform some sorting operations. And because there'll be a lot of them, I need pagination of some sort to list, that's why I cannot use the repeatable custom content as you've sugested in my previous question :) This large number of nodes will be created in a short period of time, so again for performance reasons I wanted do disable lucene.
If nodes are published you can use nodefactory or linq2umbraco. Another option can be store child nodes as xml in parent.
is working on a reply...