Difference between revisions of "XPath queries"
From OpenKM Documentation
m (moved Xpath queries to XPath queries) |
|||
| 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 == | |
| − | + | '''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 pavila''' | |
| + | <source lang="xml"> | ||
| + | //element(*, okm:folder)[@okm:author='pavila'] | ||
| + | </source> | ||
'''example of complex query, documents with content linux and keyword ubuntu''' | '''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''' | '''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 | 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 | ||
| Line 32: | Line 42: | ||
== Type restrictions == | == 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. | 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''' | '''for example the node folders''' | ||
| Line 42: | Line 51: | ||
A query can have property restrictions. The operators used are (=, !=, <, <=, >, >=) in addtion there's some extra operators like jcr:like() and jcr:contains(). | 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 == | == Order == | ||
At ends query can be indicated the order of results. | 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]] | ||
[[Category: OKM Network]] | [[Category: OKM Network]] | ||
Revision as of 18:43, 13 April 2010
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 pavila
//element(*, okm:folder)[@okm:author='pavila']
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')]
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
//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.
