• AllowableActions: See cmisAllowableActionsType in the CMIS schema.

·         <Array> AllowableActions: The list of allowable actions for the object.

·          filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

• filterNotValid : The filter specified is not valid

• filterNotValid : The rendition filter specified is not valid

·          filterNotValid: The Repository MUST throw this exception if this property filter input parameter is not valid.

·         filterNotValid: The Repository MUST throw this exception if the property or rendition filter input parameter is not valid.

·          Enum versioningState: An enumeration specifying what the versioing state of the newly-created object MUST be. Valid values are:

·         Enum versioningState: An enumeration specifying what the versioning state of the newly-created object MUST be. If the repository does not support versioning, the repository MUST ignore the versioningState parameter.  Valid values are:

• String changeToken: See section 2.2.1.3.

Required:                                                     False

Required:                                                     True

Required:                                                     False

Required:                                                     True

Required:                                                     False

Required:                                                     True

• <Array> Enum propagation: specifies, how non-direct ACEs can be handled by the repository using the following values (see section 2.2.10.2 applyACL):

• propagate: indicates that the ACEs is to be applied to the given object and all inheriting objects.

• propagate: indicates that the ACEs is to be applied to the given object and all inheriting objects. Propagate incorporates the support for objectonly.

canGetFolderTree

Description:                  Can get the sub-folder tree of the folder (getFolderTree)

Base Object:                 cmis:folder

Operand:                       cmis:folder

Key:                              canGetFolderTree.Folder

Permission:                   Read

Key:                              canGetFolderParent.Folder

Key:                              canGetFolderParent.Object

Key:                              canGetObjectParents.Object

Key:                              canGetParents.Object

canGetRenditions

Description:                  Can retrieve the renditions of this object (getRenditions)

Base Object:                 cmis:document, or cmis:folder

Operand:                       Object

Key:                              canGetRenditions.Object

Permission:                   Read

canGetContentStream

Description:                  Can get the content stream for the Document object (getContentStream)

Base Object:                 cmis:document

Operand:                       Object

Key:                              canGetContentStream.Object

Permission:                   Read

Key:                              canMoveObject.Target

Key:                              canMove.Target

Key:                              canMoveObject.Source

Key:                              canMove.Source

canDeleteObject

Description:                  Can delete an object that is a child of this folder (deleteObject)

Base Object:                 cmis:folder

Operand:                       Folder

Key:                              canDelete.Folder

Permission:                   Read

canGetContentStream

Base Object:                 cmis:document

Action:                          Can get the content stream for the Document object (getContentStream)

Operand:                       Object

Key:                              canViewContent.Object

Permission:                   Read

Key:                              canSetContentStream.Document

Key:                              canSetContent.Document

Key:                              canDeleteContentStream.Document

Key:                              canDeleteContent.Document

Key:                              canRemoveObjectFromFolder.Object

Key:                              canRemoveFromFolder.Object

Key:                              canCheckOut.Document

Key:                              canCheckout.Document

Key:                              canGetAllVersions.Document

Key:                              canGetAllVersions.VersionSeries

• atom:id SHOULD be derived from cmis:objectId.  This id MUST be compliant with atom’s specification and be a valid URI.

• atom:id SHOULD be derived from cmis:objectId.  This id MUST be compliant with atom’s specification and be a valid IRI.

URI Templates MUST only be used with HTTP GET.

On updates, perform the following checks (HTTP & CMIS levels):

1. If If-Match header is sent by client, ETag value is pulled from HTTP header If-Match per RFC2616. The supplied ETag is compared against the ETag on the server. If the match fails, then status code 412 is used.

2. If cmis:changeToken property is supplied by the client, compare the supplied and the cmis:changeToken on the server. If the comparison fails, then return status code 409 per CMIS.

3. If ETag and cmis:changeToken are both specified, the HTTP If-Match check should be performed first.

• checkedout: The document MUST be created in the checked-out state.

• checkedout: The document MUST be created in the checked-out state. The checked-out document MAY be visible to other users.

Description: Reverses the effect of a check-out. Removes the private working copy of the checked-out document, allowing other documents in the version series to be checked out again.

Description: Reverses the effect of a check-out. Removes the private working copy of the checked-out document, allowing other documents in the version series to be checked out again. If the private working copy has been created by createDocument, cancelCheckOut MUST delete the created document.

If a value is not provided for a property, the property is in a “value not set” state. There is no “null” value for a property. Through protocol binding, a property is either not set, or is set to a particular value or a list of values.

A multi-valued property is either set or not set in its entirety. An individual value of a multi-valued property MUST NOT be in an individual “value not set” state and hold a position in the list of values. An empty list of values MUST NOT be allowed.

A property, either single-valued or multi-valued, MAY be in a "not set" state. CMIS does not support "null" property value.

If a multi-valued property is not in a "not set" state, its property value MUST be a non-empty list of individual values. Each individual value in the list MUST NOT be in a "not set" state and MUST conform to the property's property-type.

If a property filter specifies a property that is ‘not set’, it MUST be represented as a property element without a value element.

If a property is requested by a filter, a property element MUST be returned for that property. A repository MAY return additional properties. If a returned property is in a "not set" state, a value element MUST NOT be returned for that property.

localName         String (optional)

<text> ::= /* any char except whitespace */

<text> ::= !! any char except whitespace

Repository MUST return this property with non-empty values when an object is requested and the property filter does not exclude them

Repository MUST return this property with non-empty values when an object is requested and the property filter does not exclude them. If the repository does not support change tokens, this property SHOULD not be set.

Repository MUST return this property with non-empty values when an object is requested and the property filter does not exclude them

Repository MUST return this property with non-empty values when an object is requested and the property filter does not exclude them. If the repository does not support change tokens, this property SHOULD not be set.

Repository MUST return this property with non-empty values when an object is requested and the property filter does not exclude them. If the repository does not support change tokens, this property SHOULD not be set.

Repository MUST return this property with non-empty values when an object is requested and the property filter does not exclude them. If the repository does not support change tokens, this property SHOULD not be set.

SELECT      Y.CLAIM_NUM, X.PROPERTY_ADDRESS, Y.DAMAGE_ESTIMATES

FROM  POLICY AS X JOIN CLAIMS AS Y ON ( X.POLICY_NUM = Y.POLICY_NUM )

WHERE ( 100000 = ANY Y.DAMAGE_ESTIMATES )

SELECT      Y.CLAIM_NUM, X.PROPERTY_ADDRESS, Y.DAMAGE_ESTIMATES

FROM  ( POLICY AS X JOIN CLAIMS AS Y ON X.POLICY_NUM = Y.POLICY_NUM )

WHERE ( 100000 = ANY Y.DAMAGE_ESTIMATES )

• app:edited MUST be cmis:lastModifiedDate
• atom:updated MUST be cmis:lastModifiedDate
• atom:published MUST be cmis:createdDate

• app:edited MUST be cmis:lastModificationDate
• atom:updated MUST be cmis:lastModificationDate
• atom:published MUST be cmis:creationDate

Cardinality:                    Single

Repositories MUST support the escaping of characters using a backslash (\) in the query statement.  The backslash character (\) will be used to escape characters within quoted strings in the query as follows:

1. \’ will represent a single-quote(‘) character
2. \ \ will represent a backslash (\) character
3. Within a LIKE string, \% and \_ will represent the literal characters % and _, respectively.
4. All other instances of a \ are errors.

Character escaping for character strings differs from SQL-92's escaping. A repository MUST support the escaping of certain literal characters in a character string, or in a text expression, using a backslash character (\) in the following manner.  For a <character string literal>, which MUST BE a string enclosed in single-quotes according to the SQL-92 grammar, any occurrence of the single-quote character (') and the escape character (\) in the string MUST BE escaped. This applies to <folder id>, which is a <character string literal>. Furthermore, when a <character string literal> is used in a LIKE predicate, any occurrence of the percent character (%) and the underscore character (_) in the string as a literal MUST BE escaped also. Therefore, within a quoted string in a query:

• The double character \' represents a literal single-quote (') character.
• The double character \ \ represents a literal backslash (\) character.
• Within a LIKE string, the double characters \% and \_ represent a literal percent (%) character and a literal underscore (_) character respectively.
• All other instances of a backslash (\) character are errors.

Using double single-quotes ('') as a SQL-92 way to escape a literal single-quote (') character SHOULD BE supported as an allowable alternative to the double character \'.

For a <text search expression>, a second-level character escaping is required so that the <text search expression> sub-grammar is isolatable from the query statement-level grammar. When a text search expression is composed for a query according to the <text search expression> sub-grammar, any occurrence of the following three characters in the expression as a literal character MUST BE escaped: hyphen (-), single-quote ('), and the escape character (\). Then, before this expression is enclosed in single-quotes and inserted into a CONTAINS() predicate, the query statement-level escaping rules described in the above MUST BE applied. This two-level character escaping allows a query statement parser, using statement-level escaping rules, to correctly extract a <text search expression> as a character string literal independent of the <text search expression> sub-grammar. This extracted <text search expression> can then be correctly interpreted by a full-text search parser independent of the query-statement grammar, using second-level escaping rules. Since the <text search expression> sub-grammar is isolated from the SQL-92 grammar, double single-quotes is not a valid way to escape a literal single-quote character for second-level character escaping.

An <identifier> in a query statement MUST conform to the SQL-92 identifier syntax, and MUST NOT require character escaping.

Example 1:
A query statement that contains a full-text search for the literal string "John'sPresentation-Version2" may be composed as:

SELECT … FROM … WHERE … CONTAINS('John\\\'sPresentation\\-Version2') …

A query parser extracts from this statement the text search expression "John\'sPresentation\-Version2" as a character string literal, and passes it to a text-search parser, which interprets it as a single-word full-text search criteria: John'sPresentation-Version2.

Example 2:

A query statement that contains a full-text search for the phrase "Content Management" may be composed as:

SELECT … FROM … WHERE … CONTAINS('\'Content Management\'') …

A query parser extracts from this statement the text search expression "'Content Management'" as a character string literal, and passes it to a text-search parser, which interprets it as a full-text search criteria consisting of a single phrase: Content Management. There is no second-level escaping.

CMIS objects MAY expose additional information, such as vendor-specific workflow data, beyond the attributes described above. In this respect, the data model can be extended as desired. This specification does not standardize such extensions.

Revision

Date

Editor

Changes Made

1.0

10/15/2010

Florian Müller

First draft