Magnolia 4.5 reached end of life on June 30, 2016. This branch is no longer supported, see End-of-life policy.

Page tree
Skip to end of metadata
Go to start of metadata

Each node in a JCR workspace has a type. The type defines the child nodes and properties that the node may or must have. Magnolia uses node types to define a custom content model whereas Jackrabbit enforces the constraints of that model at the repository level. See Apache Jackrabbit Node Types for more information. Magnolia does not use the Jackrabbit JcrConstants as they are not comprised of both prefixes and suffixes. This has query limitations, for example if a NodeType starts with MgnlNodeType.JCR_PREFIX. Magnolia node types are registered by the  MgnlNodeType  Java class. Both prefixes and suffixes are defined.

Prefixes

Name

Syntax

nodeType

nt:

mixin

mix:

mgnl-properties

mgnl:

jcr-properties

jcr:

Node Types

Magnolia node types

Node type

Prefix/Syntax

base

nt:base

unstructured

nt:unstructured

hierarchy node

nt:hierarchyNode

folder

mgnl:folder

file

nt:file

resource

mgnl:resource

metadata

mgnl:metadata

content

mgnl:content

content node

mgnl:contentNode

page

mgnl:page

area

mgnl:area

component

mgnl:component

node data

mgnl:nodeData

frozen node

nt:frozenNode

user

mgnl:user

role

mgnl:role

group

mgnl:group

system

mgnl:reserve

Mixin node types

Node type

Prefix/Syntax

access control

mix:accessControllable

reference

mix:referencable

version

mix:versional

lock

mix:lockable

deleted

mgnl:deleted

JCR properties

Node type

Prefix/Syntax

JCR primary type

jcr:primaryType

JCR frozen node

jcr:frozenNode

JCR frozen primary type

jcr:frozenPrimaryType

JCR data

jcr:data

JCR content

jcr:content

Queries

Magnolia supports the SQL and JCR-SQL2 query languages. Although deprecated, XPath remains available and will be supported for the foreseeable future.

JCR query tools

Query tools are available at Tools > JCR Queries.

The Dump tool creates a repository dump:

  1. Select a repository (workspace).
  2. Type a path.
  3. Select the number of levels.
  4. Click Execute

The results are displayed in the Result box. A dump returns all nodes in the JCR that comply with the selected criteria. Here are a few sample results for the above dump.

/demo-project/about/jcr:uuid=f312fc16-8f66-451c-bdf0-a72913b74c2d
/demo-project/about/jcr:primaryType=mgnl:page
/demo-project/about/MetaData/mgnl:activatorid=superuser
/demo-project/about/extras/jcr:ixinTypes=mix:lockable
/demo-project/about/subsection-articles/hideInNav=false
/demo-project/about/history/promos[mgnl:area]

The Query tool executes the results of a specific query:

  1. Select the repository and the query language.
  2. Define the result ItemType, if any.
  3. Type the query in the main box.
  4. Click Execute.

The results are displayed in the Result box.

Sample queries

A few tips for writing and testing queries:

  • Use the query tool to validate queries used in code.
  • An incorrect query often returns empty results which complicates debugging
  • Make your queries additive. Test the basics and then refine them to be more precise.
  • Case insensitive searches are not supported. As workaround, ensure that both parts of the search condition use same case.

Here's a few sample queries in the SQL language. Apache.org has a handy translator tool that converts queries from SQL to XPath and vice versa. See the JCR Query cheat sheet on the wiki for more.

Workspace

Result

SQL query

website

All pages

select * from mgnl:page

 

Pages in the About section

select * from mgnl:page where jcr:path like '/demo-project/about/%'

 

Pages with "News" in the title

select * from mgnl:page where title like '%News%'

 

Pages with "News" in the title (case sensitive)

select * from mgnl:content where title like 'News'

 

Pages that use a specific DMS image

select * from mgnl:content where imageDmsUUID='01d1b9bc-93e8-471f-96db-2c81855ce65d'

 

Pages that link to a contact

select * from nt:base where linkTitle like '%Contact%' and linkType='internal'

config

Component types

select * from nt:base where jcr:path like '/modules/%/components/%' and type is not null

users

User with email eric@example.com

select * from mgnl:user where email = 'eric@example.com'

data

Data categories that have related categories

select * from nt:base where jcr:path like '/categorization/%' and relatedUUID is not null

dms

JPEG images in the DMS

select * from nt:base where type='jpg'


  • No labels