Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can't retrieve the <code>DocumentType</code> hierarchy from the published cache, i.e. from the <code>Node</code> or <code>IPublishedContent</code> objects.</p> <p>However, what you could do is:</p> <ol> <li><p>On application start generate a <code>Collection&lt;DocumentType&gt;</code> object of all the content (not media, member) <code>DocumentType</code> objects and cache it. I certainly wouldn't do this from the UI as querying the DocumentType will cause calls to the database, so caching and reusing the objects is much better.</p></li> <li><p>Possibly add the same code to the AfterNew event of a <code>DocumentType</code>. This way new <code>DocumentType</code> objects are also added to the cached list.</p></li> <li><p>Create an extension method like the existing <code>IsDocumentType(string documentTypeAlias)</code> which queries the cached list.</p></li> </ol> <p>The following code will retrieve the parent structure, you just need to add a <code>while(docType.MasterContentType != null)</code> construct:</p> <pre><code>DocumentType docType = DocumentType.GetByAlias("ContentPage"); DocumentType parentDocType = new DocumentType(docType.MasterContentType);` </code></pre> <p><strong>Edit:</strong></p> <p>If you want to go down the root of having a property on the <code>IPublishedContent</code> or <code>Node</code> instance then I would adopt a similar approach.</p> <ol> <li><p>Have all doc types inherit from a single doc type which has a label property called <code>parentDocTypeAliases</code>.</p></li> <li><p>On the <code>Newing</code> event of a <code>Document</code>, add the aliases of the parent doc types as a cmma delimited list to the <code>parentDocTypeAliases</code> property. You'll still need the code listed above to query the doc type hierarchy.</p></li> <li><p>Create a new extension method (e.g. <code>InheritsFromDocumentType(string documentTypeAlias)</code>) that queries the csv value.</p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POHow do I check if any of the current document type's ancestors are a specific type in Umbraco?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDigbyswift
    1. USDigbyswift
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I check if any of the current document type's ancestors are a specific type in Umbraco?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks very much for the answer - but maintenance overhead of that compared to just checking against a list of document types seems more. I'm really surprised that 'HasProperty' checks for a 'true' value rather than if it's defined - because that seems like a perfect, simple solution.
      singulars
      1. PO
      1. USIan Grainger
    2. COI've updated my answer. It's six and two three's whether you have a property or interrogate a static list of document types, but I can see the advantage of having it in the properties.
      singulars
      1. PO
      1. USDigbyswift
    3. COSorry, I just mean use a normal property: not set a property with the parent doc types. Because properties are inherited from parent document types, what I want to do is just check if a document has a property. But I can't because the default for a new document is that ALL checks for HasProperty return false. Apparently there are packages that will let me set a default value for a property on some document types - maybe that's the way to go.
      singulars
      1. PO
      1. USIan Grainger
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload