You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@chemistry.apache.org by bu...@apache.org on 2016/12/02 20:05:11 UTC
svn commit: r1002058 [2/2] - in /websites/staging/chemistry/trunk/content:
./ docs/cmis-samples/ docs/cmis-samples/about/ docs/cmis-samples/mkdocs/
docs/cmis-samples/mkdocs/js/ docs/cmis-samples/samples/access-control/
docs/cmis-samples/samples/allowab...
Modified: websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/queries/index.html
==============================================================================
--- websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/queries/index.html (original)
+++ websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/queries/index.html Fri Dec 2 20:05:10 2016
@@ -23,7 +23,7 @@
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta name="author" content="Apache Chemistry">
+ <meta name="author" content="Apache Chemistry">
<link rel="shortcut icon" href="../../img/favicon.ico">
<title>Executing Queries - Apache Chemistry Samples</title>
@@ -200,6 +200,12 @@
<li >
+ <a href="../query-examples/index.html">Query Examples</a>
+</li>
+
+
+
+<li >
<a href="../changelog/index.html">Retrieving the Change Log</a>
</li>
@@ -257,7 +263,7 @@
</a>
</li>
<li >
- <a rel="prev" href="../changelog/index.html">
+ <a rel="prev" href="../query-examples/index.html">
Next <i class="fa fa-arrow-right" aria-hidden="true"></i>
</a>
</li>
@@ -398,4 +404,4 @@ ItemIterable<QueryResult> results
</body>
</html>
-<!-- last update: 2016-08-05 12:35:11.143083 -->
\ No newline at end of file
+<!-- last update: 2016-12-02 19:20:52 -->
\ No newline at end of file
Added: websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/query-examples/index.html
==============================================================================
--- websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/query-examples/index.html (added)
+++ websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/query-examples/index.html Fri Dec 2 20:05:10 2016
@@ -0,0 +1,400 @@
+<!DOCTYPE html>
+<!--
+
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+
+-->
+<html lang="en">
+
+<head>
+ <meta charset="utf-8">
+ <meta http-equiv="X-UA-Compatible" content="IE=edge">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+ <meta name="author" content="Apache Chemistry">
+ <link rel="shortcut icon" href="../../img/favicon.ico">
+
+ <title>Query Examples - Apache Chemistry Samples</title>
+
+ <link href="../../css/bootstrap-custom.min.css" rel="stylesheet">
+ <link href="//maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css" rel="stylesheet">
+ <link href="../../css/base.css" rel="stylesheet">
+ <link href="../../css/cinder.css" rel="stylesheet">
+ <link rel="stylesheet" href="../../css/highlight.css">
+
+
+ <link href="../../css/chemistry.css" rel="stylesheet">
+
+ <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
+ <!--[if lt IE 9]>
+ <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
+ <script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
+ <![endif]-->
+
+
+</head>
+
+<body>
+
+ <div class="navbar navbar-default navbar-fixed-top" role="navigation">
+ <div class="container">
+
+ <!-- Collapsed navigation -->
+ <div class="navbar-header">
+
+ <!-- Expander button -->
+ <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
+ <span class="sr-only">Toggle navigation</span>
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ <span class="icon-bar"></span>
+ </button>
+
+
+ <!-- Main title -->
+ <a class="navbar-brand" href="../../index.html">Apache Chemistry Samples</a>
+ </div>
+
+ <!-- Expanded navigation -->
+ <div class="navbar-collapse collapse">
+
+ <!-- Main navigation -->
+ <ul class="nav navbar-nav">
+
+
+ <li >
+ <a href="../../index.html">Home</a>
+ </li>
+
+
+
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Repository <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+
+
+<li >
+ <a href="../create-session/index.html">Creating a Session</a>
+</li>
+
+
+
+<li >
+ <a href="../capabilities/index.html">Getting Repository Capabilities</a>
+</li>
+
+
+
+<li >
+ <a href="../types/index.html">Working with Types</a>
+</li>
+
+
+
+<li >
+ <a href="../exceptions/index.html">CMIS Exceptions</a>
+</li>
+
+
+ </ul>
+ </li>
+
+
+
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">CRUD <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+
+
+<li >
+ <a href="../retrieve-objects/index.html">Retrieving Objects</a>
+</li>
+
+
+
+<li >
+ <a href="../create-objects/index.html">Creating Objects</a>
+</li>
+
+
+
+<li >
+ <a href="../update-objects/index.html">Updating Objects</a>
+</li>
+
+
+
+<li >
+ <a href="../move-objects/index.html">Moving Object</a>
+</li>
+
+
+
+<li >
+ <a href="../delete-objects/index.html">Deleting Objects</a>
+</li>
+
+
+
+<li >
+ <a href="../content/index.html">Working with Content</a>
+</li>
+
+
+
+<li >
+ <a href="../versions/index.html">Working with Versions</a>
+</li>
+
+
+
+<li >
+ <a href="../properties/index.html">Working with Properties and Secondary Types</a>
+</li>
+
+
+
+<li >
+ <a href="../operation-context/index.html">Understanding the Operation Context</a>
+</li>
+
+
+
+<li >
+ <a href="../lists/index.html">Working with Lists, Paging and Skipping</a>
+</li>
+
+
+
+<li >
+ <a href="../extensions/index.html">Getting Extensions</a>
+</li>
+
+
+ </ul>
+ </li>
+
+
+
+ <li class="dropdown active">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Query <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+
+
+<li >
+ <a href="../queries/index.html">Executing Queries</a>
+</li>
+
+
+
+<li class="active">
+ <a href="index.html">Query Examples</a>
+</li>
+
+
+
+<li >
+ <a href="../changelog/index.html">Retrieving the Change Log</a>
+</li>
+
+
+ </ul>
+ </li>
+
+
+
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Access Control <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+
+
+<li >
+ <a href="../allowable-actions/index.html">Checking Allowable Actions</a>
+</li>
+
+
+
+<li >
+ <a href="../access-control/index.html">Managing Access Control</a>
+</li>
+
+
+
+<li >
+ <a href="../retention/index.html">Retention and Holds</a>
+</li>
+
+
+ </ul>
+ </li>
+
+
+
+ <li >
+ <a href="../../about/index.html">About</a>
+ </li>
+
+
+ </ul>
+
+
+ <ul class="nav navbar-nav navbar-right">
+ <li>
+ <a href="#" data-toggle="modal" data-target="#mkdocs_search_modal">
+ <i class="fa fa-search" aria-hidden="true"></i> Search
+ </a>
+ </li>
+
+ <li >
+ <a rel="next" href="../queries/index.html">
+ <i class="fa fa-arrow-left" aria-hidden="true"></i> Previous
+ </a>
+ </li>
+ <li >
+ <a rel="prev" href="../changelog/index.html">
+ Next <i class="fa fa-arrow-right" aria-hidden="true"></i>
+ </a>
+ </li>
+
+ <li>
+ <a href="https://www.apache.org" style="padding: 2px;">
+ <img src="../../img/feather.png">
+ </a>
+ </li>
+ </ul>
+ </div>
+ </div>
+</div>
+
+ <div class="container">
+
+ <div class="col-md-3"><div class="bs-sidebar hidden-print affix well" role="complementary">
+ <ul class="nav bs-sidenav">
+
+ <li class="first-level active"><a href="#common-query-examples">Common Query Examples</a></li>
+
+ <li class="second-level"><a href="#simple-query">Simple Query</a></li>
+
+
+ <li class="second-level"><a href="#complex-query-with-joins">Complex query with JOINS</a></li>
+
+
+ <li class="second-level"><a href="#text-search-query">Text search query</a></li>
+
+
+ <li class="second-level"><a href="#query-for-multi-value-property">Query for multi-value property</a></li>
+
+
+ <li class="second-level"><a href="#query-for-secondary-types">Query for secondary types</a></li>
+
+
+
+ </ul>
+</div></div>
+ <div class="col-md-9" role="main">
+
+<h1 id="common-query-examples">Common Query Examples</h1>
+<p><span class="cmis">CMIS 1.0</span>
+<span class="cmis">CMIS 1.1</span></p>
+<p>A collection of typical query use cases.</p>
+<h2 id="simple-query">Simple Query</h2>
+<p>Find all documents in the repository that are named “hello world”.</p>
+<pre><code class="sql">SELECT *
+FROM cmis:document
+WHERE cmis:name = 'hello world'
+</code></pre>
+
+<h2 id="complex-query-with-joins">Complex query with JOINS</h2>
+<p>Join types <strong>POLICY</strong> with <strong>CLAIM</strong> on property <strong>POLICY_NUM</strong> and <strong>RISK</strong> with <strong>POLICY</strong> on <strong>cmis:objectId</strong>.</p>
+<p><em>(Note: Not all repositories support JOIN)</em></p>
+<pre><code class="sql">SELECT Y.CLAIM_NUM, X.PROPERTY_ADDRESS, Y.DAMAGE_ESTIMATES, Z.BAND
+FROM (POLICY AS X JOIN CLAIMS AS Y ON X.POLICY_NUM = Y.POLICY_NUM)
+ JOIN RISK AS Z ON X.cmis:objectId = Z.cmis:objectId
+WHERE (100000 = ANY Y.DAMAGE_ESTIMATES) AND Z.BAND > 3
+</code></pre>
+
+<h2 id="text-search-query">Text search query</h2>
+<p>Find all documents that have at least one of the words “president”, “chancellor” or “directory” in the content. Depending on the repository and the repository configuration, also property values are included.</p>
+<pre><code class="sql">SELECT cmis:objectId, cmis:name, SCORE() AS score
+FROM cmis:document
+WHERE CONTAINS('president chancellor directory')
+</code></pre>
+
+<h2 id="query-for-multi-value-property">Query for multi-value property</h2>
+<p>Find all objects of type <strong>my:cars</strong> that have a radio or airbag as feature (<strong>my:features</strong> is a multi-value property).</p>
+<pre><code class="sql">SELECT cmis:objectId, cmis:name, my:features
+FROM my:cars
+WHERE ANY my:features IN ('radio', 'airbag')
+</code></pre>
+
+<h2 id="query-for-secondary-types">Query for secondary types</h2>
+<p><span class="cmis">CMIS 1.1</span></p>
+<p>Find all documents that have a destruction date of 2015-12-31 (midnight UTC) in the secondary type <strong>cmis:rm_destructionRetention</strong>.</p>
+<p><em>(Note: Repository does not have to support JOIN)</em></p>
+<pre><code class="sql">SELECT cmis:objectId, cmis:name
+FROM cmis:document JOIN cmis:rm_destructionRetention
+ ON cmis:objectId = cmis:rm_destructionRetention:objectId
+WHERE cmis:rm_destructionDate = TIMESTAMP '2015-12-31T00:00:00.000Z'
+</code></pre></div>
+
+ </div>
+
+ <footer class="col-md-12 text-center">
+ <hr>
+ <p>
+ </footer>
+
+ <script src="../../js/jquery-1.10.2.min.js"></script>
+ <script src="../../js/bootstrap-3.0.3.min.js"></script>
+ <script src="../../js/highlight.pack.js"></script>
+ <script>hljs.initHighlightingOnLoad();</script>
+ <script>
+ var base_url = '../..';
+ </script>
+ <script data-main="../../mkdocs/js/search.js" src="../../mkdocs/js/require.js"></script>
+ <script src="../../js/base.js"></script>
+
+ <div class="modal" id="mkdocs_search_modal" tabindex="-1" role="dialog" aria-labelledby="Search Modal" aria-hidden="true">
+ <div class="modal-dialog">
+ <div class="modal-content">
+ <div class="modal-header">
+ <button type="button" class="close" data-dismiss="modal">
+ <span aria-hidden="true">×</span>
+ <span class="sr-only">Close</span>
+ </button>
+ <h4 class="modal-title" id="exampleModalLabel">Search</h4>
+ </div>
+ <div class="modal-body">
+ <p>
+ From here you can search these documents. Enter your search terms below.
+ </p>
+ <form role="form">
+ <div class="form-group">
+ <input type="text" class="form-control" placeholder="Search..." id="mkdocs-search-query">
+ </div>
+ </form>
+ <div id="mkdocs-search-results"></div>
+ </div>
+ <div class="modal-footer">
+ </div>
+ </div>
+ </div>
+ </div>
+
+ <script type="text/javascript" src="../../js/retina.min.js"></script>
+ </body>
+
+</html>
+<!-- last update: 2016-12-02 19:20:53 -->
\ No newline at end of file
Modified: websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/retention/index.html
==============================================================================
--- websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/retention/index.html (original)
+++ websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/retention/index.html Fri Dec 2 20:05:10 2016
@@ -23,7 +23,7 @@
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta name="author" content="Apache Chemistry">
+ <meta name="author" content="Apache Chemistry">
<link rel="shortcut icon" href="../../img/favicon.ico">
<title>Retention and Holds - Apache Chemistry Samples</title>
@@ -200,6 +200,12 @@
<li >
+ <a href="../query-examples/index.html">Query Examples</a>
+</li>
+
+
+
+<li >
<a href="../changelog/index.html">Retrieving the Change Log</a>
</li>
@@ -347,4 +353,4 @@
</body>
</html>
-<!-- last update: 2016-08-05 12:35:11.202881 -->
\ No newline at end of file
+<!-- last update: 2016-12-02 19:20:55 -->
\ No newline at end of file
Modified: websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/retrieve-objects/index.html
==============================================================================
--- websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/retrieve-objects/index.html (original)
+++ websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/retrieve-objects/index.html Fri Dec 2 20:05:10 2016
@@ -23,7 +23,7 @@
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta name="author" content="Apache Chemistry">
+ <meta name="author" content="Apache Chemistry">
<link rel="shortcut icon" href="../../img/favicon.ico">
<title>Retrieving Objects - Apache Chemistry Samples</title>
@@ -200,6 +200,12 @@
<li >
+ <a href="../query-examples/index.html">Query Examples</a>
+</li>
+
+
+
+<li >
<a href="../changelog/index.html">Retrieving the Change Log</a>
</li>
@@ -503,4 +509,4 @@ ICmisObject cmisObject = Session.GetObje
</body>
</html>
-<!-- last update: 2016-08-05 12:35:10.823095 -->
\ No newline at end of file
+<!-- last update: 2016-12-02 19:20:45 -->
\ No newline at end of file
Modified: websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/types/index.html
==============================================================================
--- websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/types/index.html (original)
+++ websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/types/index.html Fri Dec 2 20:05:10 2016
@@ -23,7 +23,7 @@
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta name="author" content="Apache Chemistry">
+ <meta name="author" content="Apache Chemistry">
<link rel="shortcut icon" href="../../img/favicon.ico">
<title>Working with Types - Apache Chemistry Samples</title>
@@ -200,6 +200,12 @@
<li >
+ <a href="../query-examples/index.html">Query Examples</a>
+</li>
+
+
+
+<li >
<a href="../changelog/index.html">Retrieving the Change Log</a>
</li>
@@ -451,4 +457,4 @@ IObjectType updatedType = session.Update
</body>
</html>
-<!-- last update: 2016-08-05 12:35:10.765465 -->
\ No newline at end of file
+<!-- last update: 2016-12-02 19:20:43 -->
\ No newline at end of file
Modified: websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/update-objects/index.html
==============================================================================
--- websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/update-objects/index.html (original)
+++ websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/update-objects/index.html Fri Dec 2 20:05:10 2016
@@ -23,7 +23,7 @@
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta name="author" content="Apache Chemistry">
+ <meta name="author" content="Apache Chemistry">
<link rel="shortcut icon" href="../../img/favicon.ico">
<title>Updating Objects - Apache Chemistry Samples</title>
@@ -200,6 +200,12 @@
<li >
+ <a href="../query-examples/index.html">Query Examples</a>
+</li>
+
+
+
+<li >
<a href="../changelog/index.html">Retrieving the Change Log</a>
</li>
@@ -418,4 +424,4 @@ List<BulkUpdateObjectIdAndChangeToken
</body>
</html>
-<!-- last update: 2016-08-05 12:35:10.885852 -->
\ No newline at end of file
+<!-- last update: 2016-12-02 19:20:46 -->
\ No newline at end of file
Modified: websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/versions/index.html
==============================================================================
--- websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/versions/index.html (original)
+++ websites/staging/chemistry/trunk/content/docs/cmis-samples/samples/versions/index.html Fri Dec 2 20:05:10 2016
@@ -23,7 +23,7 @@
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta name="author" content="Apache Chemistry">
+ <meta name="author" content="Apache Chemistry">
<link rel="shortcut icon" href="../../img/favicon.ico">
<title>Working with Versions - Apache Chemistry Samples</title>
@@ -200,6 +200,12 @@
<li >
+ <a href="../query-examples/index.html">Query Examples</a>
+</li>
+
+
+
+<li >
<a href="../changelog/index.html">Retrieving the Change Log</a>
</li>
@@ -484,4 +490,4 @@ IObjectId newVersionId = pwc.CheckIn(tru
</body>
</html>
-<!-- last update: 2016-08-05 12:35:11.004872 -->
\ No newline at end of file
+<!-- last update: 2016-12-02 19:20:49 -->
\ No newline at end of file
Modified: websites/staging/chemistry/trunk/content/docs/cmis-samples/sitemap.xml
==============================================================================
Binary files - no diff available.
Modified: websites/staging/chemistry/trunk/content/sitemap.html
==============================================================================
--- websites/staging/chemistry/trunk/content/sitemap.html (original)
+++ websites/staging/chemistry/trunk/content/sitemap.html Fri Dec 2 20:05:10 2016
@@ -189,7 +189,7 @@
<!-- Content -->
<div class="wiki-content"><ul>
<li><a href="/docs/">docs</a><ul>
-<li><a href="/docs/cmis-samples/">Apache Chemistry Samples</a><ul>
+<li><a href="/docs/cmis-samples/">Home - Apache Chemistry Samples</a><ul>
<li><a href="/docs/cmis-samples/404.html">Apache Chemistry Samples</a></li>
<li><a href="/docs/cmis-samples/about/">About - Apache Chemistry Samples</a><ul>
</ul>
@@ -228,7 +228,7 @@
</li>
<li><a href="/docs/cmis-samples/mkdocs/">mkdocs</a><ul>
<li><a href="/docs/cmis-samples/mkdocs/js/">js</a><ul>
-<li><a href="/docs/cmis-samples/mkdocs/js/lunr-0.5.7.min.js">lunr-0.5.7.min.js</a></li>
+<li><a href="/docs/cmis-samples/mkdocs/js/lunr.min.js">lunr.min.js</a></li>
<li><a href="/docs/cmis-samples/mkdocs/js/mustache.min.js">mustache.min.js</a></li>
<li><a href="/docs/cmis-samples/mkdocs/js/require.js">require.js</a></li>
<li><a href="/docs/cmis-samples/mkdocs/js/search-results-template.mustache">search-results-template.mustache</a></li>
@@ -285,6 +285,9 @@
<li><a href="/docs/cmis-samples/samples/queries/">Executing Queries - Apache Chemistry Samples</a><ul>
</ul>
</li>
+<li><a href="/docs/cmis-samples/samples/query-examples/">Query Examples - Apache Chemistry Samples</a><ul>
+</ul>
+</li>
<li><a href="/docs/cmis-samples/samples/retention/">Retention and Holds - Apache Chemistry Samples</a><ul>
</ul>
</li>