Difference between revisions of "XPath queries"
From OpenKM Documentation
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{TOCright}} __TOC__ | |
| + | |||
| + | XPath, the XML Path Language, is a query language for selecting nodes from an XML document. In addition, XPath may be used to compute values (e.g., strings, numbers, or Boolean values) from the content of an XML document. XPath was defined by the World Wide Web Consortium (W3C). | ||
| + | |||
| + | You can learn more about XPATH at http://www.w3.org/TR/xpath20/. | ||
== Examples == | == Examples == | ||
| − | + | === Locked documents === | |
| − | + | <source lang="xml"> | |
| − | + | //element(*, okm:document)[@jcr:lockOwner] | |
| + | </source> | ||
| − | + | === Locked documents by user therol === | |
| + | <source lang="xml"> | ||
| + | //element(*, okm:document)[@okm:author='therol'] | ||
| + | </source> | ||
| − | + | === Search documents by content === | |
| + | <source lang="xml"> | ||
| + | //element(*, okm:document)[jcr:contains(okm:content, 'linux')] | ||
| + | </source> | ||
| − | + | === Folders created by user potas === | |
| + | <source lang="xml"> | ||
| + | //element(*, okm:folder)[@okm:author='potas'] | ||
| + | </source> | ||
| − | + | === Example of complex query === | |
| + | Documents with content linux and keyword ubuntu: | ||
| + | <source lang="xml"> | ||
| + | //element(*,okm:document)[jcr:contains(okm:content,'linux') and jcr:contains(@okm:keywords,'ubuntu')] | ||
| + | </source> | ||
| − | ''' | + | === Dereference === |
| + | <source lang="xml"> | ||
| + | //element(*, nt:linkedFile)/jcr:deref(@jcr:content, '*')[jcr:contains(., 'foo')] | ||
| + | </source> | ||
| − | + | {{Note|In the examples we're making queries from repository root node, but really the queries might be done from /jcr:root/okm:root/ - that's the taxonomy node - for example the locked documents might be done as | |
| + | /jcr:root/okm:root//element(*, okm:document)[@jcr:lockOwner] | ||
| + | }} | ||
| − | + | == Type restrictions == | |
| + | We can specify the type of node that query returns. Restrictions include inheritage all subtype are included as possible results. The function element is used to evaluate a node type. | ||
| − | + | === For example the node folders === | |
| + | <source lang="xml"> | ||
| + | //element(*, okm:folder) | ||
| + | </source> | ||
| − | == | + | == Property restrictions == |
| − | + | A query can have property restrictions. The operators used are (=, !=, <, <=, >, >=) in addtion there's some extra operators like jcr:like() and jcr:contains(). | |
| + | |||
| + | === Getting folders with author pito === | ||
| + | <source lang="xml"> | ||
| + | //element(*, okm:folder)[@okm:author = 'pito'] | ||
| + | </source> | ||
| − | '' | + | === Documents name starting with linux === |
| + | <source lang="xml"> | ||
| + | //element(*, okm:document)[jcr:like(@okm:name, 'linux%')] | ||
| + | </source> | ||
| − | + | === Documents with indexed content jackrabbit === | |
| + | <source lang="xml"> | ||
| + | //element(*, okm:resource)[jcr:contains(., 'jackrabbit')]/@jcr:path | ||
| + | </source> | ||
| + | == Order == | ||
| + | At ends query can be indicated the order of results. | ||
| + | === Ordering by name === | ||
| + | <source lang="xml"> | ||
| + | //element(*, okm:document)[@okm:keywords != ''] order by @okm:name | ||
| + | </source> | ||
| + | Usually is used jcr:score to ordering, that indicates de ranking of the results. | ||
[[Category: Administration Guide]] | [[Category: Administration Guide]] | ||
| − | |||
Latest revision as of 16:50, 11 December 2012
XPath, the XML Path Language, is a query language for selecting nodes from an XML document. In addition, XPath may be used to compute values (e.g., strings, numbers, or Boolean values) from the content of an XML document. XPath was defined by the World Wide Web Consortium (W3C).
You can learn more about XPATH at http://www.w3.org/TR/xpath20/.
Examples
Locked documents
//element(*, okm:document)[@jcr:lockOwner]
Locked documents by user therol
//element(*, okm:document)[@okm:author='therol']
Search documents by content
//element(*, okm:document)[jcr:contains(okm:content, 'linux')]
Folders created by user potas
//element(*, okm:folder)[@okm:author='potas']
Example of complex query
Documents with content linux and keyword ubuntu:
//element(*,okm:document)[jcr:contains(okm:content,'linux') and jcr:contains(@okm:keywords,'ubuntu')]
Dereference
//element(*, nt:linkedFile)/jcr:deref(@jcr:content, '*')[jcr:contains(., 'foo')]
 |
In the examples we're making queries from repository root node, but really the queries might be done from /jcr:root/okm:root/ - that's the taxonomy node - for example the locked documents might be done as
/jcr:root/okm:root//element(*, okm:document)[@jcr:lockOwner] |
Type restrictions
We can specify the type of node that query returns. Restrictions include inheritage all subtype are included as possible results. The function element is used to evaluate a node type.
For example the node folders
//element(*, okm:folder)
Property restrictions
A query can have property restrictions. The operators used are (=, !=, <, <=, >, >=) in addtion there's some extra operators like jcr:like() and jcr:contains().
Getting folders with author pito
//element(*, okm:folder)[@okm:author = 'pito']
Documents name starting with linux
//element(*, okm:document)[jcr:like(@okm:name, 'linux%')]
Documents with indexed content jackrabbit
//element(*, okm:resource)[jcr:contains(., 'jackrabbit')]/@jcr:path
Order
At ends query can be indicated the order of results.
Ordering by name
//element(*, okm:document)[@okm:keywords != ''] order by @okm:name
Usually is used jcr:score to ordering, that indicates de ranking of the results.
