Inherit checkmark for Document Metadata

Bernhard Kvarda asked on April 15, 2015 14:46

Hi Jan, hi all,

I am working on a similar problem as here: Asked in January. The question was how to prevent Kentico from setting Meta-Data to inherit by default in new documents. I have a follow up question regarding the answer given about already existing documents that have the inherit checkmark in metadata:

"...for already created pages, you would need to write a script or change it in the database,..."

I searched the database and could not find the value defining the "inherit" checkmark. Can you please tell me where to find this setting in the database or give me a hint how a script unchecking all those checkmarks could look like? I need uncheck the inherit Metadata on all pages on our site. Thanks for your help!

Correct Answer

Brenden Kehren answered on April 15, 2015 20:24

Technically the "inherit" checkboxes do not exist in the database. If you go to Modules>Pages>Classes>Page>Alternative forms>meta data>Fields you'll see when you select any of the "...inherit" fields, they have no database representation message at the top of the field. So what you can do is simply set the default value to unchecked on those three items and you should be set.

If you want to remove the values that could have already been set, you can run a query against the cms_document table in your database and look at the DocumentPageTitle, DocumentPageKeyWords, DocumentPageDescription values.

3 votesVote for this answer Unmark Correct answer

Recent Answers

Bernhard Kvarda answered on April 16, 2015 10:51

Hi Brenden, please tell me where I find the Modules>Pages>Classes>Page>Alternative forms>meta data>Fields ? It's not in the Sitemanager>Modules. Is it in the source? We are using Kentico 7.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on April 16, 2015 19:51

Unfortunately, in version 7 you will have to modify code. The instructions I initially provided were for v8.

In v7, you will have to modify this file:

\CMSModules\Content\CMSDesk\Properties\MetaData.aspx.cs

There are checkbox controls in there. You'd set the default values to unchecked, then run the script to update the cms_document table.

0 votesVote for this answer Mark as a Correct answer