How can I extract umbracoNaviHide property value from sql database?
Hi all,
I have an Umbraco 4.8 installation running using a SQL server. I am using the umbracoNaviHide property to hide content that I want to be able to unhide from elsewhere (other than the Umbraco content administration) by extracting and modifying the umbracoNaviHide property value in the DB.
That is, I want to be able to see and alter the umbracoNaviHide property value for a node from another .NET based website.
So my question is; where in the database will I find where it is determined what value the umbracoNaviHide property is set on a node?
How can I extract umbracoNaviHide property value from sql database?
Hi all,
I have an Umbraco 4.8 installation running using a SQL server. I am using the umbracoNaviHide property to hide content that I want to be able to unhide from elsewhere (other than the Umbraco content administration) by extracting and modifying the umbracoNaviHide property value in the DB.
That is, I want to be able to see and alter the umbracoNaviHide property value for a node from another .NET based website.
So my question is; where in the database will I find where it is determined what value the umbracoNaviHide property is set on a node?
Its actually based on your setup, since the ID of the property is created when you created your umbracoNaviHide property.
First, find the property ID of your umbracoNaviHide in the table cmsPropertyTypes:
SELECT *
FROM cmsPropertyType where Alias = 'umbracoNaviHide'
Then with that ID you can find the properies in the cmsPropertyData table:
SELECT *
FROM cmsPropertyData where propertytypeid=296
(Replace 296 with your propertytypeid)..
Then you got all the places that this property is used.
If you need to find the page, you can look that up by contentNodeId in the cmsDocument table..
Thank you for your reply. It got me some of the way, but I still need the value of the property - that is, whether the node is hidden or not.
Basically, what I want to do is:
For a certain node - get the umbracoNaviHide propery value (0 or 1) to see if the node is hidden or not.
is working on a reply...