3.1.4.1.2. Type constraints

Warning

You are looking at documentation for an older release. Not what you want? See the current release documentation.

Finding all nodes

Warning

You are looking at documentation for an older release. Not what you want? See the current release documentation.

Only those nodes are found to which the session has READ permission. See also Access Control.

Repository structure

Repository contains many different nodes.

root
- folder1 (nt:folder)
  - document1 (nt:file)
  - folder2 (nt:folder)
    document2 (nt:unstructured)
    document3 (nt:folder)

Query execution

SQL

// make SQL query

        QueryManager queryManager = workspace.getQueryManager();

        // create query

        String sqlStatement = "SELECT * FROM nt:base";

        Query query = queryManager.createQuery(sqlStatement, Query.SQL);

        // execute query and fetch result

        QueryResult result = query.execute();

XPath

// make XPath query

QueryManager queryManager = workspace.getQueryManager();

// create query

String xpathStatement = "//element(*,nt:base)";

Query query = queryManager.createQuery(xpathStatement, Query.XPATH);

// execute query and fetch result

QueryResult result = query.execute();

Fetching result

Let's get nodes:

NodeIterator it = result.getNodes();


if(it.hasNext())

{

   Node findedNode = it.nextNode();

}

NodeIterator will return "folder1", "folder2","document1","document2","document3", and another nodes in workspace if they are here.

You can also get a table:

String[] columnNames = result.getColumnNames();

RowIterator rit = result.getRows();

while (rit.hasNext())

{

   Row row = rit.nextRow();

   // get values of the row

   Value[] values = row.getValues();

}

Table content is:

jcr:path	jcr:score
/folder1	1000
/folder1/document1	1000
/folder1/folder2	1000
/folder1/folder2/document2	1000
/folder1/folder2/document3	1000
...	...

Finding all nodes by primary type

Warning

You are looking at documentation for an older release. Not what you want? See the current release documentation.

Find all nodes whose primary type is "nt:file".

Repository structure

The repository contains nodes with different primary types and mixin types.

root
- document1 primarytype = "nt:unstructured" mixintype = "mix:title"
- document2 primarytype = "nt:file" mixintype = "mix:lockable"
- document3 primarytype = "nt:file" mixintype = "mix:title"

Query execution

SQL

// make SQL query

QueryManager queryManager = workspace.getQueryManager();

// create query

String sqlStatement = "SELECT * FROM nt:file";

Query query = queryManager.createQuery(sqlStatement, Query.SQL);

// execute query and fetch result

QueryResult result = query.execute();

XPath

// make XPath query

QueryManager queryManager = workspace.getQueryManager();

// create query

String xpathStatement = "//element(*,nt:file)";

Query query = queryManager.createQuery(xpathStatement, Query.XPATH);

// execute query and fetch result

QueryResult result = query.execute();

Fetching result

Let's get nodes:

NodeIterator it = result.getNodes();


if(it.hasNext())

{

   Node findedNode = it.nextNode();

}

NodeIterator will return "document2" and "document3".

You can also get a table:

String[] columnNames = result.getColumnNames();

RowIterator rit = result.getRows();

while (rit.hasNext())

{

   Row row = rit.nextRow();

   // get values of the row

   Value[] values = row.getValues();

}

The table content is:

jcr:path	jcr:score
/document2	2674
/document3	2674

Finding all nodes by mixin type

Warning

You are looking at documentation for an older release. Not what you want? See the current release documentation.

Find all nodes in repository that contains a "mix:title" mixin type.

Repository structure

The repository contains nodes with different primary types and mixin types.

root
- document1 primarytype = "nt:unstructured" mixintype = "mix:title"
- document2 primarytype = "nt:file" mixintype = "mix:lockable"
- document3 primarytype = "nt:file" mixintype = "mix:title"

Query execution

SQL

// make SQL query

QueryManager queryManager = workspace.getQueryManager();

// create query

String sqlStatement = "SELECT * FROM mix:title";

Query query = queryManager.createQuery(sqlStatement, Query.SQL);

// execute query and fetch result

QueryResult result = query.execute();

XPath

// make XPath query

QueryManager queryManager = workspace.getQueryManager();

// create query

String xpathStatement = "//element(*,mix:title)";

Query query = queryManager.createQuery(xpathStatement, Query.XPATH);

// execute query and fetch result

QueryResult result = query.execute();

Fetching result

Let's get nodes:

NodeIterator it = result.getNodes();


if(it.hasNext())

{

   Node findedNode = it.nextNode();

}

The NodeIterator will return "document1" and "document3".

You can also get a table:

String[] columnNames = result.getColumnNames();

RowIterator rit = result.getRows();

while (rit.hasNext())

{

   Row row = rit.nextRow();

   // get values of the row

   Value[] values = row.getValues();

}

Table content is:

jcr:title	...	jcr:path	jcr:score
First document	...	/document1	2674
Second document	...	/document3	2674